Page 61 - Computer Class 07
P. 61
cells (blank cells will not be counted and
neither will cells that are formatted as text)
8 Median (number 1, number 2) - Calculates the median of a range of cells.
8 Mode (number 1, number 2) - Calculates the mode of a range of cells.
8 Max ( number 1, number 2) - Gives the maximum value of a range of cells
8 Min (number 1, number 2) - Gives the minimum value of a range of
cells.
8 If (logical_test, value-if_true,
value_if_false) - Allows one to perform a logical test (e.g. If
A1>=5, Then 0 if true, or else if 1 if false)
Entering a Function
Let’s
Let’s Learn...
Learn...
To enter a function.
1. Open the worksheet.
2. Click on the cell where you want to enter the function.
3. Click on Insert Function button near the formula bar.
3
2
Computer-7 61
