You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are performed. You started a worksheet that lists the number of seats in each section (orchestra and the tiers) and the number of seats sold for a specific performance date. You will calculate the percentage of sold and unsold seats and gross revenue by section. You will format the worksheet to improve readability and copy the final worksheet to use as a template to enter data for the next day’s performance.

Format the Title and Enter the Date

Your first task is to format the title by centering it over the data col-umns, enlarging the font size, and applying a different font color. Next, you will enter and format the performance date on the next row.

1. Open e01c1TicketSales and save it as e01c1TicketSales_LastFirst.

2. Merge and center the title over the range A1:G1, change the font size to 20, and then apply Purple font color.

3. Type 4/16/2021 in cell A2, then apply the Long Date number format, apply the Note cell style, and then merge and center the date over the range A2:G2.

Format Seating Labels

Previously, you entered section labels Orchestra Front and Tiers to identify the seating sections. You will insert a new row for Orchestra Back, indent the specific seating sections to distinguish these labels from the main labels, and adjust the column width.

4. Insert a new row above row 9, between Right and Left. The new row is row 9. Copy the data from cell A5 to cell A9 and change the data in cell A9 from Front to Back.

5. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17.

6. Change the width of column A to 18.

Format Labels, Replace Text, and Checking Spelling Previously, you applied Lavender fill and bold to the label in cell A4. You will use Format Painter to copy the formats to the other column labels on row 4. Then you will apply other alignment settings to the labels, replace Purchased with Sold, and check the spelling in the worksheet.

7. Use Format Painter to copy the formats in cell A4 to the range B4:G4.

8. Wrap text and horizontally center the labels in the range A4:G4 and set the height of row 4 to 30.

9. Find all occurrences of Purchased and replace them with Sold.

10. Check the spelling in the worksheet and correct all spelling errors.

Insert Formulas and Apply Number Formats

You are ready to enter formulas in the last three columns to calculate the percentage of seats sold at the performance, percentage of unsold seats (i.e., empty), and the gross revenue for the sold seats.

11. Calculate the Percentage Sold in cell E6 by dividing the Seats Sold by the Seats in Section. Copy the formula to the range E7:E17. Delete the formula in cells E9 and E13 because those are empty rows.

12. Calculate the Percentage Not Sold in cell F6 by subtracting the Percentage Sold from 1. Copy the formula to the range F7:F17. Delete the formula in cells F9 and F13 because those are empty rows.

13. Calculate the Gross Revenue in cell G6 by multiplying the Seats Sold by the Price Per Seat. Copy the formula to the range G7:G17. Delete the formula in cells G9 and G13 because those are empty rows.

14. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17.

15. Apply Percentage Style with one decimal place to the range E6:F17.

Move a Column, Adjust Alignment, and Add Borders After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data. In addition, you decide to center the values in the Seats in Section and Seats Sold columns.

16. Insert a new column G. Select and move the range D4:D17 to the range G4:G17. Delete the empty column D.

17. Center horizontally the data in the range B6:C17.

18. Apply Align Right and indent twice the data in the range D6:E17.

19. Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time.

Format the Worksheet

To finalize the worksheet, you are ready to set a larger top margin, center the worksheet between the left and right margins, and insert a footer. Finally, you will rename the sheet tab, copy the worksheet, and delete some data to use a template for the next performance.

20. Set a 1″ top margin and center the worksheet horizontally between the left and right margins.

23. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.

21. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

22. Rename Sheet1 as 4-16-2021.

24. Change the date in cell A2 to 4/17/2021. Keep the Long Date Format. Delete the values in the range C6:C17.

25. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e01c1TicketSales_LastFirst.

You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are performed. You started a worksheet that lists the number of seats in each section (orchestra and the tiers) and the number of seats sold for a specific performance date. You will calculate the percentage of sold and unsold seats and gross revenue by section. You will format the worksheet to improve readability and copy the final worksheet to use as a template to enter data for the next day’s performance.

Format the Title and Enter the Date

Your first task is to format the title by centering it over the data col-umns, enlarging the font size, and applying a different font color. Next, you will enter and format the performance date on the next row.

1. Open e01c1TicketSales and save it as e01c1TicketSales_LastFirst.

2. Merge and center the title over the range A1:G1, change the font size to 20, and then apply Purple font color.

