Question: Excel Problem On the Winter Program Revenue sheet, in cell B4, create a DAVERAGE function to calculate the average of the Amount field for the

Excel Problem
Excel Problem On the Winter Program Revenue
Excel Problem On the Winter Program Revenue
On the Winter Program Revenue sheet, in cell B4, create a DAVERAGE function to calculate the average of the Amount field for the Lessons category. The Criteria range has been set up for you in the range A3:44. In cell C4, create a DSUM to calculate the total of the Amount field for the Lessons category. Format the range B4:C4 using Accounting Number Format. 5 Home Dute Review Viewer Help Share Comments Insert DrawPage Layout Ford 33 PEF SA map P w CANTAUTOSAVE o tome DAVERAGE A D Winter Program Revenue J. Category Average Revenue Total Revenue 4 AVERAGE G 1 N 0 P 1 7 X DAVE Art 2221 eseans in a Ta 2512 45 1,011 Month SATA 10 Je Sun Valley Sales Le 11 nary She Mount SL Les ay Hogan Stil L 13 EM SAL Les HY Gandare Saites Lo 15 January Schweizer Basin Si Le 16 ianuary Sun Valley Seaboard mom 17 January Slver Me Snowboard Le 18 Gay Browboard Les 19 January runde Snowboard Le 20 january Grand To Snowboard 21 January Schwerin Sherboards som 22 January Sun Valley Non 23 Mountain Norden Locom M Bolsin Nordic Lotion Lesson 25 ianuary Bandage Nords Le 2 ay Grand The Non Bm More Cely App Corts Product Information Phone Onder CA 453 1,01 12 500 425 4.32 Selendance Expense Report Winter Program Revue

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 General Management Questions!