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 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 Winter Program Revenue Category Average Revenue Total Revenue Lessons VALUE Month Ski Area Item Category Amount January Sun Valley Ski Lessons Lessons 3,221 January Silver Mountain Ski Lessons Lessons 3,446 January Bogus Basin Ski Lessons Lessons 3,596 January Brundage Mt Ski Lessons Lessons 3,281 January Grand Targhee Ski Lessons Lessons 3,512 January Schweitzer Basin Ski Lessons Lessons 4,455 January Sun Valley Snowboard Lessons Lessons 1,011 January Silver Mountain Snowboard Lessons Lessons 989 January Bogus Basin Snowboard Lessons Lessons 453 January Brundage Mt Snowboard Lessons Lessons 1,011 January Grand Targhee Snowboard Lessons Lessons 980 January Schweitzer Basin Snowboard Lessons Lessons 1,234 January Sun Valley Nordic Lessons Lessons 500 January Silver Mountain Nordic Lessons 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 January Silver Mountain Racing Program Programs 1,050 January Bogus Basin Racing Program Programs 785 January Brundage Mt Racing Program Programs 901 January Grand Targhee Racing Program Programs 900 January Schweitzer Basin Racing Program Programs 741 January Sun Valley Concessions Concessions 2,232 January Silver Mountain Concessions Concessions 2,001 January Bogus Basin Concessions Concessions 1,999 January Brundage Mt Concessions Concessions 2,449 January Grand Targhee Concessions Concessions 2,333 January Schweitzer Basin Concessions Concessions 2,478 January Sun Valley Instructor Certification Training 2,500 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 January Schweitzer Basin Instructor Certification Training 2,336 February Sun Valley Ski Lessons Lessons 3,215 February Silver Mountain Ski Lessons Lessons 2,645 February Bogus Basin Ski Lessons Lessons 2,214 February Brundage Mt Ski Lessons Lessons 3,051 February Grand Targhee Ski Lessons Lessons 3,752 February Schweitzer Basin Ski Lessons Lessons 3,180 February Sun Valley Snowboard Lessons Lessons 1,011 February Silver Mountain Snowboard Lessons Lessons 1,013 February Bogus Basin Snowboard Lessons Lessons 875 February Brundage Mt Snowboard Lessons Lessons 1,073 February Grand Targhee Snowboard Lessons Lessons 980 February Schweitzer Basin Snowboard Lessons Lessons 1,234 February Sun Valley Nordic Lessons Lessons 422 February Silver Mountain Nordic Lessons Lessons 548 February Bogus Basin Nordic Lessons Lessons 605 February Brundage Mt Nordic Lessons Lessons 429 February Grand Targhee Nordic Lessons Lessons 559 February Schweitzer Basin Nordic Lessons Lessons 475 February Sun Valley Racing Program Programs 1,241 February Silver Mountain Racing Program Programs 1,191 February Bogus Basin Racing Program Programs 1,175 February Brundage Mt Racing Program Programs 966 February Grand Targhee Racing Program Programs 950 February Schweitzer Basin Racing Program Programs 941 February Sun Valley Concessions Concessions 2,250 February Silver Mountain Concessions Concessions 2,001 February Bogus Basin Concessions Concessions 1,999 February Brundage Mt Concessions Concessions 2,449 February Grand Targhee Concessions Concessions 2,547 February Schweitzer Basin Concessions Concessions 2,478 February Sun Valley Instructor Certification Training 2,499 February Silver Mountain Instructor Certification Training 2,610 February Bogus Basin Instructor Certification Training 2,356 February Brundage Mt Instructor Certification Training 2,119 February Grand Targhee Instructor Certification Training 2,515 February Schweitzer Basin Instructor Certification Training 2,444 March Sun Valley Ski Lessons Lessons 3,043 March Silver Mountain Ski Lessons Lessons 2,491 March Bogus Basin Ski Lessons Lessons 2,684 March Brundage Mt Ski Lessons Lessons 3,136 March Grand Targhee Ski Lessons Lessons 3,195 March Schweitzer Basin Ski Lessons Lessons 2,852 March Sun Valley Snowboard Lessons Lessons 1,088 March Silver Mountain Snowboard Lessons Lessons 1,002 March Bogus Basin Snowboard Lessons Lessons 829 March Brundage Mt Snowboard Lessons Lessons 1,041 March Grand Targhee Snowboard Lessons Lessons 879 March Schweitzer Basin Snowboard Lessons Lessons 801 March Sun Valley Nordic Lessons Lessons 489 March Silver Mountain Nordic Lessons Lessons 548 March Bogus Basin Nordic Lessons Lessons 456 March Brundage Mt Nordic Lessons Lessons 429 March Grand Targhee Nordic Lessons Lessons 559 March Schweitzer Basin Nordic Lessons Lessons 475 March Sun Valley Racing Program Programs 987 March Silver Mountain Racing Program Programs 950 March Bogus Basin Racing Program Programs 882 March Brundage Mt Racing Program Programs 813 March Grand Targhee Racing Program Programs 751 March Schweitzer Basin Racing Program Programs 780 March Sun Valley Concessions Concessions 2,458 March Silver Mountain Concessions Concessions 2,111 March Bogus Basin Concessions Concessions 1,999 March Brundage Mt Concessions Concessions 2,449 March Grand Targhee Concessions Concessions 2,547 March Schweitzer Basin Concessions Concessions 2,233 March Sun Valley Instructor Certification Training 2,444 March Silver Mountain Instructor Certification Training 2,541 March Bogus Basin Instructor Certification Training 2,356 March Brundage Mt Instructor Certification Training 2,119 March Grand Targhee Instructor Certification Training 2,515 March Schweitzer Basin Instructor Certification Training 2,918

