Enter a 3-D formula in cell C3 on the October worksheet that calculates the overall percentage of...

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.

David · Accepted Answer

Home
	
	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.

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment