Please, I have the following instruction in my homework. how do I go about it? 'Click the Defense worksheet and create a validation rule for cells B3:F26 that restricts entering values to whole numbers no less than 0. Create an input message that reads the following: Enter all stats as whole numbers. (include the period). Choose the Stop style and enter the following error message: Stats cannot be less than 0 (no period).' I attach instruction and Excel file

 

Ofce 2013 – myitlab:grader – InstructionsExploring Series Vol. 2Multiple-Sheet Workbook ManagementProject Description:You have volunteered to be the statistician for your high school’s football team. As part of yourassignment you will organize, and present statistics to the coach. Currently the information isstored in three diFerent Excel workbooks: oFense, defense, and special teams. You will standardizethe worksheets into a summary document as well as correcting errors, and safe guarding againstfuture issue.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Download and open the ²leexploring_e09_grader_a1.xlsx. Save the document ase09c2Football_LastFirst, replacingLast±irstwith your name.02Group the Passing, Rushing, Receiving, and De±ense worksheets. With the Passingworksheet displayed, click cell A1 and ²ll the contents and ±ormatting across all o±the grouped worksheets.103With the sheets still grouped, select the range A2:G2. Add borders to all cells and²ll the cells with the color Olive Green, Accent 3, Lighter 60%. Ungroup theworksheets.104Click the Rushing worksheet. Trace the error in the cell that contains the #DIV/0error. Enter an IFERROR ±unction that returns0in cell D6.105Insert a ±ormula that re±erences the appropriate worksheets in cell A3 on theO³ensive Totals worksheet to calculate total passing, rushing, and receivingtouchdowns.106Insert a ±ormula that re±erences the appropriate worksheets in cell B3 on theO³ensive Totals worksheet to calculate total passing, rushing, and receiving yards.107Insert a ±ormula that re±erences the appropriate worksheets in cell C3 on theO³ensive Totals worksheet to calculate total completion rate based on data in thePassing worksheet. The completion rate is calculated by dividing the totalcompleted passes by the total attempted passes.68Click the De±ense worksheet and create a validation rule ±or cells B3:F26 thatrestricts entering values to whole numbers no less than0. Create an inputmessage that reads the ±ollowing:Enter all stats as whole numbers. (includethe period). Choose the Stop style and enter the ±ollowing error message:Statscannot be less than 0(no period).159Click the De±ensive Totals worksheet and enter ±ormulas in cells A3:C3 to calculatethe total tackles, ±orced ±umbles, and interceptions.6Updated: 03/04/20161E_CH09_EXPV2_A1_Instructions.docx

Attachments:

• 1494471710-E_CH09_EXPV2_A1_Instructions.docx