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?

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.

a variable of array type holds a reference of object

array are commonly used in computer program to organize data so that a related set of values

array are using zero base indexing it start with 0.

all component of array have same type, two different types doesn't use in single array

if array are store 10 quantities its index value varies from 0 to 9.

it stores 1st quantity value in index value 0 and this process will same till index value 9.

answer; (& & );