Question: 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

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 Screen Tip 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

A. Dr. George E. Beeper is a single taxpayer born on September 22, 1970. He lives at 45 Mountain View Dr., Apt. 321, Spokane, WA 99210. Dr. Beepers Social Security number is 775-88-9531. Dr. Beeper...

Step Instructions Points Possible Exp19_Excel_Ch09_HOEAssessment - Ticket Sales 1.0 Project Description: You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway...

Exp19_Excel_Ch09_HOEAssessment - Ticket Sales 1.0 Step Instructions Points Possible 9 You are ready to insert a function to calculate the total Orchestra Back gross revenue. 5 Project Description:...

File Draw Home Formus Data Rew View Hop Share Comments FIP Page Layout 2.1 E Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Becaule from the Intumat can contain views....

(MIS) please help me with the Excel thankyou start with number 2 Assignment Instructions Exp19 Excel Ch09_HOEAssessment TicketSales.xlsx Grader has automatically added your last name to the beginning...

Grador otro Exp19_Excel_Ch09_CapAssessment_Tips Project Description: Your friend Kimo is a server at a restaurant. He downloaded data for his customers food and beverage purchases of the week. You...

please help with as much as possible! HUDOTE 0 2 8 3 5 Start Excel. Download and open the file namned Exp19_Excel_Cho9_Cap Assessment_Tips.xlsx. Grader has automatically added your last name to the...

Exp19_Excel_Ch09_Cap_Housecleaning Service Project Description: You manage a housecleaning service. As manager, you schedule the cleaners with dients, provide cleaning supplies, and insure the clear...

Step Possible 1 0 2 3 3 3 4 2 5 10 Instructions Start Excel. Download and open the file named Exp19_Exce_Cho9_Cap_House Cleaners.xlsx. Grader has automatically added your last name to the beginning...

DIRECTIONS: DATA: FINAL RESULT SHOULD LOOK LIKE: Excel 2 Grader - Instructions Exp19_Excel_Ch09_ML1_Expenses Project Description: You carefully tracked your income and expenses for three months using...

1. Min Jee Woo is an artist who makes her living selling her artwork at art fairs around the Midwest. Min Jee is using an Excel workbook with multiple worksheets to summarize the sales of her artwork...

Are there any operating functions that should never be outsourced? Explain your answer.

Gamma Ltd. acquired a tract of land with a building for $600,000. The closing statement indicated that the lands assessed tax value was $400,000 and the buildings value was $200,000. The land was...

Lance seems to always be interested in demonstrating concerns for other emotions and interest finding common ground and responding lance is what type of listener

P&Gs impressive portfolio includes some of the strongest brand names in the world. What are some of the challenges and risks associated with being the market leader in so many categories?

The stock in Camel Corporation is owned by Albert and Tomoko, who are unrelated. Albert owns 30% and Tomoko owns 70% of the stock in Camel Corporation. All of Camel Corporations assets were acquired...

Heron Corporation, a calendar year, accrual basis taxpayer, provides the following information for this year and asks you to prepare Schedule M-1: Net income per books (after-tax) ....................

Accountants for Morganson, Inc. have assembled the following data for the year ended December 31, 2018: Prepare Morganson's statement of cash flows using the indirect method. Include an accompanying...

The income statement and additional data of Value Corporation follow: a. Collections from customers are $13,000 more than sales. b. Dividend revenue, interest expense, and income tax expense equal...

McCann-Erickson advertising agency wanted to find out why Raid roach spray outsold Combat insecticide disks in certain markets. It used a technique called consumer drawings to unlock motivation and...

4. Present multiple themes at once. Then you will get to know a little about how others think, when some of the themes are rejected.

5. Get a third party to mediate, so that both parties have the opportunity to go back to their original negotiating point that they had before the third party put forward his/her proposal.

1. Discuss the following statements: a) What we seek to achieve is different from why we seek to achieve it. b) Thoughts are different from what we are thinking about. c) Writing to find out what one...