|
Introduction | Standard Toolbar | Formatting Toolbar | Navigating | Simple Formulas
Rows & Columns | Sorting | Cell Formatting | Charts
Simple Formulas:
"92.67" was not entered as the contents for cell "E2." The "formula bar" has the following entered into it:
=(B2+C2+D2)/3
By following the normal order of operations, the contents of the three cells in parenthesis (B2, C2, and D2) are all added to each other, and then divided by 3. This gives an average of the three grades, which is then shown in the cell "E2" (where the formula was entered).
If you wanted to do the same for students 2 through 5, you would enter in similar formulas for each cell from "E3" to "E6" replacing the column and row numbers where appropriate.
An easy method to replicate formulas is to select the cell which contains the original formula ("E2" in this case), click the bottom right corner of the selection box, and drag down several rows (to "E6" in this example). The formula will be copied down in each cell, and will change itself to reflect each new row.
>> next |
