Posted by Chromeman some time ago
Posted by Brandon Maciel some time ago
Posted by Halskiisaklink some time ago
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 JazzyAnswersAndAsks some time ago
Posted by Ice man some time ago
Posted by Black Mystique some time ago
Posted by stella maxwell some time ago
Posted by Jive Turkey some time ago
Posted by David Allison some time ago
Posted by Aditya Kumar Choudhary some time ago
Posted by RashidS some time ago
Posted by D3thRein some time ago
Posted by The Curious Bag some time ago
Posted by The Curious Bag some time ago

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy