Page 49 - 2502_Pakistan-kifayat_C-8

Let us use the mathematical functions in Excel.

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
Type the Pencils, type the
given data =PRODUCT(B3:C3)
1 in the Excel function and press 2
worksheet. Enter key.

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 analyse data effectively. Here are some commonly
used statistical functions in Excel:
Functions Purpose Example

It returns the largest value from the values Input: =MAX(4,16,12,9)
Max(range) passed as argument or values in the given
range. Output: 16
It returns the smallest value from the values Input: =MIN(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 Input: =AVERAGE(12,3,6)
Average(range)
as argument or given numbers in a range. Output: 7

#Microsoft Excel 47