Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project Description: You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are performed. You started a worksheet
Project Description: 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 ereer data for the next day's permane Steps to Perform: Step 2 Instructions Start Excel Download and open the file named Exp19 Excel Cho1 Cap Grader has automatically added your last name to the beginning of the flename Centering the 1te Sugarhouse Datrict Theatre over the data columns, inomasing the font size and applying a different font color will make it stand out as a ti Merge and center the tide over the range A1G1, change the font size to 20, and apply Purple for color You want the performance date to display, including the weekday, centered below the te Type 4/16/2021 in cell A2, apply the Long Date number format (which includes the day of the week), apply the Nole cell style, and merge and center the date over the range A2 G2 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 tooler with the text Exploring Series on the left side, the sheet name code in the center, and the tie name code on the right side You want to insert a new sow for Orchestra Back Points Possible 0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started