1. Type in the data in the white cells. 2. Invent 9 more students with colors for last names.  Type the names in the yellow cells. 3. Invent and type grades for these students into the pink cells. 4. Figure out the Quiz Average for each student (Column K).  Use the average function. 5. Figure out the Homework Average for each student (Column L).  Use the average function. 6. Figure out the Test Average for each student (Column M).  Use the average function. 7. Write a formula for Column N, the Final Grade.  This grade is 25% Quiz Average plus 25% Homework Average plus 50% Test Average (or Quiz Average * 0.25 + Homework Average * 0.25 + Test Average * 0.5). 8. Figure out the Average grade for each Quiz, Homework, Test, Averages, and Final Grade. 9. Figure out the Highest grade for each Quiz, Homework, Test, Averages, and Final Grade.  Use the MAX function. 10. Figure out the Lowest grade for each Quiz, Homework, Test, Averages, and Final Grade.  Use the MIN function.

You will print your project TWICE, once in regular view and once in formula view.
BEFORE printing, change to LANDSCAPE printing.  Click File on the menu bar, then click Page Setup.
Choose Landscape from the Page Setup dialog box.
First print your spreadsheet in REGULAR view.
Next print your spreadsheet using FORMULA view.  Click Tools on the menu bar, then click Options.
Check the Formulas box as shown below...