Page 28 - iPro_trackGPT_V5_Class8
P. 28
To use the statistical functions, follow the given steps:
1 Type the
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 Enter key, you'll see the highest marks in cell G3. To quickly find the highest
marks for each student, use the AutoFill feature. To find the lowest marks, use the MIN() function
in the same way.
3 Type =AVERAGE(B3:F3) function in cell I3 to find
the average of marks and press the Enter key.
Pressing Enter key will display the average marks in cell I3. By using the AutoFill feature, you can
calculate the average marks for each student.
Date and Time Functions
Function Purpose Example
Input: =TODAY()
TODAY() It returns the current date.
Output: 6/18/2024
Input: =MONTH(TODAY())
MONTH(date) It returns the current month.
Output: 6
26 TrackGPT iPRO (V5.0)-VIII

