+
Exploring Series Vol. 2 Multiple­ Sheet Workbook Management

Exploring Series Vol. 2 Multiple­ Sheet Workbook Management

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-series-vol-2-multiple-sheet-workbook-management-1/

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

Instructions

Points Possible

1

Download and open the file exploring_e09_grader_a1.xlsx. Save the document as e09c2Football_LastFirst, replacingLastFirst 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.

6


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial