e01c1TicketSales

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.

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. 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 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. 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. 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. 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. 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 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. 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. 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. 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.

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. 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. 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. 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. 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

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. 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. 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. 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. 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. 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.

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. 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. 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. 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.

19. Apply Outside Borders to the range A4:G4, the range A5:G8, A9:G12, and A13:G17 one range at a time. 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 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. 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. 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.

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. 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. 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. 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. 25. Save and close the file. Exit Excel. Based on your instructor’s directions, submit e01c1TicketSales_LastFirst.

Answers

Related Questions

MBA 560 Southern New Hampshire University BMW So...

My product idea is: The new idea for BMW is to create a new product for their electric bike (e-bike) collection that is called the Solar-Power e-bike....

Moravian College Unit 3 Sexual Identity & Gender...

While you will be evaluated on the quality and clarity of the aforementioned required components, not simply on the quantity of your submission, pleas...

Influence of Media in Society & Chinese Identity...

Guidelines for Reading NotesPurposeReading notes are a way for you to document the main ideas of an academic text; a tool for helping you process and...

Pasadena Case against Aristotle Good Will Kantia...

Kant Reading notesCase against AristotleThe life of reason is not necessarily a happy one (pg. 47)“Categorical imperatives” vs. “counsels of pru...

Barry University Consider Buddhist Concept of Im...

1) If there is no self, how can there be reincarnation? who is it that will come back in future realities?2)If there’s no self, who is that sufferin...

MGT 173 University of California Program Budget...

Program Budget. Present a revenue budget (sources of funds) and an expense budget (uses of funds). Describe the financial resources needed to accompli...

German University of Technology Digital Logic Ci...

Assignment Tasks Q1. For the logic expression f= X1 X2’ X3’ + X2 X3 + X3’ perform the following: i. Obtain the standard SOP expression ii. Obtai...

University of Nairobi Language Learner in Terms...

For this assignment, you are required to write an academic essay based on analyzing a text written by a language learner based on a number of linguist...

Waldorf University Fuenteovejuna and Decline of...

write 1200 words for part 1 and 1200 words for part 2EIGHT PAGES for BOTH questions. 12 Font, doubled space, 1-inch margins..For Question one you will...

Grossmont College How to Get Your Green Card in...

You will have three hours to read and write your essay. Once the three hours are up, you will be forced to submit the essay. You let me know when I sh...

Compassion and Tolerance & Jesus and Relativism...

Read the attached pages and answer.1. What is the different between the kind of "compassion and tolerance" taught by relativism and that taught by Jes...

Colorado School of English Christian Doctrine Qu...

Chapter 10 and 11 from the book Called to Believe: A Brief Introduction to Christian Doctrine: A Brief Introduction to Doctrinal Theology.Steven P. Mu...

MBA 560 Southern New Hampshire Milestone 3 Solar...

My product idea is: The new idea for BMW is to create a new product for their electric bike (e-bike) collection that is called the Solar-Power e-bike....

BUS 303 Ashford Week 2 Tasks Duties and Responsi...

A job description is a useful tool that describes all the tasks, duties, and responsibilities of a position. The primary function of this assignment i...

Grand Canyon University General Motors Company D...

Prior to developing your case study, you will create an outline and list of potential resources for your case development. Include a minimum of three...

Kaplan University East Harlem Neighborhood SWOT...

There are 3 parts to this assignment.Part 1 is a power point presentation of east harlem neighborhood pictures of the community like schools, churches...

SYD 3792 Florida Atlantic University The Power o...

You would need to watch a 57 minute documentary (I will send the link) and answer 3 questions given by my professor in a 2 page (double spaced) essay...

Emerson College The Foreign Student by Susan Cho...

First, re-read the Research Project Description (Links to an external site.)–you'll need to log into Google with your Emerson email address.Proj...

Writing : Art Work...

Surname 1Rain Steam and SpeedStudent name:Instructors name:Date:The painting was presented in 1844 but it might have been painted much earlier. Turner...

HSE 410 Ashford University Evidence based Group...

Review this module's readings to become familiar with the different types of groups this task will address. Note how groups are designed to be evi...

College of Charleston Financialization of Housin...

Please write a short (limit 1000 words) essay on the United Nations Human Rights Council's 2017 report on the financialization of housing (relevan...

Risk and Risk Management Techniques Threats and...

What’s the Worst That Could Happen?This is a question you should (and will be) asking yourself as you take on a security officer role. Quite honestl...

University of the Cumberlands Blockchain & The B...

Industry experts believe blockchain is a technology that has the potential to affect the business of most IT professionals in the next five years. Pic...

Multi Domestic Strategy Journal Article 4...

Pick one of the following terms for your research: economies of scale, economies of scope, global companies, global teams, globalization strategy, int...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it