Page 50 - 2502_Pakistan-kifayat_C-8

Functions Purpose Example

It returns the count of the number of values in Input: =COUNT(4,8,12)
Count(range)
the selected range. Output: 3

Let us use the statistical functions in Excel. To use the statistical functions, follow the given steps:

2 Type =MAX(B3:F3) function to find the
maximum marks and press the Enter key.

Type the following
1 data in the Excel
worksheet.

When you press the Enter key, the maximum marks appear in cell G3. Using the AutoFill feature, find the
maximum marks of each student. Similarly, we can find the minimum marks by using the MIN() function.

3 Type =AVERAGE(B3:F3) function to find the
average of marks and press the Enter key.

When you press the Enter key, the average of the marks appears in cell I3. Using the AutoFill feature,
we can calculate the average of the marks of each student.

CREATING AND USING FORMULAS

Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with equal to sign,
Excel understands that user has entered a formula here. If you don’t enter the equal sign, Excel will
treat your entry as text and the calculation will fail.

48 Premium Edition-VIII