Page 28 - TP_iPlus_V2.1_Class8
P. 28
To use the statistical functions, follow the given steps:
1 Type the
following
data in
the Excel
worksheet.
2 Type =MAX(B3:F3) function in cell G3 to find
the maximum marks and press the Enter key.
When you press the Enter key, the maximum marks appear in cell G3. Using the AutoFill feature,
find the maximum marks of each student. Similarly, you can find the minimum marks by using
the MIN() function.
3 Type =AVERAGE(B3:F3) function in cell I3 to find
the average of marks and press the Enter key.
When you press the Enter key, the average of the marks appears in cell I3. Using the AutoFill
feature, we can calculate the average of the marks of each student.
Date and Time Functions
Functions Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 7/23/2024
Input: =MONTH(TODAY())
MONTH(date) It returns the current month.
Output: 7
26
iPlus (Ver. 2.1)-VIII

