Page 27 - TP_iPlus_V2.1_Class8
P. 27
When you press the Enter key, the first name and last name appear after concatenation.
3 Type =UPPER(A3) function in cell D3 to convert the
First Name into uppercase and press the Enter key.
When you press the Enter key, the first name appears in uppercase.
4 Type =LOWER(A3) function in cell E3 to convert
the first name into lowercase and press the Enter key.
When you press the Enter key, the first name appears in lowercase.
Statistical Functions
Functions 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 Input: =AVERAGE(12,3,6)
AVERAGE(range)
numbers in a range. Output: 7
Input: =COUNT(4,8,12)
It returns the count of the number of Output: 3
COUNT(range)
values in the selected range.
If Excel was a magical library, how would you sort books and filter books you
had read?
25
Spreadsheet—Functions and Charts