3. Type 4/16/2021 in cell A2, then apply the Long Date number format, apply the Note cell style, and then merge and center the date over the range A2:G2.

Format Seating Labels

Previously, you entered section labels Orchestra Front and Tiers to identify the seating sections. You will insert a new row for Orchestra Back, indent the specific seating sections to distinguish these labels from the main labels, and adjust the column width.

4. Insert a new row above row 9, between Right and Left. The new row is row 9. Copy the data from cell A5 to cell A9 and change the data in cell A9 from Front to Back.

5. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17.

6. Change the width of column A to 18.

Format Labels, Replace Text, and Checking Spelling Previously, you applied Lavender fill and bold to the label in cell A4. You will use Format Painter to copy the formats to the other column labels on row 4. Then you will apply other alignment settings to the labels, replace Purchased with Sold, and check the spelling in the worksheet.

7. Use Format Painter to copy the formats in cell A4 to the range B4:G4.

8. Wrap text and horizontally center the labels in the range A4:G4 and set the height of row 4 to 30.

9. Find all occurrences of Purchased and replace them with Sold.

10. Check the spelling in the worksheet and correct all spelling errors.

Insert Formulas and Apply Number Formats

You are ready to enter formulas in the last three columns to calculate the percentage of seats sold at the performance, percentage of unsold seats (i.e., empty), and the gross revenue for the sold seats.

11. Calculate the Percentage Sold in cell E6 by dividing the Seats Sold by the Seats in Section. Copy the formula to the range E7:E17. Delete the formula in cells E9 and E13 because those are empty rows.

12. Calculate the Percentage Not Sold in cell F6 by subtracting the Percentage Sold from 1. Copy the formula to the range F7:F17. Delete the formula in cells F9 and F13 because those are empty rows.

13. Calculate the Gross Revenue in cell G6 by multiplying the Seats Sold by the Price Per Seat. Copy the formula to the range G7:G17. Delete the formula in cells G9 and G13 because those are empty rows.

14. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17.

15. Apply Percentage Style with one decimal place to the range E6:F17.

Move a Column, Adjust Alignment, and Add Borders After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data. In addition, you decide to center the values in the Seats in Section and Seats Sold columns.

16. Insert a new column G. Select and move the range D4:D17 to the range G4:G17. Delete the empty column D.

17. Center horizontally the data in the range B6:C17.

18. Apply Align Right and indent twice the data in the range D6:E17.

19. Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time.

Format the Worksheet

To finalize the worksheet, you are ready to set a larger top margin, center the worksheet between the left and right margins, and insert a footer. Finally, you will rename the sheet tab, copy the worksheet, and delete some data to use a template for the next performance.

20. Set a 1″ top margin and center the worksheet horizontally between the left and right margins.

23. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.

21. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

22. Rename Sheet1 as 4-16-2021.

24. Change the date in cell A2 to 4/17/2021. Keep the Long Date Format. Delete the values in the range C6:C17.

25. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e01c1TicketSales_LastFirst.

You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are performed. You started a worksheet that lists the number of seats in each section (orchestra and the tiers) and the number of seats sold for a specific performance date. You will calculate the percentage of sold and unsold seats and gross revenue by section. You will format the worksheet to improve readability and copy the final worksheet to use as a template to enter data for the next day’s performance.

Format the Title and Enter the Date

Your first task is to format the title by centering it over the data col-umns, enlarging the font size, and applying a different font color. Next, you will enter and format the performance date on the next row.

1. Open e01c1TicketSales and save it as e01c1TicketSales_LastFirst.

2. Merge and center the title over the range A1:G1, change the font size to 20, and then apply Purple font color.

3. Type 4/16/2021 in cell A2, then apply the Long Date number format, apply the Note cell style, and then merge and center the date over the range A2:G2.

Format Seating Labels

Previously, you entered section labels Orchestra Front and Tiers to identify the seating sections. You will insert a new row for Orchestra Back, indent the specific seating sections to distinguish these labels from the main labels, and adjust the column width.

4. Insert a new row above row 9, between Right and Left. The new row is row 9. Copy the data from cell A5 to cell A9 and change the data in cell A9 from Front to Back.

5. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17.

6. Change the width of column A to 18.

