Question

SUM (EZE3) will give an error while using spreadsheet. Identify the error and state the various steps to correct this type of error.

Accepted Answer

The name of the error is correct NULL! Errors. There is a typing mistake; separating mark, was not inserted between (E2, E3). There can be two reasons for this type of error. (i) Incorrect range operators. (ii) Ranges do not intersect To correct (i) Incorrect range operator (a) To refer to a contiguous range of cells, use a colon (:) to separate the reference to the first cell in the range from the reference of the last cell (b) To refer to two areas that don’t intersect, use the union operator – the comma (,) To correct (ii) Ranges do not intersect (a) If there are no squares at each corner of the colour-coded border, then the reference is to a named range (b) If there are squares at each corner of the colour-coded border, then the reference is not to a named range (c) Double-click the cell that contains the formula we want to change. Excel highlights each cell range of cells with different colours. Then do one of the following: • Drag the colour-coded border to a new cell or range. • To include more or fewer cells, drag a corner of the border • In the formula, select the reference and type a new formula. Then press Enter

Marking-scheme solution

More from Spreadsheet