I e

Winter Program Revenue Category Average Revenue Total Revenue Month Item Category Amount anuary Sun Valley Ski Lessons Lessons 3,221 January Silver Mountain Ski Lessons Lessons 3,446 January Bogus Basin Ski Lessons essons 3.596 anuary Brundage Mt Ski Lessons essons 3,281 January Grand Targhee ki Lessons essons 3,512 January Schweitzer Basin Ski Lessons essons 4 455 January Sun Valley Snowboard Lessons essons 1011 January Silver Mountain Snowboard Lessons Lessons 989 January Bogus Basin Snowboard Lessons Lessons 453 January Brundage Mt Snowboard Lessons Lessons ,011 anuary Grand Targhee Snowboard Lessons Lessons 980 January Schweitzer Basin Snowboard Lessons Lessons ,234 January Sun Valley Nordic Lessons Lessons 500 January Silversuntair Nordic Lesson Lessons 541 January Bogus Basin Nordic Lessons Lessons 395 January |Brundage Mt. Nordic Lessons Lessons 425 January Grand Targhee Nordic Lessons Lessons 422 January Schweitzer Basin Nordic Lessons Lessons 548 January Sun Valley Racing Program Programs 888 anuary Silver Mountain Racing Progra Programs ,050 January Bogus Basin Racing Progra Programs 785 Racing Program Programs 901 January Brundage Mt. January Grand Targhee Racing Program Program 900 January Schweitzer Basin Racing Program Programs 741 2,232 January Sun Valley Concessions Concessions Concessions Concessions 2.001 anuary Silver Mountain January Bogus Basin Concessions Concessions 1.999 January Brundage Mt. Concessions Concessions 2,449 Concessions 2,333 January Grand Targhee Concessions January Schweitzer Basin Concessions Concessions 2,478 2,500 January Sun Valley Instructor Certification Training January Silver Mountain Instructor Certification Training 2,610 January Bogus Basin Instructor Certification Training 2.440 January Brundage Mt Instructor Certification Training 2, 119 January Grand Targhee Instructor Certification Training 2.515 Schweitzer Basin Training 2,336 January nstructor Certification Ski Lessons Lessons 3 215 February Sun Valley Collier_Excel_Comp_Cap1_Winter_Revenue Winter Program Revenue 1 of 3 0 ENG 4:43 PM x P W 3/1/2021 e DELL prt sc home end insert delete CE F9 F10 F11 F12 F6 F8 num backspace lock 7 O P home A enter H Kto protect the worksheet and the first two check boxes in the list are selected. Enter the password go. 20 On the Winter Program Revenue sheet, in cell B4, create a DAVERAGE function to calculate 5 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 to calculate the total of the Amount field for the Lessons category. Format the range B4:C4 using Accounting Number Format. 21 In the Winter Program Revenue sheet, click cell A9, and then insert the Recommended 8 sheet Rer the worksheet Revenue