Page 32 - Computer Genius Class 06
P. 32
n unctions e can also use the cell address in place o the alues.
When you press the Enter key, the price of the pencils appears in the cell D3. sing 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 ey.
4 Calculate the Tax by
using the =(D6*7)/100
ormula.
5 Calculate the Total by using the =SUM(D6:D7) unction.
Text Functions
Functions Purpose Example
Concatenate It joins together two or more Input: =CONCATENATE(“Digi”, “code”)
te t1 te t2 different te t strings. Output: Digicode
t returns the specified num er Input: =LEFT(“Digi”,3)
e t te t num
of characters from the left side Output: Dig
chars)
o the te t string.
t returns the specified num er Input: T igi
ight te t num
of characters from the right Output: igi
chars)
side o the te t string.
It returns the length of the Input: =LEN(“Digi”)
en te t
te t string. Output: 4
30 Computer Genius-VI

