Directions:
1. Download D3.19exam, or open 1.7exam, which you may have created earlier.
NOTE: Your file may not look exactly like the illustration shown below. Modify this exercise to work with the layout you created earlier.
2. Save the file as 3.19exam.
3. Enter the new labels STUDENT AVERAGE, EXAM AVERAGE, HIGHEST GRADE, and LOWEST GRADE in the cell locations shown in Figure 19.1. If you downloaded my file, this step is done for you.
 Wrap STUDENT AVERAGE in the cell.
4. Adjust column widths to fit the data.
5. Calculate the STUDENT AVERAGE for each student. Enter the AVERAGE function to average EXAM 1, EXAM 2, and EXAM 3 grades. Place the insertion point in the cell where the answer should appear. Click the AutoSum list arrow and choose Average. Adjust the range, if necessary, and then press Enter.

Copy the formula from Cell E5 to the range E6:E10.
6. Insert a column after Column D.
 Insert the label EXAM 4 between the EXAM 3 and STUDENT AVERAGE columns. Enter the following grades for each student:
 Forbes: 88
 Garner: 82
 Edwards: 86
 Burns: 94
 Daniels: 79
 Carson: 94
NOTE: STUDENT AVERAGES will automatically update.
7. Calculate EXAM AVERAGE.
 Enter the AVERAGE function to average the EXAM 1 column.
 Copy the formula from Cell B12 to the range C12:F12.
8. Calculate HIGHEST GRADE.
 Enter the MAX function to find the highest grade in the EXAM 1 Column. Place the insertion point in the cell where the answer should appear. Click the AutoSum list arrow and choose Max. Adjust the range, if necessary, and then press Enter.
 Copy the formula from Cell B13 to the range C13:F13.
9. Calculate LOWEST GRADE.
 Enter the MIN function to find the lowest grade in the EXAM 1 column.
 Copy the formula from Cell B14 to the range C14:F14. Place the insertion point in the cell where the answer should appear. Click the AutoSum list arrow and choose Min. Adjust the range, if necessary, and then press Enter.
10. Format all EXAM AVERAGE, HIGHEST AVERAGE, LOWEST GRADE, and STUDENT AVERAGE grades to whole numbers with two decimals. Apply bold to STUDENT AVERAGE grades
11. Format and align worksheet data as indicated in the ﬁgure.
12. Sort the student names in alphabetical order. Select the table data without the column headings. Click Sort&Filter, select Sort A to Z.
13. Set your page to print with gridlines and row and column headings.
14. Save the file.
15. Printpreview the file for your teacher.
Have fun, learn lots
Mr. Hennings
Recent Comments