Right in Class
Tools for Success
Tutorial

Creating the Formulas

Adding Up Totals -

Pages Read or  Number of Books


    1. Click the cell where you want the total to appear
    2. Click the equal sign above the ABC grid

    3. Next click SUM a gray box will appear. If this is in your way for Step 4, click on the sum box and drag to another locations
    4. Start at the top of the column where the numbers will be entered. Click and drag down. This tells the formula what cells to add up.
    5. Click OK on the Formula bar

Averaging -
AR Average Scores - Average of Pages Read


    1. Click the cell where you want the average to appear
    2. Click the equal sign in above the ABC grid

    3. Next click the small down pointing triangle and click AVERAGE.  A gray box will appear. If this is in your way for Step 4, click and drag it to another location
    4. Start at the top of the column where the numbers will be entered. Click and drag down. This tells the formula what cells to add up.
    5. Click OK on the Formula bar

 

Working with
Formulas

It gets easier the more you work with formulas.  Take time to play with different ways to add up, subtract, average etc. The more you explore the more you will learn.

 

 

[Home] [Directions] [Cells] [Fonts] [Colors] [Word Art] [Clip Art] [Formulas] [Managment] [Other Links]

Copyright Notice 2002,2001,2000: No materials on any of the Right in Class pages may be reproduced without expressed written permission
unless clearly stated on the page. Please contact Carolyn Hinshaw for permission to use, questions, or comments.