Question

What does the formula = average (a1:c1 ,B2) mean ?

Answer 1

Answer:

The simplest Excel Average Formula for a set of values consists of the = sign, followed a the sum of the values, all divided by the number of values in the group.

A simple Excel average formula, that calculates the average of the three values 5, 10 and 15, is shown in cell A1 of the above spreadsheet .

Note that the expression 5 + 10 + 15 is encased in brackets. This is necessary to ensure that the sum of the three values (not just the last value) is divided by the value 3.As with all Excel formulas, instead of typing in the numbers directly, you can use references to cells containing numbers.

The Excel average formula in cell A1 of the above spreadsheet calculates the average of the values in cells B1, B2 and B3. Again, the formula returns the result 10.

Answer 2

Explanation:

Hope it is useful for you