Enter a 3D formula in cell C3 on the October worksheet that

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,139

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

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 a

Enter a 3D formula in cell C3 on the October worksheet that

Solution

Get Help Now

Submit a Take Down Notice