On the Summer 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:A4. In cell C4, create a DSUM function to calculate the total of the Amount field for the Lessons category. Format the range B4:C4 using Accounting Number Format.A1 v XVfx Summer Program Revenue A B C D E Summer Program Revenue IN W Category Average Revenue Total Revenue Lessons CO Month Location Item Category Amount 9 June Lake Sumner Water Ski Lessons Lessons 2,221 10 June Silver Mountain Lake Water Ski Lessons Lessons 2,226 11 June Tehachapi Reserve Water Ski Lessons Lessons 2,596 12 June Leaman Reservoir Water Ski Lessons Lessons 2,281 13 June Mirador Lake Water Ski Lessons Lessons 2,512 14 June Terrace Lake Water Ski Lessons Lessons 2,255 15 June Lake Sumner Wakeboard Lessons Lessons 1,011 16 June Silver Mountain Lake Wakeboard Lessons Lessons 989 17 June Tehachapi Reserve Wakeboard Lessons Lessons 252 18 June Leaman Reservoir Wakeboard Lessons Lessons 1,011 19 June Mirador Lake Wakeboard Lessons Lessons 980 20 June Terrace Lake Wakeboard Lessons Lessons 1,222 21 June Lake Sumner Swim Lessons Lessons 500 22 June Silver Mountain Lake Swim Lessons Lessons 521 23 June Tehachapi Reserve Swim Lessons Lessons 295 24 June Leaman Reservoir Swim Lessons Lessons 225 25 June Mirador Lake Swim Lessons Lessons 222A1 v : XVfx Summer Program Revenue A B C D E F 26 June Terrace Lake Swim Lessons Lessons 528 27 June Lake Sumner Racing Program Programs 888 28 June Silver Mountain Lake Racing Program Programs 1,050 29 June Tehachapi Reserve Racing Program Programs 785 30 June Leaman Reservoir Racing Program Programs 901 31 June Mirador Lake Racing Program Programs 900 32 June Terrace Lake Racing Program Programs 721 33 June Lake Sumner Concessions Concessions 2,222 34 June Silver Mountain Lake Concessions Concessions 2,001 35 June Tehachapi Reserve Concessions Concessions 1,999 36 June Leaman Reservoir Concessions Concessions 2,229 37 June Mirador Lake Concessions Concessions 2,222 38 June Terrace Lake Concessions Concessions 2,278 39 June Lake Sumner Instructor Certification Training 2,500 40 June Silver Mountain Lake Instructor Certification Training 2,610 41 June Tehachapi Reserve Instructor Certification Training 2,220 42 June Leaman Reservoir Instructor Certification Training 2,119 43 June Mirador Lake Instructor Certification Training 2,515 44 June Terrace Lake Instructor Certification Training 2,226 45 July Lake Sumner Water Ski Lessons Lessons 2,215 46 July Silver Mountain Lake Water Ski Lessons Lessons 2,625 47 July Tehachapi Reserve Water Ski Lessons Lessons 2,212 48 July Leaman Reservoir Water Ski Lessons Lessons 2,051 49 July Mirador Lake Water Ski Lessons Lessons 2,752 50 July Terrace Lake Water Ski Lessons Lessons 2,18051 July Lake Sumner Wakeboard Lessons Lessons 1,011 52 July Silver Mountain Lake Wakeboard Lessons Lessons 1,012 53 July Tehachapi Reserve Wakeboard Lessons Lessons 875 54 July Leaman Reservoir Wakeboard Lessons Lessons 1,072 55 July Mirador Lake Wakeboard Lessons Lessons 980 56 July Terrace Lake Wakeboard Lessons Lessons 1,222 57 July Lake Sumner Swim Lessons Lessons 222 58 July Silver Mountain Lake Swim Lessons Lessons 528 59 July Tehachapi Reserve Swim Lessons Lessons 605 60 July Leaman Reservoir Swim Lessons Lessons 229 61 July Mirador Lake Swim Lessons Lessons 559 62 July Terrace Lake Swim Lessons Lessons 275 63 July Lake Sumner Racing Program Programs 1,221 64 July Silver Mountain Lake Racing Program Programs 1,191 65 July Tehachapi Reserve Racing Program Programs 1,175 66 July Leaman Reservoir Racing Program Programs 966 67 July Mirador Lake Racing Program Programs 950 68 July Terrace Lake Racing Program Programs 921 69 July Lake Sumner Concessions Concessions 2,250 70 July Silver Mountain Lake Concessions Concessions 2,001 71 July Tehachapi Reserve Concessions Concessions 1,999 72 July Leaman Reservoir Concessions Concessions 2,229 73 July Mirador Lake Concessions Concessions 2,527 74 July Terrace Lake Concessions Concessions 2,278 75 July Lake Sumner Instructor Certification Training 2,29976 July Silver Mountain Lake Instructor Certification Training 2,610 77 July Tehachapi Reserve Instructor Certification Training 2,256 78 July Leaman Reservoir Instructor Certification Training 2,119 79 July Mirador Lake Instructor Certification Training 2,515 80 July Terrace Lake Instructor Certification Training 2,222 81 August Lake Sumner Water Ski Lessons Lessons 2,022 82 August Silver Mountain Lake Water Ski Lessons Lessons 2,291 83 August Tehachapi Reserve Water Ski Lessons Lessons 2,682 84 August Leaman Reservoir Water Ski Lessons Lessons 2,126 85 August Mirador Lake Water Ski Lessons Lessons 2,195 86 August Terrace Lake Water Ski Lessons Lessons 2,852 87 August Lake Sumner Wakeboard Lessons Lessons 1,088 88 August Silver Mountain Lake Wakeboard Lessons Lessons 1,002 89 August Tehachapi Reserve Wakeboard Lessons Lessons 829 90 August Leaman Reservoir Wakeboard Lessons Lessons 1,021 91 August Mirador Lake Wakeboard Lessons Lessons 879 92 August Terrace Lake Wakeboard Lessons Lessons 801 93 August Lake Sumner Swim Lessons Lessons 289 94 August Silver Mountain Lake Swim Lessons Lessons 528 95 August Tehachapi Reserve Swim Lessons Lessons 256 96 August Leaman Reservoir Swim Lessons Lessons 229 97 August Mirador Lake Swim Lessons Lessons 559 98 August Terrace Lake Swim Lessons Lessons 275 99 August Lake Sumner Racing Program Programs 987 100 August Silver Mountain Lake Racing Program Programs 950 101 August Tehachapi Reserve Racing Program Programs 882102 August 103 August 104 August 105 August 106 August 107 August 108 August 109 August 1' 0 August '1 August ' 2 August ' 3 August '4 August ' 5 August ' 6 August ' 7 ' 8 _1_1_1_1_1_1_1_1 Leaman Reservoir Miraclor Lake Terrace Lake Lake Sumner Silver Mountain Lake Tehachapi Reserve Leaman Reservoir Miraclor Lake Terrace Lake Lake Sumner Silver Mountain Lake Tehachapi Reserve Leaman Reservoir Miraclor Lake Terrace Lake Racing Program Racing Program Racing Program Concessions Concessions Concessions Concessions Concessions Concessions Instructor Certification Instructor Certification Instructor Certification Instructor Certification Instructor Certification Instructor Certification Programs Programs Programs Concessions Concessions Concessions Concessions Concessions Concessions Training Training Training Training Training Training 912 751 799 2,259 2,111 1,999 2,229 2,527 2,222 2,222 2,521 2,256 2,119 2,515 2,919