I need help answering this excel assignment.

Accounting Information Systems

Office 2013 - myitlab:grader - Instructions Exploring Series Vol. 2 Multiple-Sheet Workbook Management Project Description: You have volunteered to be the statistician for your high school's football team. As part of your assignment you will organize, and present statistics to the coach. Currently the information is stored in three different Excel workbooks: offense, defense, and special teams. You will standardize the worksheets into a summary document as well as correcting errors, and safe guarding against future issue. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Download and open the file exploring_e09_grader_a1.xlsx. Save the document as e09c2Football_LastFirst, replacing LastFirst with your name. 0 2 Group the Passing, Rushing, Receiving, and Defense worksheets. Click cell A1 and fill the contents and formatting across all of the grouped worksheets. 10 3 With the sheets still grouped, select the range A2:G2. Add borders to all cells and fill the cells with the color Olive Green, Accent 3, Lighter 60%. Ungroup the worksheets. 10 4 Click the Rushing worksheet. Trace the error in the cell that contains the #DIV/0 error. Enter an IFERROR function that returns 0 in cell D6. 10 5 Insert a formula that references the appropriate worksheets in cell A3 on the Offensive Totals worksheet to calculate total passing, rushing, and receiving touchdowns. 10 6 Insert a formula that references the appropriate worksheets in cell B3 on the Offensive Totals worksheet to calculate total passing, rushing, and receiving yards. 10 7 Insert a formula that references the appropriate worksheets in cell C3 on the Offensive Totals worksheet to calculate total completion rate based on data in the Passing worksheet. The completion rate is calculated by dividing the total completed passes by the total attempted passes. 6 8 Click the Defense worksheet and create a validation rule for cells B3:F26 that restricts entering number 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). 15 9 Click the Defensive Totals worksheet and enter formulas in cells A3:C3 to calculate the total tackles, forced fumbles, and interceptions. Updated: 08/21/2013 1 6 E_CH09_EXPV2_A1_Instructions.docx Office 2013 - myitlab:grader - Instructions Step Exploring Series Vol. 2 Points Possible Instructions 10 Click the Offensive Totals worksheet and create a link in cell C2 to cell C2 on the Passing worksheet. 5 11 Click the Defensive Totals worksheet and create links in cells A2 (Total Tackles), B2 (Forced Fumbles), and C2 (Interceptions) to their corresponding cells on the Defense worksheet. 6 12 Create a footer on all worksheets with the sheet name code in the center and the file name code on the right side. 6 13 Apply landscape orientation, and then center the worksheets horizontally on the printouts. 6 14 Save the workbook. Ensure that the workbooks are in the following order: Passing, Rushing, Receiving, Defense, Offensive Totals, and Defensive Totals. Close the workbook and exit Excel. Submit the workbook as directed. 0 Total Points Updated: 08/21/2013 2 100 E_CH09_EXPV2_A1_Instructions.docx Player Name Bill Smith Will Johnson Attempts 2015 Football Stats Completions Yards Touchdowns Interceptions QB Rating 122 65 846 5 3 73.55 2 1 15 0 0 75 Player Name Frank Remus Billy Monroe Jimmy Monon Dan Mcdougle Attempt Yards Yards per Longest Run Touchdowns 43 155 3.604651 18 2 15 31 2.066667 9 0 10 80 8 19 0 0 0 #DIV/0! 0 0 Player Name Brendan Shelton Philip Hernandez Mike Burns Antonio Griffith Eli Johnston ErinPorter Mark Carroll Todd Gordon Audrey Cook Joshua Alexander Robert Harper Rick Mack AdamReeves Receptions Yards Yards per reLongest Touchdowns 23 294 12.78 30 14 176 12.57 41 8 98 12.25 24 6 38 6.33 17 5 128 25.60 40 3 23 7.67 11 2 26 13.00 13 1 10 10.00 10 1 39 39.00 39 1 6 6.00 6 1 8 8.00 8 10 5 0.50 1 1 0 0.00 0 1 1 0 1 1 1 1 0 0 0 0 0 0 Player Name Tracy Brown Ben Davis Carl Harvey Tom Rhodes Antonio Weaver Eddie Carpenter Jerry Castro Matt Keller Jean Adams Roger Newman Jean Freeman Gerald Santos Carl Hunter Jr. Bill Harvey Marv Pearson Ian Reese Kip Butler Nathan Burgess Nick Sullivan Chuck Hardy James Wright Hank Lawson Clarence Wallace Justin Chambers Tackles Assists 17 1 25 19 15 19 23 18 15 15 23 22 9 8 20 13 11 6 4 22 18 20 16 3 Sacks 12 10 0 8 24 2 24 8 16 4 22 16 11 6 5 22 11 1 4 17 11 1 0 7 Forced Fumbles 2 0 2 4 4 2 0 1 4 1 3 4 2 4 2 2 0 4 5 4 4 3 2 1 Interceptions 0 0 1 2 3 1 1 1 3 1 2 3 2 0 1 0 2 0 3 2 1 3 3 1 3 1 3 0 1 0 1 0 0 3 3 3 0 0 2 0 1 3 2 2 0 0 0 1 Total Touchdowns Offense Total Yards Completion Rate Total Tackles Defense Forced Fumbles Interceptions 3/25/2016 Summary Report Detailed Summary of Project Submission Print Microsoft Excel 2013 Assignment Your Total Score Obtained: 84% | Date Report Run 03/25/2016 There are items which are either extra or missing in the document you submitted. Click on the arrow to view details. You lost points in the following instructions. Click on the arrow to view the errors. Step Instructions I6 I10 I11 Insert a formula that references the appropriate worksheets in cell B3 on the Offensive Totals worksheet to calculate total passing, rushing, and receiving yards. A formula in cell B3 on the Offensive Totals worksheet was not inserted to calculate total passing, rushing, and receiving yards. Click the Offensive Totals worksheet and create a link in cell C2 to cell C2 on the Passing worksheet. Cell [C2] on Sheet (Offensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. Click the Defensive Totals worksheet and create links in cells A2 (Total Tackles), B2 (Forced Fumbles), and C2 (Interceptions) to their corresponding cells on the Defense worksheet. Points Deducted 5.000 0.000/5.000 5.000 0.000/5.000 6.000 Cell [A2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 Cell [C2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 Cell [B2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 https://gradeit.pearsoncmg.com/ReportingModule/SummaryReport.aspx?SubmissionID=2354392400&Token=tsgeBmzWJULgQoe1Rs9msJewIGVkp4xkF1LxW8o3J... 1/1 3/25/2016 Summary Report Detailed Summary of Project Submission Print Microsoft Excel 2013 Assignment Your Total Score Obtained: 84% | Date Report Run 03/25/2016 There are items which are either extra or missing in the document you submitted. Click on the arrow to view details. You lost points in the following instructions. Click on the arrow to view the errors. Step Instructions I6 I10 I11 Insert a formula that references the appropriate worksheets in cell B3 on the Offensive Totals worksheet to calculate total passing, rushing, and receiving yards. A formula in cell B3 on the Offensive Totals worksheet was not inserted to calculate total passing, rushing, and receiving yards. Click the Offensive Totals worksheet and create a link in cell C2 to cell C2 on the Passing worksheet. Cell [C2] on Sheet (Offensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. Click the Defensive Totals worksheet and create links in cells A2 (Total Tackles), B2 (Forced Fumbles), and C2 (Interceptions) to their corresponding cells on the Defense worksheet. Points Deducted 5.000 0.000/5.000 5.000 0.000/5.000 6.000 Cell [A2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 Cell [C2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 Cell [B2] on Sheet (Defensive Totals) was not detected in the submission. 'Hyperlink Destination' check was not performed. 0.000/2.000 https://gradeit.pearsoncmg.com/ReportingModule/SummaryReport.aspx?SubmissionID=2354392400&Token=tsgeBmzWJULgQoe1Rs9msJewIGVkp4xkF1LxW8o3J... 1/1