Page 21 - 2617_JSSPS_C-6

Functions Purpose Example
It returns the count of the number of values in the Input: =COUNT(4,8,12)
Count(range)
selected range. Output: 3
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.

Charts, Formulas & Functions in Excel 19