Page 26 - iPro_trackGPT_V5_Class8
P. 26
To use the mathematical functions in Excel, follow the given steps:
1 Type the
data in the Excel 2 To calculate the price of Pencils,
worksheet.
type the =PRODUCT(B3:C3) function
in cell D3 and press the Enter key.
Tech Tweak
In functions, we can also use the cell address in place of the values.
After pressing Enter key, the price of the pencils will display in cell D3. You can then use the
AutoFill feature to quickly calculate the prices for the Geometry Boxes and Pens.
4 To calculate the tax, type
the =PRODUCT(D6,C7)
function in cell D7 and press
the Enter key.
3 To calculate the subtotal, type 5 To calculate the total bill, type
the =SUM(D3:D5) function in the =SUM(D6:D7) function in cell
cell D6 and press the Enter key. D8 and press the Enter key.
Text Functions
Function Purpose Example
CONCATENATE(text1, It joins together two or more Input: =CONCATENATE(“Track”, “GPT”)
text2) different text strings. Output: TrackGPT
It returns the specified Input: =LEFT(“Track”,3)
LEFT(text, num_chars) number of characters from Output: Tra
the left side of the text string.
It returns the specified number Input: =RIGHT(“Track”,3)
RIGHT(text, num_
of characters from the right Output: ack
chars)
side of the text string.
It returns the length of the Input: =LEN(“Track”)
LEN(text)
text string. Output: 5
It converts the text string into Input: =UPPER(“Track”)
UPPER(text)
uppercase. Output: TRACK
It converts the text string into Input: =LOWER(”Track”)
LOWER(text)
lowercase. Output: track
24 TrackGPT iPRO (V5.0)-VIII

