Page 85 - TGPT_V5.0_C5_Flipbook
P. 85
Let us use the mathematical functions in Excel.
Perform the following steps to use the mathematical functions:
When you press the Enter key, price of the pencils appears in the cell D3. Using the AutoFill
feature, we can calculate the prices of the Geometry Boxes and Pens.
Type the given To calculate the price of Pencils,
1 data in the Excel type the =PRODUCT(B3:C3) 2
function and press Enter key.
worksheet.
Calculate
the Tax by
using the
=(D6*7)/100 4
formula.
To calculate the subtotal, type Calculate the Total by
the =SUM(D3:D5) function 5 using the =SUM(D6:D7)
3 and press Enter key from the function.
keyboard.
Text Functions
Text functions are used to work on the characters entered as text.
Functions Purpose Example
Input: =LEN(A3)
Len(text) It returns the length of the text string. Output: 6
Input: =UPPER(C3)
Upper(text) It converts the text string into uppercase. Output: CHIRAG SHARMA
Input: =LOWER(B3)
Lower(text) It converts the text string into lowercase. Output: sharma
Let us use the Text functions by performing the following steps:
Type =UPPER(C3) function
Type the given to convert the full name
1 data in the Excel into uppercase and press 2
worksheet. Enter key.
When you press the Enter key, the full name appears in uppercase.
Editing Cell Contents in Excel 2021 83

