Can you help me solve this excel document according to these instructions? 

 

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 fileexploring_e09_grader_a1.xlsx. Save the document ase09c2Football_LastFirst, replacingLastFirstwith your name.02Group the Passing, Rushing, Receiving, and Defense worksheets. With the Passing worksheet displayed,click cell A1 and fill the contents and formatting across all of the grouped worksheets.103With the sheets still grouped, select the range A2:G2. Add borders to all cells and fill the cells with thecolor Olive Green, Accent 3, Lighter 60%. Ungroup the worksheets.104Click the Rushing worksheet. Trace the error in the cell that contains the #DIV/0 error. Enter anIFERROR function that returns0in cell D6.Hint: To trace the error, click cell D6 and on the FORMULAS tab, in the Formula Auditing group, clickthe Error Checking arrow. Enter the function=IFERROR(C6/B6,0)in the cell and then press ENTER.105Insert a formula that references the appropriate worksheets in cell A3 on the Offensive Totals worksheetto calculate total passing, rushing, and receiving touchdowns.106Insert a formula that references the appropriate worksheets in cell B3 on the Offensive Totals worksheetto calculate total passing, rushing, and receiving yards.107Insert a formula that references the appropriate worksheets in cell C3 on the Offensive Totals worksheetto calculate total completion rate based on data in the Passing worksheet. The completion rate iscalculated by dividing the total completed passes by the total attempted passes.68Click the Defense worksheet and create a validation rule for cells B3:F26 that restricts entering values towhole numbers no less than0. Create an input message that reads the following:Enter all stats aswhole numbers. (include the period). Choose the Stop style and enter the following error message:Stats cannot be less than 0(no period).159Click the Defensive Totals worksheet and enter formulas in cells A3:C3 to calculate the total tackles,forced fumbles, and interceptions.6Updated: 03/04/20161E_CH09_EXPV2_A1_Instructions.docx

Attachments:

• 1494307057-Tong_exploring_e09_grader_a1.xlsx
• 1494307058-E_CH09_EXPV2_A1_Instructions.docx