Question

David uses Office Excel 2013 to calculate his average marks. He enters a formula in cell B5 to calculate the average based on the values in cells B2 to B4, as displayed in the exhibit. David realizes that he entered his Science score as 67 instead of 69. What will cell B5 display if he changes the value in cell B4 to 69?

Answer 1

Answer:

The updated average.

Explanation:

The Microsoft excel spread sheet, in this context, requires input average input from cell B2 to B4.

The formula for the average is given with the function "=Average(B2:B4)" is written in the cell B5.

Mathematically, the spread sheet adds the values in cell B2, B3 and B4 and divides it by 3 and displays the result in the cell B5.

When a value in the range of selected values is changed like David's science score, from 67 to 69, the value of the average in the cell B5 changes automatically in the excel worksheet.