On the Week 1 worksheet, select the number of daily OrchestraFront tickets sold (in the range C3:G3). Create a validation ruleto accept only whole numbers between 0 and theavailable seating limit in cell B3. Create an input message, usingthe seating type from cell A3 as the title text. As the inputmessage, type Enter the number of tickets sold per day. (include the period). Create an error alert for therange using the Stop icon. Type Invalid Data asthe title text and enter the error message as You entered an invalid value. Please enter a number between 0 and 86.(include the period). Repeat this procedure for each of theremaining rows in the range C4:G6. Change the maximum value in theerror message based on the value in column B.

 

Creator:Exploring SeriesDate:26-Oct-16Purpose:Store daily Tcket sales by seaTng group.Calculate daily and weekly revenue.Calculate monthly seaTng revenue.Worksheets:Week 1Week 2Week 3Week 4October Summary Worksheet

Ofce 2013 – myitlab:grader – InstructionsExploring Series Vol. 2Multiple-Sheet Workbook ManagementProject Description:You are an accounting assistant for Downtown Theater in San Diego. The theater hosts touringBroadway plays and musicals Fve days a week, including matinee and evening performances onSaturday. You want to analyze weekly and monthly ticket sales by seating type.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Download and open the ²leexploring_e09_grader_h1.xlsx. Acknowledge the error,and then save the ²le ase09c1Theater10_LastFirst, replacingLast±irstwithyour name.02On the Week 1 worksheet, select the number o± daily Orchestra Front tickets sold(in the range C3:G3). Create a validation rule to accept only whole numbersbetween0and the available seating limit in cell B3. Create an input message,using the seating type ±rom cell A3 as the title text. As the input message, typeEnter the number of tickets sold per day.(include the period). Create an erroralert ±or the range using the Stop icon. TypeInvalid Dataas the title text andenter the error message asYou entered an invalid value. Please enter anumber between 0 and 86.(include the period). Repeat this procedure ±or eacho± the remaining rows in the range C4:G6. Change the maximum value in the errormessage based on the value in column B.63Circle invalid data entry. Change each invalid entry to the maximum number o±applicable seats.64Group the ±our weekly worksheets. Enter a ±ormula in cell C11 to calculateSunday’s Orchestra Front revenue, which is based on the number o± seats sold andthe price per seat. Use relative and mixed cell re±erences correctly. Copy the±ormula ±or the Sunday column to complete the entire range o± weekdays C11:G14.65Insert ±ormulas to calculate the weekly seating totals and the total daily revenue.Include the grand total ±or the week. Indent and bold the wordTotalsin cells A7and A15 on the grouped worksheets.126In the Revenue per Day section o± the grouped sheets, apply the Accountingnumber ±ormat with zero decimal places to the Orchestra Front revenue and thetotal revenue row. Apply the Comma Style with zero decimal places to theremaining seating revenue rows. Apply bottom double borders to the rangeC15:G15.67Use Format Painter to copy the ±ormats ±rom cells A2:H2 to cells A10:H10. Selectthe range A1:H15 and set the column width to auto. Ungroup the worksheets.Display the Week 4 worksheet and ²ll the ±ormats o± cells C1 and C9 ±rom theWeek 4 worksheet to the October worksheet without copying the content.88On the Documentation worksheet, create a hyperlink ±rom theWeek 1label to cellA1 on the Week 1 worksheet. Create the hyperlinks ±rom the remaining worksheetlabels on the Documentation worksheet to the other worksheets.6Updated: 08/21/20131E_CH09_EXPV2_H1_Instructions.docx

• 1494483127-E_CH09_EXPV2_H1_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 11 May 2017 06:05 AM My Price 11.00

-----------

Attachments

file 1494483128-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer