Question

Cell B8 contains the formula =Average (B10:D12). What will be the contents of cell B9 if the formula in cell B8 is copied to cell B9?

Answer 1

the formula remains the same but the data given in cell b8 if it is copied to cell b9 an error will occur as no average will be found with two same numerals

Answer 2

Given:

Cell B8 contains the formula =Average (B10: D12).  

If the formula in cell B8 is copied to cell B9, then the contents of cell B9 shows the error and cannot found the average because the average cannot be found with the same numerals.

If the date of B8 is copied to the cell of B9, then the numerals are identical here.

So can’t get the average.