Page 29 - Trackpad_V5_Book 6
P. 29
For example, MAX () function:
2 Type =MAX(B3:F3)
function in the cell G3.
1 Type this data.
Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the
minimum marks by using the MIN() function.
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: 7/23/2019
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current year.
Output: 2019
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-05-2020 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
Formulas and Functions in Excel 2021 27

