Description
Top of Form
1 | Start Excel. Download and open the file named Exp19_Excel_Ch01_Cap_TicketSales.xlsx. Grader has automatically added your last name to the beginning of the filename. | 0 |
2 | Centering the title Sugarhouse District Theatre over the data columns, increasing the font size, and applying a different font color will make it stand out as a title. | 5 |
3 | You want the performance date to display, including the weekday, centered below the title. | 6 |
4 | You want to insert a new row for Orchestra Back. | 5 |
5 | Indenting the specific seating sections will distinguish the specific section locations from the main section headings. After indenting text, the column needs to be widened to display the text. | 6 |
6 | The column heading in cell A4 is formatted. You want to copy those formats to the other headings on row 4. | 2 |
7 | Wrapping text within each cell will improve the readability of the column headings. | 4 |
8 | You decided to change the word Purchased to the word Sold. | 3 |
9 | The worksheet contains spelling errors that need to be corrected. | 2 |
10 | Enter the formula to calculate the percentage of seats sold for the performance. | 4 |
11 | Enter the formula to calculate the percentage of seats not sold. | 4 |
12 | Enter the formula to calculate the gross revenue from the seats that were sold. | 4 |
13 | Formatting the monetary values in the Price Per Seat and Gross Revenue columns improves the readability. | 5 |
14 | The formula results in the Percentage Sold and Percentage Not Sold columns are hard to read as decimal values. Formatting the results to display percent symbols will improve the readability. | 5 |
15 | After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data. | 5 |
16 | You want to center the values in the Seats in Section and Seats Sold columns. | 10 |
17 | Borders will help people distinguish different seating sections. | 8 |
18 | Now that you have formatted the worksheet, you need to select margin settings so that any printouts you make will look professional. | 5 |
19 | 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. | 6 |
20 | Rename Sheet 1 as 4-16-2021. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021. | 5 |
21 | You want to use the duplicate worksheet to be ready to enter data for the April 17 performance data. | 6 |
22 | Save and close Exp19_Excel_Ch01_Cap_TicketSales.xlsx. Exit Excel. Submit the file as directed. | 0 |
Close
Bottom of Form