Format Labels, Replace Text, and Checking Spelling Previously, you applied Lavender fill and bold to the label in cell A4. You will use Format Painter to copy the formats to the other column labels on row 4. Then you will apply other alignment settings to the labels, replace Purchased with Sold, and check the spelling in the worksheet.

7. Use Format Painter to copy the formats in cell A4 to the range B4:G4.

8. Wrap text and horizontally center the labels in the range A4:G4 and set the height of row 4 to 30.

9. Find all occurrences of Purchased and replace them with Sold.

10. Check the spelling in the worksheet and correct all spelling errors.

Insert Formulas and Apply Number Formats

You are ready to enter formulas in the last three columns to calculate the percentage of seats sold at the performance, percentage of unsold seats (i.e., empty), and the gross revenue for the sold seats.

11. Calculate the Percentage Sold in cell E6 by dividing the Seats Sold by the Seats in Section. Copy the formula to the range E7:E17. Delete the formula in cells E9 and E13 because those are empty rows.

12. Calculate the Percentage Not Sold in cell F6 by subtracting the Percentage Sold from 1. Copy the formula to the range F7:F17. Delete the formula in cells F9 and F13 because those are empty rows.

13. Calculate the Gross Revenue in cell G6 by multiplying the Seats Sold by the Price Per Seat. Copy the formula to the range G7:G17. Delete the formula in cells G9 and G13 because those are empty rows.

14. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17.

15. Apply Percentage Style with one decimal place to the range E6:F17.

Move a Column, Adjust Alignment, and Add Borders After reviewing the data, you decide to move the Price Per Seat to be to the left of the Gross Revenue data. In addition, you decide to center the values in the Seats in Section and Seats Sold columns.

16. Insert a new column G. Select and move the range D4:D17 to the range G4:G17. Delete the empty column D.

17. Center horizontally the data in the range B6:C17.

18. Apply Align Right and indent twice the data in the range D6:E17.

19. Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time.

Format the Worksheet

To finalize the worksheet, you are ready to set a larger top margin, center the worksheet between the left and right margins, and insert a footer. Finally, you will rename the sheet tab, copy the worksheet, and delete some data to use a template for the next performance.

20. Set a 1″ top margin and center the worksheet horizontally between the left and right margins.

23. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.

21. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

22. Rename Sheet1 as 4-16-2021.

24. Change the date in cell A2 to 4/17/2021. Keep the Long Date Format. Delete the values in the range C6:C17.

25. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e01c1TicketSales_LastFirst.

Format the Title and Enter the Date

Format the Title and Enter the Date

1. Open e01c1TicketSales and save it as e01c1TicketSales_LastFirst.

1. Open e01c1TicketSales and save it as e01c1TicketSales_LastFirst.

Format Seating Labels

Format Seating Labels

5. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17.

5. Indent twice the data in the ranges A6:A8, A10:A12, and A14:A17.

6. Change the width of column A to 18.

6. Change the width of column A to 18.

7. Use Format Painter to copy the formats in cell A4 to the range B4:G4.

7. Use Format Painter to copy the formats in cell A4 to the range B4:G4.

9. Find all occurrences of Purchased and replace them with Sold.

9. Find all occurrences of Purchased and replace them with Sold.

10. Check the spelling in the worksheet and correct all spelling errors.

10. Check the spelling in the worksheet and correct all spelling errors.

Insert Formulas and Apply Number Formats

Insert Formulas and Apply Number Formats

14. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17.

14. Apply Accounting Number Format with zero decimal places to the ranges D6:D17 and G6:G17.

15. Apply Percentage Style with one decimal place to the range E6:F17.

15. Apply Percentage Style with one decimal place to the range E6:F17.

17. Center horizontally the data in the range B6:C17.

17. Center horizontally the data in the range B6:C17.

18. Apply Align Right and indent twice the data in the range D6:E17.

18. Apply Align Right and indent twice the data in the range D6:E17.

Format the Worksheet

Format the Worksheet

20. Set a 1″ top margin and center the worksheet horizontally between the left and right margins.

20. Set a 1″ top margin and center the worksheet horizontally between the left and right margins.

23. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.

23. Copy the worksheet, place the duplicate to the right, and rename it as 4-17-2021.

22. Rename Sheet1 as 4-16-2021.

22. Rename Sheet1 as 4-16-2021.