Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 0 in cell D 2 , create a SUMIFS function to total the Fee when the criteria in cells C 2 and E 2

10 in cell D2, create a SUMIFS function to total the Fee when the criteria in cells C2 and E2 are met.
11 In cell B6, create a COUNTA function to count the number of enrolled students. In cell B7, create a AVERAGE function to average the Fee field in the Enrollment table.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions