Cashback Offer (20th - 30th September 2020). Get Flat 10% Cashback credited in your account on a minimum transaction of $80. Post Your Question

Question Details Urgent
$ 10.00

Excel Chapter 9: Multiple-Sheet Workbook Management

Question posted by
Online Tutor Profile
request

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, replacing LastFirst with your name.

0

2

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

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

15

9

Click the Defensive Totals worksheet and enter formulas in cells A3:C3 to calculate the total tackles, forced fumbles, and interceptions.

6

10

Click the Offensive Totals worksheet and create a hyperlink in cell C2 to cell C2 on the Passing worksheet.

5

11

Click the Defensive Totals worksheet and create hyperlinks 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

100

         

Available Answers
$ 12.00

[Solved] Multiple-Sheet Workbook Management

  • This Solution has been Purchased 1 time
  • Average Rating for this solution is A+
  • Submitted On 15 Nov, 2016 01:56:37
Answer posted by
Online Tutor Profile
solution
Please find ...
Buy now to view the complete solution
$ 8.00

[Solved] Excel Chapter 9: Multiple-Sheet Workbook Management

  • This Solution has been Purchased 1 time
  • Average Rating for this solution is A+
  • Submitted On 15 Nov, 2016 02:20:59
Answer posted by
Online Tutor Profile
solution
Solution to the steps...
Buy now to view the complete solution

The benefits of buying study notes from CourseMerit

Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton
Only 45 characters allowed.
closebutton

$ 629.35