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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
