CISY1225 Southern Methodist University Exp19 Excel Ch01 Cap Ticket_Sales

Reading Time: < 1 minute

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.