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 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
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
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
Show entire document

View the full answer

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...

### 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