Page 48 - Plus V4 with Adobe class 6
P. 48
Functions Purpose Example
Input: = HOUR(NOW())
HOUR(time) It returns the hour from a given time.
Output: 11
Input: MINUTE(NOW())
MINUTE(time) It returns the minutes from a given time.
Output: 24
Date Function
You can use the date functions in Excel. To do so, type =TODAY()
in the cell and press the Enter key from the keyboard.
When you press the Enter key, the current date appears in the cell.
We can also give the reference of a cell containing the date to
the MONTH() function. Similarly, we can use the YEAR() and
DAY() functions to get the year and day from a date respectively. Using TODAY function
Hintbot
To use the the common functions like SUM, AVERAGE, MAX and MIN: click
on the down-arrow of the AutoSum command.
To use other functions: click on More Functions option.
Double Tap Century #Technology Literacy
21 st
Skills #Productivity & Accountability
Write the output of the following:
a. =MIN (5,7,8) d. =TODAY()
b. =Left("Computer", 4) e. =LEN("Touch")
c. =AVERAGE(12,3,6) f. =COUNT(4,8,12)
Timeline
A cell reference is a cell address that can be used in a formula to denote a specific cell.
In relative reference, you actually refer to cell that is above or below and left or right to a number of
rows or columns.
If you wish to maintain the original references as they were, then you should make use of the absolute
references.
A mixed reference is a reference that refers to a specific row or column.
Functions are predefined formulas in Excel to perform both simple and complex calculations.
46 Plus (Ver. 4.0)-VI

