Microsoft Office Tutorials and References
In Depth Information
Copying a formula
2
Select Average, and then press Enter. Excel displays the average sales for the year.
Excel calculates the average of the numbers to the left of the results cell.
3
Click File > Save, and then click File > Close.
Copying a formula
You can copy a formula to a dif erent part of a worksheet. When you copy a formula, Excel
adjusts the range references to the new location. In this exercise, you’ll copy a formula to an
entire column to calculate the average for each student.
To open the document you need for this lesson:
1
Choose File > Open and navigate to the Excel05lessons folder.
2
Click excel0505 and then click Open.
3
Select File > Save As.
4
In the Save As text i eld, type excel0505_done and then click Save.
5
Click in cell E3, and position the cursor over the bottom-right corner of the cell. The
cursor changes to a cross (+).
6
Click and drag through cell E20 and release the mouse button. Excel calculates the
average for the year for all students and displays the results in column E.
Now, you’ll i nd the best grade for each term. The best grade for Fall is 95 as shown in
cell B21. Let’s copy the formula to display the best grades for Winter and Spring.
7
Click in cell B21, and then move the cursor over the bottom-right corner of the cell.
The cursor changes to a cross (+).
8
Click and drag through cell D21. Excel displays the maximum grades for Winter
and Spring.
9
Click File > Save, and then click File > Close.
Search JabSto ::

Custom Search