Page 48 - TP_Plus_v4_Class6
P. 48
Perform the following steps to use the mathematical functions:
In the given example, when you type the formula =PRODUCT(B3:C3) in cell D3 and 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 in cells D4 and D5.
To calculate the price
of Pencils, type the
Type the given =PRODUCT(B3:C3) function
1 data in the Excel and press Enter key. 2
worksheet.
3 Drag the Fill Handle
of Cell D3 to D5.
Calculate
the Tax by
using the
=(D6*7)/100 5
formula.
To calculate the subtotal, type the Calculate the Total by
4 =SUM(D3:D5) function and press 6 using the =SUM(D6:D7)
Enter key. function.
Statistical Functions
Excel offers a wide range of statistical functions to analyze data effectively. Here are some commonly
used statistical functions in Excel:
It returns the largest value from the values passed Input: =MAX(4,16,12,9)
Max(range)
as argument or values in the given range. Output: 16
It returns the smallest value from the values Input: =MAX(4,16,12,9)
Min(range)
passed as argument or values in the given range. Output: 4
It returns the average of the numbers passed as Input: =AVERAGE(12,3,6)
Average(range)
argument or given numbers in a range. Output: 7
It returns the count of the number of values in the Input: =COUNT(4,8,12)
Count(range)
selected range. Output: 3
Text Functions
Text functions are used to work on the characters entered as text.
Functions Purpose Example
Input: =CONCATENATE
Concatenate It joins together two or more different text (“Touch”, “pad”)
(text1, text2) strings.
Output: Touchpad
It returns the specified number of characters Input: =LEFT(“Touch”,3)
Left(text, num_chars)
from the left side of the text string. Output: Tou
It returns the specified number of characters Input: =RIGHT(“Touch”,3)
Right(text, num_chars)
from the right side of the text string. Output: uch
46 Plus (Ver. 4.0)-VI

