Page 31 - KEC Khaitan C6 Flipbook
P. 31
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-07-2024
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2024
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23
Input: =NOW()
NOW() It returns the current system date and time.
Output: 21-07-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.
Formulas and Functions in Excel 2021 29

