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 III Instructions

Create Formulas - Relative Reference
Create Formulas - Absolute Reference
Use AutoSum Functions

Activity III

Open Grade Book.xls. Create formulas using relative reference to calculate the average in Columns F and J. Create a formula using an absolute reference to calculate the final average in Column K. Check your work below. Save the workbook:

      
Listed are the cell numbers and content. F8: 0.71, F9: 0.9, F10: 0.875, F11: 0.85, F12: 0.925   Listed are the cell numbers and content. J8: 0.716666667, J9: 0.906666667, J10, 0.833333333, J11: 0.76, J12: 0.926666667     Listed are the cell numbers and content. K8: 0.714666667, K9: 0.904666667, K10: 0.845833333, K11: 0.787, K12: 0.926166667

Use the AutoSum function to calculate the Final Average, Count, Highest, and Lowest final averages. Save the workbook.

Final Average = 0.835666667, Count = 5, Highest Final Average = 0.926166667, Lowest Final Average = 0.714666667

                      

Go to Excel Part II.      Go to Excel Part IV.