The Answer is in the image, click to view ...

Question: 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.

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: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.

Winter Program Revenue

Category	Average Revenue	Total Revenue
Lessons	#VALUE!




Month	Ski Area	Item	Category	Amount
January	Sun Valley	Ski Lessons	Lessons	3,221
January	Silver Mountain	Ski Lessons	Lessons	3,446
January	Bogus Basin	Ski Lessons	Lessons	3,596
January	Brundage Mt.	Ski Lessons	Lessons	3,281
January	Grand Targhee	Ski Lessons	Lessons	3,512
January	Schweitzer Basin	Ski Lessons	Lessons	4,455
January	Sun Valley	Snowboard Lessons	Lessons	1,011
January	Silver Mountain	Snowboard Lessons	Lessons	989
January	Bogus Basin	Snowboard Lessons	Lessons	453
January	Brundage Mt.	Snowboard Lessons	Lessons	1,011
January	Grand Targhee	Snowboard Lessons	Lessons	980
January	Schweitzer Basin	Snowboard Lessons	Lessons	1,234
January	Sun Valley	Nordic Lessons	Lessons	500
January	Silver Mountain	Nordic Lessons	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
January	Silver Mountain	Racing Program	Programs	1,050
January	Bogus Basin	Racing Program	Programs	785
January	Brundage Mt.	Racing Program	Programs	901
January	Grand Targhee	Racing Program	Programs	900
January	Schweitzer Basin	Racing Program	Programs	741
January	Sun Valley	Concessions	Concessions	2,232
January	Silver Mountain	Concessions	Concessions	2,001
January	Bogus Basin	Concessions	Concessions	1,999
January	Brundage Mt.	Concessions	Concessions	2,449
January	Grand Targhee	Concessions	Concessions	2,333
January	Schweitzer Basin	Concessions	Concessions	2,478
January	Sun Valley	Instructor Certification	Training	2,500
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
January	Schweitzer Basin	Instructor Certification	Training	2,336
February	Sun Valley	Ski Lessons	Lessons	3,215
February	Silver Mountain	Ski Lessons	Lessons	2,645
February	Bogus Basin	Ski Lessons	Lessons	2,214
February	Brundage Mt.	Ski Lessons	Lessons	3,051
February	Grand Targhee	Ski Lessons	Lessons	3,752
February	Schweitzer Basin	Ski Lessons	Lessons	3,180
February	Sun Valley	Snowboard Lessons	Lessons	1,011
February	Silver Mountain	Snowboard Lessons	Lessons	1,013
February	Bogus Basin	Snowboard Lessons	Lessons	875
February	Brundage Mt.	Snowboard Lessons	Lessons	1,073
February	Grand Targhee	Snowboard Lessons	Lessons	980
February	Schweitzer Basin	Snowboard Lessons	Lessons	1,234
February	Sun Valley	Nordic Lessons	Lessons	422
February	Silver Mountain	Nordic Lessons	Lessons	548
February	Bogus Basin	Nordic Lessons	Lessons	605
February	Brundage Mt.	Nordic Lessons	Lessons	429
February	Grand Targhee	Nordic Lessons	Lessons	559
February	Schweitzer Basin	Nordic Lessons	Lessons	475
February	Sun Valley	Racing Program	Programs	1,241
February	Silver Mountain	Racing Program	Programs	1,191
February	Bogus Basin	Racing Program	Programs	1,175
February	Brundage Mt.	Racing Program	Programs	966
February	Grand Targhee	Racing Program	Programs	950
February	Schweitzer Basin	Racing Program	Programs	941
February	Sun Valley	Concessions	Concessions	2,250
February	Silver Mountain	Concessions	Concessions	2,001
February	Bogus Basin	Concessions	Concessions	1,999
February	Brundage Mt.	Concessions	Concessions	2,449
February	Grand Targhee	Concessions	Concessions	2,547
February	Schweitzer Basin	Concessions	Concessions	2,478
February	Sun Valley	Instructor Certification	Training	2,499
February	Silver Mountain	Instructor Certification	Training	2,610
February	Bogus Basin	Instructor Certification	Training	2,356
February	Brundage Mt.	Instructor Certification	Training	2,119
February	Grand Targhee	Instructor Certification	Training	2,515
February	Schweitzer Basin	Instructor Certification	Training	2,444
March	Sun Valley	Ski Lessons	Lessons	3,043
March	Silver Mountain	Ski Lessons	Lessons	2,491
March	Bogus Basin	Ski Lessons	Lessons	2,684
March	Brundage Mt.	Ski Lessons	Lessons	3,136
March	Grand Targhee	Ski Lessons	Lessons	3,195
March	Schweitzer Basin	Ski Lessons	Lessons	2,852
March	Sun Valley	Snowboard Lessons	Lessons	1,088
March	Silver Mountain	Snowboard Lessons	Lessons	1,002
March	Bogus Basin	Snowboard Lessons	Lessons	829
March	Brundage Mt.	Snowboard Lessons	Lessons	1,041
March	Grand Targhee	Snowboard Lessons	Lessons	879
March	Schweitzer Basin	Snowboard Lessons	Lessons	801
March	Sun Valley	Nordic Lessons	Lessons	489
March	Silver Mountain	Nordic Lessons	Lessons	548
March	Bogus Basin	Nordic Lessons	Lessons	456
March	Brundage Mt.	Nordic Lessons	Lessons	429
March	Grand Targhee	Nordic Lessons	Lessons	559
March	Schweitzer Basin	Nordic Lessons	Lessons	475
March	Sun Valley	Racing Program	Programs	987
March	Silver Mountain	Racing Program	Programs	950
March	Bogus Basin	Racing Program	Programs	882
March	Brundage Mt.	Racing Program	Programs	813
March	Grand Targhee	Racing Program	Programs	751
March	Schweitzer Basin	Racing Program	Programs	780
March	Sun Valley	Concessions	Concessions	2,458
March	Silver Mountain	Concessions	Concessions	2,111
March	Bogus Basin	Concessions	Concessions	1,999
March	Brundage Mt.	Concessions	Concessions	2,449
March	Grand Targhee	Concessions	Concessions	2,547
March	Schweitzer Basin	Concessions	Concessions	2,233
March	Sun Valley	Instructor Certification	Training	2,444
March	Silver Mountain	Instructor Certification	Training	2,541
March	Bogus Basin	Instructor Certification	Training	2,356
March	Brundage Mt.	Instructor Certification	Training	2,119
March	Grand Targhee	Instructor Certification	Training	2,515
March	Schweitzer Basin	Instructor Certification	Training	2,918

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 Accounting Questions!

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

