Enter a 3-D formula in cell C3 on the October worksheet that calculates the over
ID: 3434324 • Letter: E
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.
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
Home Number of Seats Sold per Day Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Total Avg Daily % Orchestra Front 86 262 326 344 342 344 1704 0.40465448 Box Seats 16 56 44 64 64 64 308 0.07314177 Mezzanine Level 1 64 223 242 256 254 256 1295 0.3075279 Balcony Level 1 46 157 169 172 176 184 904 0.21467585 Total Capacity 212 698 781 836 836 848 4211
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.