# Exp19_excel_ch09_hoeassessment – ticket sales 1.0

Exp19_Excel_Ch09_HOEAssessment – Ticket Sales 1.0

You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook.

Note: When you open the file, Excel prompts you to fix a circular error.   Click OK and continue.

The first column in the Friday   worksheet contains cells with a different font color and levels of   indentation. You want to fill this formatting across the Saturday and Sunday   worksheets.

Group the Friday, Saturday, and Sunday worksheets. Fill the formatting for   the range A5:A20.

You notice that a formula is   missing on three worksheets. You will insert the formula simultaneously.

With the worksheets still grouped, in cell E21, enter a formula to subtract   the Grand Total Percentage Sold from 1. Apply Bold to the cell. Ungroup the worksheets.

The Totals worksheet contains   summary data. You will insert a hyperlink to the number of seats sold in each   respective worksheet.

On the Totals worksheet, in cell A5, insert a hyperlink to cell C21 in the   Friday worksheet with the ScreenTip text Friday. In cell A6, insert a hyperlink to cell C21 in the   Saturday worksheet with the ScreenTip text Saturday. In cell A7, insert a hyperlink   to cell C21 in the Sunday worksheet with the ScreenTip text Sunday. Test the hyperlinks to ensure   the work correctly.

Now you are ready to insert a   formula with a reference to the number of seats sold for Friday’s   performance.

In cell B5, insert a formula with a 3-D reference to cell C21 in the Friday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Saturday’s   performance.

In cell B6, insert a formula with a 3-D reference to cell C21 in the Saturday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Sunday’s performance.

In cell B7, insert a formula with a 3-D reference to cell C21 in the Sunday   worksheet.

The next section of the Totals   worksheet is designed to display total gross revenue by section.

In cell B11, insert the SUM function with a 3-D reference to calculate the   total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and   Sunday worksheets.

You   are ready to insert a function to calculate the total Orchestra Back gross   revenue.

In cell B12, insert the SUM function with a 3-D reference to calculate the   total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and   Sunday worksheets.

You are ready to insert a   function to calculate the total gross revenue for the Tiers.

In cell B13, insert the SUM function with a 3-D reference to calculate the   total Tiers gross revenue (cell G20) for the Friday, Saturday, and Sunday   worksheets.

The third section of the totals   worksheet needs to link to a value in another workbook.

Open the Exp19_Excel_Ch09_HOEAssessment_Venue.xlsx   workbook. Go back to the Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx   workbook. In cell B17 on the Totals worksheet, insert a link to the Weekend   Evening value (cell C5). Close the Venue workbook.

The worksheet contains a   circular error. Now you want to find and correct it.

On the Totals worksheet, check for errors and correct the formula with the   circular reference.

You want to create a validation   rule to prevent the user from entering too many seats sold. For now, you will   create a validation for just one input cell.

In cell C6 in the Friday worksheet, create a validation rule to allow whole   numbers less than or equal to data stored in cell B6. Enter the input message   title Seats   Sold and the   input message Enter the number of seats sold. (including the period). Use the   Stop alert with the error alert title Invalid Number and the error alert message The number   cannot exceed total seats in section. (including the period). Test the data validation   by attempting to enter 200 in cell C6 and then cancel the change.

You want to unlock data-entry   cells so that the user can change the number of seats sold in the worksheets.

Group the Friday, Saturday, and Sunday worksheets. Select the ranges C6:C8,   C11:C13, and C16:C19 and unlock these cells.

Now that you unlocked data-entry   cells, you are ready to protect the worksheets to prevent users from changing   data in other cells.

Individually, protect each sheet using the default allowances with the   password Expl0r!ng.

Create footer with your name on   the left side, the sheet name code in the center, and the file name code on   the right side of all worksheets.

Mark the workbook as final.

Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

Save and close Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx.   Exit Excel. Submit the file as directed.

Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Essay USA, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

## Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

Essay USA has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

## Essay Writing Services

At Essay USA, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.