Question: On the Class Report worksheet, in cell B 7 , use the database function to count the number of fees ( found in B 6

On the Class Report worksheet, in cell B7, use the database function to count the number of fees (found in B6) for students who meet the criteria specified in A3:F4 in the database EnrollmentTable.
On the Class Report worksheet, in cell B8, use the database function to calculate the average fee (found in B6) for student who meet the criteria specified in A3:F4 in the database EnrollmentTable.
On the Class Report worksheet, in cell B9, use the database function to calculate the total fee (found in B6) for students who meet the criteria specified in A3:F4 in the database EnrollmentTable.
Format the numbers in cell B8 and B9 as currency with 2 decimal places.
On the Class Report worksheet, in cell B 7 , use

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

1 Start Excel, and then open the downloaded file last_exc_ch5-6_ _df.xlsx. (Srader has automatically added your last name to the beginning of the filename. Save the file to the location where you are...

Q:

Instructions On the Class Report worksheet, in cell B7, use the database function to count the number of fees (found in B6) for students who meet the criteria specified in A3:F4 in the database...

Q:

In the Class Report Sheet in B11, enter a function that counts how many students are enrolled. In B12 enter a function that will give you the largest Clothes purchase. In B13 enter a function that...

Q:

In this project, you are an accountant for National Pharmaceutical Sales. You want to make a spreadsheet that contains each sales associate's statistics. Because the company has over 100 sales...

Q:

Lab 3 Project - Excel Ch 6 Open the start file On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales...

Q:

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Q:

In the Enrollment sheet, in cell E2, enter a lookup function that will look up the fee from the Eeelookup Table based on the Class in cell B2. Fill down. Hint The Eeel.okunTable can be found on the...

Q:

AutoSave OFF G Sv e : W YOExcel16Ch05PS2v2_Instructions - Saved to my Mac Q Search in Document Home Insert Draw Design Layout References Mailings Review View Comments Share Aabbccdder v Evv at...

Q:

On the Student Data worksheet, select the range A7:K17, and then name the range Student_Data. With range A7:K17 selected, create a named range for each column in the Student_Data named range using...

Q:

Project Description: You work in the Admissions Office for West Coast University, a mid-sized regional university in California. Your assistant entered a list of college applicants for the Fall 2018...

Q:

For 2014, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is...

Q:

h,0,0 H.W: An infinite disk has a hole its center is at origin on (xy) plane of radius (a ). Find the expression . of (E ) at (0,0,h) a H.W: For the figure shown (a= 3). Find (E ) at (0,0,4) X

Q:

Which of the following is NOT an example of a selective benefit used by interest groups? A . Informational benefits B . Material benefits C . Solidarity benefitsO D . Medicaid benefitsO E . Purposive...

Q:

what do people generally experience when their work matches their needs and interests, when working conditions and rewards such as pay are satisfactory and when employees like thwir coworkers