Page 72 - ICT_for_JHS_3_Classical

TODAY: This returns the serial number of today's date.
MONTH: This converts a serial number to a month.
YEAR: This converts a serial number to a year.

NB: You don't have to memorize these functions, but you should have an idea

of what each can do for you.

AutoSum

AutoSum is a function that the computer user can use to automatically add the
figures within a certain range of cells and view the result in a cell designated to
display the result. It is simply a tool that adds up figures in a spreadsheet.

To calculate the AutoSum of a range of data:
1. Type the numbers to be included in the formula in separate cells of
column B (type 128 in cell B2, 345 in cell B3, 243 in cell B4, 97 in cell
B5, and 187 cell B6).

2. Click the first cell (B2) to be included in the formula.
3. Using the point-click-drag method, drag the mouse to define a cell
range from cell B2 through cell B6.
4. On the Standard toolbar, click the Sum button.
5. The sum of the numbers is added to cell B7, or the cell immediately
beneath the defined range of numbers.

Notice the formula, =SUM(B2:B6), has been defined to cell B7.