help me please 20 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...

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...

1 Open the Excel the file Student_Excel_Comp_Cap1_Winter_Revenue.xlsx downloaded with this project. 2 On the Idaho Store worksheet, in the range B9:B16, use the Fill Series feature to enter interest...

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...

Insert a Line with Markers Chart using the ranges AS:5 and AS.F3. Reposition the Chart between Cells 18 A13 and G27. Edit the Chart Title to Skier Attendance at Sun Valley. Edit the Vertical (Value)...

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...

19 Select the ranges D7:F12 and A15:G21 and format the cells so that when the sheet is 3 protected, the selected ranges are not locked. Protect the sheet and be sure the top check box to protect the...

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...

Redding Industrial Supply had common shares of $6,800 and retained earnings of $4,925 at the beginning of the year. At the end of the year, the balance in common shares is $7,000 and the balance in...

Suppose that the probability that a certain experiment will be successful is 0.4, and let X denote the number of successes that are obtained in 15 independent performances of the experiment. Use the...

The basis of inherited property almost always is ? The property s adjusted basis at the date of death. The property s fair market value at the date of death. Limited to the carryover basis.

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Give an example of a social business situation and what your goal might be in attending the function. (Objective 2)

Your last task before proofreading the annual report youve assembled for Ridgedale Bank is to prepare the last four visual aids. Use the following data, and prepare the appropriate graphic aids. The...

Identify at least five soft skills that employers are seeking in their prospective employees. (Objective 1)