Page 59 - TP_Prime_v2.2_Class_6
P. 59
When you press the Enter key, the maximum marks appear in the cell G3. Using the Auto
Fill feature, find the maximum marks of each student. Similarly, we can find the minimum
marks by using the MIN() function.
Date and Time Functions
Function Purpose Example
Input: =TODAY() FORMULAS AND FUNCTIONS IN EXCEL
TODAY() It returns the current date.
Output: 7/23/2024
Input: =MONTH(TODAY())
MONTH(TODAY()) It returns the current month.
Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) It returns the current day.
Output: 2024
Input: =DAY(TODAY())
DAY(TODAY()) It returns the current day.
Output: 23 57
It returns the current system date Input: = NOW()
NOW()
and time. Output: 21-05-2024 11:24
Input: = HOUR(NOW())
HOUR(time) It returns the hour from a given time.
Output: 11
It returns the minutes from a given Input: = MINUTE(NOW())
MINUTE(time)
time. Output: 24
Let us use the date functions in Excel by performing the following steps:
Step 1: Type =TODAY() in the cell.
Step 2: Press the Enter key from the keyboard.
When you press the Enter key, the current date appears
in the cell.
Using TODAY Function
Warm Write the output of the following: Century #Critical Thinking
21 st
Up! Skills
1. =MIN (5,7,8) _____________
2. =LEFT("Computer", 4) _____________
3. =AVERAGE(12,3,6) _____________
4. =TODAY() _____________
5. =LEN("Touch") _____________
6. =COUNT(4,8,12) _____________

