Page 30 - Trackpad_V2.1_Class6
P. 30
1. Which function calculates the maximum value from a given set of
values?
_____________________________________________________________
uiz Bee 2. Which operator has the highest order of precedence?
_____________________________________________________________
DATE AND TIME FUNCTIONS
Some date and time functions with their examples are given below:
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 23/04/2024
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 4
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2024
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
It returns the current system date and Input: =NOW()
NOW()
time. Output: 23/04/2024 11:24
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
For example, TODAY() function:
Subject: Use of AutoSum Command
To use the common functions like SUM, AVERAGE,
MAX and MIN, Click on the down-arrow under
Formula tab of the AutoSum command.
Type =TODAY()
in the cell.
Press Enter key, the current date appears in the cell.
28 Trackpad (V2.1)-VI

