Page 28 - iprime_V2.2_class8
P. 28
Step 5 Type =LOWER(A3) function in cell E3 to convert the first name into lowercase. Press the
Enter key.
Using LOWER Function
The first name appears in lowercase.
Statistical Functions
Functions Purpose Example
Input: =MAX(4,16,12,9)
MAX(range) Returns the largest value in the given range
Output: 16
Returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range Output: 4
Returns the average of the given numbers Input: =AVERAGE(12,3,6)
AVERAGE(range)
in the 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
To use the logical functions in Excel, follow these steps:
Step 1 Type the following data in the Excel worksheet.
Step 2 Type =MAX(B3:F3) function in cell G3 to find the maximum marks.
Step 3 Press the Enter key.
Using MAX Function
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, we can find the minimum
marks by using the MIN() function.
26 iPRIME (Ver. 2.2)–VIII

