FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

9. A worker sequentially works on jobs. Each time a job is completed, a new one is begun. Each job, independently, takes a random amount of time having distribution F to complete. However,...

Answered: 1 week ago

Question

★★★★★
The following unadjusted trial balance is for Ace Construction Co. as of the end of its 2013 fiscal year. The June 30, 2012, credit balance of the owners capital account was $53,660, and the owner...

Answered: 1 week ago

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. The Criteria range has been set up for you in the...

Answered: 1 week ago

Question

★★★★★
Question 43 3 pts A debt rating of BB is considered investment grade if the issuing company is publicly traded but it is considered junk if issued by a private company True O False Question 44 3 pts

Answered: 1 week ago

Question

★★★★★
2. (5 points) West Virginia has one of the highest divorce rates in the nation with an annual rate of approximately 5 divorces per 1000 couples. The Marital Counseling Center, Inc. (MCC) thinks that...

Answered: 1 week ago

Question

★★★★★
SuperCandy produces and sells boxed chocolates. The unit selling price is $50, unit variable costs are $40 and total fixed costs are $800 What are breakeven sales in dollars? OA $800 OB $1,000 C....

Answered: 1 week ago

Question

★★★★★
we examined fact-finding on the Internet and how a lot of "facts" are actually not substantiated with evidence and essentially untrue! In this assignment we will examine the fact-checking websites:...

Answered: 1 week ago

Question

★★★★★
Trudel Department Store uses a periodic inventory system. The adjusted trial balance of Trudel Department Store at December 31, 2024, follows: TRUDEL DEPARTMENT STORE Adjusted Trial Balance December...

Answered: 1 week ago

Question

★★★★★
A firm repurchases 10 percent of its outstanding common stock. What is the effect of this treasury stock transaction? O The common stock shares will be permanently retired. O Its debt-to-total...

Answered: 1 week ago

Previous Question Next Question