Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started