Page 31 - TP_V5.1_C7_fb
P. 31
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: 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
Functions in Excel 29

