View the step-by-step solution to:

Question

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 – 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 diFerent Excel workbooks: oFense, 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 o± grading the project you are required to per±orm the ±ollowing tasks: Step Instructions Points Possible 1 Download and open the ²le exploring_e09_grader_a1.xlsx . Save the document as e09c2Football_LastFirst , replacing Last±irst with your name. 0 2 Group the Passing, Rushing, Receiving, and De±ense worksheets. With the Passing worksheet displayed, click cell A1 and ²ll the contents and ±ormatting across all o± the grouped worksheets. 10 3 With 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 the worksheets. 10 4 Click the Rushing worksheet. Trace the error in the cell that contains the #DIV/0 error. Enter an IFERROR ±unction that returns 0 in cell D6. 10 5 Insert a ±ormula that re±erences the appropriate worksheets in cell A3 on the O³ensive Totals worksheet to calculate total passing, rushing, and receiving touchdowns. 10 6 Insert a ±ormula that re±erences the appropriate worksheets in cell B3 on the O³ensive Totals worksheet to calculate total passing, rushing, and receiving yards. 10 7 Insert a ±ormula that re±erences the appropriate worksheets in cell C3 on the O³ensive 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 De±ense worksheet and create a validation rule ±or cells B3:F26 that restricts entering values to whole numbers no less than 0 . Create an input message that reads the ±ollowing: Enter all stats as whole numbers . (include the period). Choose the Stop style and enter the ±ollowing error message: Stats cannot be less than 0 (no period). 15 9 Click the De±ensive Totals worksheet and enter ±ormulas in cells A3:C3 to calculate the total tackles, ±orced ±umbles, and interceptions. 6 Updated: 03/04/2016 1 E_CH09_EXPV2_A1_Instructions.docx
Background image of page 1
Ofce 2013 – myitlab:grader – Instructions Exploring Series Vol. 2 Step Instructions Points Possible 10 Click the OFensive Totals worksheet and create a hyperlink in cell C2 to cell C2 on the Passing worksheet. 5 11 Click the De±ensive Totals worksheet and create hyperlinks in cells A2 (Total Tackles), B2 (²orced ²umbles), and C2 (Interceptions) to their corresponding cells on the De±ense worksheet. 6 12 Create a ±ooter on all worksheets with the sheet name code in the center and the ³le 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 ±ollowing order: Passing, Rushing, Receiving, De±ense, OFensive Totals, and De±ensive Totals. Close the workbook and exit Excel. Submit the workbook as directed. 0 Total Points 100 Updated: 03/04/2016 2 E_CH09_EXPV2_A1_Instructions.docx
Background image of page 2
2015 Football Stats Player Name ATempts Comple±ons Yards ²ouchdowns Intercep±ons QB Ra±ng Bill Smith 122 65 846 5 3 73.55 Will Johnson 2 1 15 0 0 75
Background image of page 1
Player Name AtempT Yards Yards per LongesT Run ±ouchdowns Frank Remus 43 155 3.604651 18 2 Billy Monroe 15 31 2.066667 9 0 Jimmy Monon 10 80 8 19 0 Dan Mcdougle 0 0 #DIV/0! 0 0
Background image of page 2
Show entire document

Top Answer

View the full answer
Ken_exploring_e09_grader_a1.xlsx

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
Attempt Yards
Yards per Longest...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online