CS 115

Homework #8

Spreadsheet Software 2

1. Open the worksheet saved for assignment 7. Make sure all labels and names are still completely visible.
2. Add the following students and their test scores to the worksheet. Below your name and before the CLASS AVERAGE row.
   
   Student Name    Exam 1   Exam 2    Exam 3
   First,Hugo          75       53        80
   Order,Lauren        81       85        89
3. Add a column to the right of the Total column called Average.
4. If the total values for the new students are not automatically, filled, use formulas to fill them in.
5. Fill the Average column with each student's average score (total divided by 3). Use formulas. Do not compute an average for the CLASS AVERAGE row.
6. If necessary, adjust the formula for computing the CLASS AVERAGE for each of the 3 exams. Do NOT compute an average for the Total and Average columns.
7. Make sure the label for the Average column is boldfaced. All exam scores and class averages should be displayed with 2 digits to the right of the decimal. The total values should be displayed without a decimal. The average values should be displayed with 3 digits to the right of the decimal.
8. Create a custom header to be centered at the top of the page. It should read: CS 115 GRADE SUMMARY
9. Change to landscape orientation. Use Print Preview to make sure all data is completely displayed and the worksheet fits on one page.
10. Update the assignment # in the footer.
11. Print the worksheet without the grid.

**Names courtesy of CarTalk (cartalk.cars.com/About/credits.html).