Question: 2 0 . Insert a blank row between the detailed section and the Summary section. Change the text in cell A 2 2 to bold,
Insert a blank row between the detailed section and the Summary section. Change the text in cell A to bold, pt font.
Format row with the same settings as those in row
Use the data in the range B:F to calculate the Seats in Section, Seats Sold, Seats Not Sold, and Gross Revenue amounts in the Summary section. Sum these amounts in row
Insert a formula in cell E to calculate the average percentage of seats sold that day.
Align Centre the range B:D Display the values in range E:E as percentages with one decimal and right indent these values twice. Display the values in range F:F as currency with zero decimals.
Underline the values in range B:F and apply bold format to the total line. Extend the Outside Border to the entire Summary table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
