After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data.
Insert a new column G. Select and move the range D4:D17 to the range G4:G17. Delete the empty column D.
You want to center the values in the Seats in Section and Seats Sold columns.
Center horizontally the data in the range B6:C17. Apply Align Right and indent twice the data in the range D6:E17.
Borders will help people distinguish different seating sections.
Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time.
Now that you have formatted the worksheet, you need to select margin settings so that any printouts you make will look professional.
Set a 1″ top margin and center the worksheet horizontally between the left and right margins.
Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.
Rename Sheet 1 as 4-16-2021. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.
You want to use the duplicate worksheet to be ready to enter data for the April 17 performance data.
Change the date in cell A2 to Saturday, April 17, 2021. Delete the values in the range C6:C17.
Save and close Exp19_Excel_Ch01_Cap_TicketSales.xlsx. Exit Excel. Submit the file as directed.
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |