Posted by anki123 some time ago
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. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx. Grader has automatically added your last name to the beginning of the filename. Note: When you open the file, Excel prompts you to fix a circular error. Click OK and continue. 0 2 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. 4 3 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. 15 4 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. 15 5 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. 5 6 Now you are ready to insert a formula with a reference to the number of seats sold for Saturday's performance. In cell B6, inser
Posted by DancesWithWolves some time ago
Posted by rockie some time ago
Posted by Ian Lockhart some time ago
Posted by Highlander is semi-retired from AB some time ago
Posted by Stewie_G some time ago
Posted by Ian Lockhart some time ago
Posted by Md Mamun Ferdous some time ago
Posted by Ian Lockhart some time ago
Posted by Mary1900 some time ago
Posted by gerrymax some time ago
Posted by The Curious Bag some time ago
Posted by Finalios Lyden some time ago
Posted by gentleman2222 some time ago
Posted by elim189 some time ago
Posted by Ice man some time ago
Posted by Melanie some time ago
Posted by Soni Singh some time ago
Posted by Nathaniel Reyes some time ago
Posted by stella maxwell some time ago

Copyright 2020, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy