Quizzes are worth 20 percent and tests are 80 percent...... =((F4*2)+(M4*8))/10
| Excel Project 1 | Create a WORKING* worksheet identical to the one below. Save it as: Excel online project 1 | |||
|
||||
| *note, All total and average cells are FORMULAS. The final grade cells are also formulas. The formula for the final grade is a weighted average. (There is a single error in the above diagram)
Quizzes are worth 20 percent and tests are 80 percent...... =((F4*2)+(M4*8))/10 |
||||