Page 32 - Digicode_AI_class_6
P. 32
In functions, we can also use the cell address in place of the values.
When you press the Enter key, the price of the pencils appears in the cell D3. Using the AutoFill
feature, we can calculate the prices of the Geometry Boxes and Pens.
3 To calculate the subtotal, type the =SUM(D3:D5)
function and press the Enter key.
4 Calculate the Tax by
using the =(D6*7)/100
formula.
5 Calculate the Total by using the =SUM(D6:D7) function.
Text Functions
Functions Purpose Example
Concatenate It joins together two or more Input: =CONCATENATE(“Digi”, “code”)
(text1, text2) different text strings. Output: Digicode
It returns the specified number Input: =LEFT(“Digi”,3)
Left(text, num_
of characters from the left side Output: Dig
chars)
of the text string.
It returns the specified number Input: =RIGHT(“Digi”,3)
Right(text, num_
of characters from the right Output: igi
chars)
side of the text string.
It returns the length of the Input: =LEN(“Digi”)
Len(text)
text string. Output: 4
30 DigiCode AI-VI

