|
|
|
Frequently used functions |
 | The formulas below use the example worksheet data. If you want to practice, start a new worksheet and enter the same values into cells A1 and A2. Select cell A3, press EQUAL SIGN (=) to activate the Formula Bar, then click the Function Selector (see Typing formulas) to choose a function. When you select a function, the Formula Palette appears. Click OK in the Formula Palette to accept the function. |
 | | | |
Sum(range) | calculates sum | =Sum(A1:A2) | Answer: 15 |
Average(range) | calculates average | =Average(A1:A2) | Answer: 7.5 |
Max(range) | returns highest value | =Max(A1:A2) | Answer: 10 |
Min(range) | returns lowest value | =Min(A1:A2) | Answer: 5 |
Counta function | counts the number of cells in a range that contain data | =Counta(A1:A2) | Answer: 2 |