Excel Challenge help

A Skills Approach: Excel 2013 Chapter 4: Formatting Worksheets and

Managing the Workbook

1 | Page fix it 4.6 Last Updated 4/3/15

fix it 4.6 In this project, you will fix a number of formatting errors that prevent this gradebook spreadsheet from displaying and printing properly.

Skills needed to complete this project:

 Moving and Copying Worksheets  Deleting Worksheets  Inserting and Deleting Rows and Columns  Modifying Column Widths and Row Heights  Hiding and Unhiding Rows and Columns  Changing Worksheet Orientation  Scaling Worksheets for Printing  Inserting Page Breaks  Printing Titles  Showing and Hiding Worksheet Elements  Changing the Worksheet View  Adding Headers and Footers  Printing Selections, Worksheets, and Workbooks  Naming Worksheets

1. Open the start file EX2013-FixIt-4-6. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.

2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.

3. The Scores worksheet should be first in the workbook.

4. This workbook has an unnecessary worksheet. Delete it.

5. There are two unnecessary columns in the middle of the worksheet. Delete them.

6. The Scores worksheet has at least one column and one row that do not display the data properly. Resize them to best fit the data.

7. Column S should not be visible.

8. Review how the Scores worksheet will look when printed. Fix the following issues:

a. The worksheet should print on no more than two pages, with the page break coming after the midterm grades (before column T). (Hint: Try changing the worksheet orientation and adjusting

the scaling.)

b. Column A:B should be included on every printed page.

c. The worksheet gridlines should print.

d. The worksheet should have a footer with the word CONFIDENTIAL in the center section and the date automatically inserted into the right section.

e. Only cells A8:AG28 should be printed.

Step 1

Download start file

A Skills Approach: Excel 2013 Chapter 4: Formatting Worksheets and

Managing the Workbook

2 | Page fix it 4.6 Last Updated 4/3/15

9. The Scores worksheet should be named Gradebook

10. Save and close the workbook.

11. Upload and save your project file.

12. Submit project for grading.

Step 2

Upload & Save

Step 3

Grade my Project