Chegg does not allow me to attach anything but I would be able to email anyone t
ID: 651134 • Letter: C
Question
Chegg does not allow me to attach anything but I would be able to email anyone the spread sheet in question
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.
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,139Explanation / Answer
=avg(c3)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.