Page 52 - modular4.0
P. 52
Chapter Profile
3 Type =UPPER(B3) function in
the cell E3 to convert the first
name into uppercase and press
Enter key.
The first name appears in uppercase.
4 Type =LOWER(B3) function
in the cell F3 to convert the first
name into lowercase and press
Enter key.
Statistical Functions
Function Purpose Example
It returns the largest value in the given Input: =MAX(4,16,12,9)
MAX(range)
range. Output: 16
It returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range. Output: 4
It returns the average of the given numbers Input: =AVERAGE(12,3,6)
AVERAGE(range)
in a range. Output: 7
It returns the count of the number of values Input: =COUNT(4,8,12)
COUNT(range)
in the selected range. Output: 3
Let's use the statistical functions in Excel 2019. Perform the given steps to use the statistical functions:
1 Type the given
data in the Excel 2019
worksheet.
2 Type =MAX(C3:G3) function in the cell H3 to
find the maximum marks and press Enter key.
When you press the Enter key, the maximum marks appear in the cell H3. Using the AutoFill feature
find the maximum marks of each student. Similarly, we can find the minimum marks by using the
MIN() function in column I.
3 Type =AVERAGE(C3:G3)
function in the cell J3 to find
the average of marks and
press Enter key.
When you press the Enter key, the average of marks appears in the cell J3. Using the AutoFill
feature, we can calculate the average of marks of each student.
50 Modular (Ver. 4.0)-VII

