Home Word PowerPoint Excel Access Installing
Software
Searching
the Internet
Using the
Library
Basic Skills

Microsoft® Excel 2003

Part I  Part II   Part III  Part IV 
Excel Tip Sheet 

Part IV Instructions

Format a Worksheet
Create a Chart
Freeze Panes
Sort Data
Use AutoFilter
Add a Header and Footer
Print

Dig Deeper

For more extensive training on creating charts, go the Microsoft Training site and complete the How to Create a Chart lesson.

To learn more about formulas, go to the Microsoft Training site and complete the Get to Know Excel: Enter Formulas lesson.

Activity IV

Open Grade Book.xls. Format the title of the worksheet as shown below. Merge and center Rows A through M. Change the font size of the title to16 points and the size of the subtitles to 12 points.

Title in 16 point bold; subtitles in 12 point bold. All titles centered in Rows A-M.

Add a column at the end of the table for the letter grade. Format the worksheet as shown below. Place a border around the grade columns. Add bold as shown and convert the number styles to percent for Assignment, Test, and Final Averages. Add light green lines to every other line.

Every other row with green background. Border around grade columns including the headers. Headers in bold. Includes Columns A-F.

Every other row with green background. Border around grade columns including the headers. Headers in bold. Includes Columns G-K. Columns G, J and K display as percentages.

Every other row with green background. Border around grade columns including the headers. Headers in bold. Includes Column L with title Letter Grade. Grades are C, A, B, C, A.

Create the grade distribution in some empty cells on the worksheet. Create a pie chart showing the grade distribution. Add labels and percentages. Explode the A section.

Grade Distributions are A=2, B=1, C=2, D=0, F=0.

Calculate the final average, count, highest average, and lowest average. Check your work by comparing it to the illustration below:

Final Average = 84%, Count = 5, Highest Final Average = 93%, Lowest Final Average = 71%.

Add a header with your name, time and date, and number of pages. Save the workbook. Select the print area and print the worksheet and chart.

Practice sorting by final average and filtering by letter grade.

Click on Cell E12 and freeze the pane. Practice scrolling. Save the workbook with Cell E12 frozen.

 

                      

Go to Excel Part III.