Page 58 - 2611_SmartGPT Pro V(5.0) C-5

Functions Purpose Example

Input:
Average(range) It returns the average of the given =AVERAGE(12,3,6)
numbers in a range.
Output: 7

PURE
In functions, we can also use the cell address in place of the values. FACT

Perform the following steps to use the mathematical functions:

1 Type the given
data in the Excel
worksheet.

2 To calculate the price of Pencils,
type the =PRODUCT(B3:C3) function
and press Enter key.

4 Calculate the
Tax by using the
=(D6*7)/100
formula.

3 To calculate the subtotal, type 5 Calculate the
the =SUM(D3:D5) function and Total by using the
press Enter key from the keyboard. =SUM(D6:D7) function.

When you press the Enter key, the price of the pencils appears in cell D3. Using the AutoFill
feature, we can calculate the prices of the Geometry Boxes and Pens.

Text Functions

Text functions are used to work on the characters entered as text.

56 Computer Science (V5.0)-V