Page 46 - C_GPT _V4 _class_6
P. 46
Functions Purpose Example
ROUND(number, It returns a number after rounding to the specified Input: =ROUND(35.666,2)
number_of_digits) digits. Output: 35.67
Input: =ABS(–25)
ABS(number) It returns the absolute value of a given number.
Output: 25
Input: =MAX(4,16,12,9)
Max(range) It returns the largest value in the given range.
Output: 16
Input: =MIN(4,16,12,9)
Min(range) It returns the smallest value in the given range.
Output: 4
It returns the average of the given numbers in a Input: =AVERAGE(12,3,6)
Average(range)
range. Output: 7
Factbot
In functions, we can also use the cell address in place of the values.
Perform the following steps to use the mathematical functions:
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.
To calculate the price
Type the given of Pencils, type the
1 data in the Excel =PRODUCT(B3:C3) function 2
worksheet. and press Enter key.
Calculate
the Tax by
using the
=(D6*7)/100 4
formula.
To calculate the subtotal, type the Calculate the Total by
3 =SUM(D3:D5) function and press 5 using the =SUM(D6:D7)
Enter key from the keyboard. function.
44 CodeGPT (Ver. 4.0)-VI

