Page 27 - iPro_trackGPT_V5_Class8
P. 27
To use the text functions, follow the given steps:
1 Type the
data in the Excel
worksheet.
2 Type =CONCATENATE(A3,B3) function to concatenate
the First Name and Last Name and press the Enter key.
When you press the Enter key, the first name and last name will be joined into one full name
using 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
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 Input: =AVERAGE(12,3,6)
AVERAGE(range)
numbers in a range. Output: 7
It returns the count of the number of Input: =COUNT(4,8,12)
COUNT(range)
values in the selected range. Output: 3
Spreadsheet—Functions and Charts 25

