Page 25 - Trackpad_ipro 4.1_Class8
P. 25
To use the mathematical functions in Excel, follow these steps:
1 Type 2 To calculate the
price of Pencils, type
the data in
the =PRODUCT(B3:C3)
the Excel
function and press the
worksheet.
Enter key.
When you press the Enter key, the total price of the pencils appears in the cell D3. Using the
AutoFill feature, we can calculate the total prices of the Geometry Boxes and Pens.
4 Calculate the
Tax by using the
=(D6*7)/100
formula.
3 To calculate the subtotal, type 5 Calculate the Total by using
the =SUM(D3:D5) function and the =SUM(D6:D7) function.
press the Enter key.
When you press the Enter key, the subtotal appears in cell D6.
Text Functions
Function Purpose Example
Input: =CONCATENATE(“Track”,
Joins together two or more
CONCATENATE(text1, text2) “pad”)
different text strings
Output: Trackpad
Returns the specified number Input: =LEFT(“Track”,3)
LEFT(text, num_chars) of characters from the left Output: Tra
side of the text string
Returns the specified number Input: =RIGHT(“Track”,3)
RIGHT(text, num_chars) of characters from the right Output: ack
side of the text string
Returns the length of the text Input: =LEN(“Track”)
LEN(text)
string Output: 5
Spreadsheet—Functions and Charts 23

