excel 2010 chapter 8 403004
Enter a 3 D formula in cell C3 on the October worksheet that calculates the overall percentage of total Sunday Orchestra Front tickets sold based on the total available Orchestra Front seating. The 3 D formula must perform several internal calculations, avoid raw numbers, and use an appropriate mix of relative and mixed references to derive the correct percentage. Format the result with Percent Style. The result is 100%, based on the sum of the Sunday Orchestra Front tickets sold divided by the total available tickets for all four weeks. Copy the formula to the remaining cells in the range C3:G6.
Don't use plagiarized sources. Get Your Custom Essay on
excel 2010 chapter 8 403004
For $10/Page 0nly
| Home | Number of Seats Sold per Day | ||||||
| Seating | Available | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Avg Daily % |
| Orchestra Front | 86 | ||||||
| Box Seats | 16 | ||||||
| Mezzanine Level 1 | 64 | ||||||
| Balcony Level 1 | 46 | ||||||
| Total Capacity | 212 | ||||||
| Revenue per Day | |||||||
| Seating | Seat Price | Sunday | Wednesday | Friday | Saturday Matinee | Saturday Evening | Weekly Totals |
| Orchestra Front | $ 168 | $ 44,016 | $ 54,768 | $ 57,792 | $ 57,456 | $ 57,792 | $ 271,824 |
| Box Seats | $ 250 | 14,000 | 11,000 | 16,000 | 16,000 | 16,000 | 73,000 |
| Mezzanine Level 1 | $ 155 | 34,565 | 37,510 | 39,680 | 39,370 | 39,680 | 190,805 |
| Balcony Level 1 | $ 95 | 14,915 | 16,055 | 16,340 | 16,720 | 17,480 | 81,510 |
| Totals | $ 107,496 | $ 119,333 | $ 129,812 | $ 129,546 | $ 130,952 | $ 617,139 | |
Calculator
Our features
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.