Question

write the formula to get the following a.find the average if values from C2:E2 class 6​

Answer 1

Answer:

• THIS WILL HELP YOU

Step-by-step explanation:

=AVERAGE(number1, [number2], …)

The function uses the following arguments:

Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average.

Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average. A maximum of 255 numbers is allowed.

How to use AVERAGE Function in Excel?

To understand the uses of the AVERAGE function, let us consider a few examples:

Example 1 – Average in Excel

Suppose we are given the following data:

AVERAGE Function

We wish to find out the top 3 scores in the above data set. The formula to use will be:

AVERAGE Function - Example 1

We get the result below:

AVERAGE Function - Example 1a