Page 29 - iprime_V2.2_class8
P. 29
Step 4 Type =AVERAGE(B3:F3) function in cell I3 to find the average of the marks.
Step 5 Press the Enter key.
Using AVERAGE Function
When you press the Enter key, the average of marks appears in cell I3. Using the AutoFill
feature, we can calculate the average of the marks for each student.
Calculating Average of Marks
Date and Time Functions
Functions Purpose Example
Input: =TODAY()
TODAY() Returns the current date
Output: 23/07/2024
Input: =MONTH(TODAY())
MONTH(Date) Returns the current month
Output: 7
Input: =YEAR(TODAY())
YEAR(Date) Returns the current year
Output: 2024
Input: =DAY(TODAY())
DAY(Date) Returns the current day
Output: 23
Input: = NOW()
NOW() Returns the system's current date and time
Output: 23/07/2024 11:24
Returns the hour from the system's current Input: = HOUR(NOW())
HOUR(time)
time Output: 11
Returns the minutes from the system's Input: = MINUTE(NOW())
MINUTE(time)
current time Output: 24
To use the date functions in Excel, follow these steps:
Step 1 Type =TODAY() in the cell A1.
Step 2 Press the Enter key.
Spreadsheet—Functions and Charts 27

