Question

How to use 'Mark Common Formula Error' in Excel? Explain.

Accepted Answer

Following are the steps to mark common formula errors: (i) Click the Microsoft Office button, click Excel options and then click the formulas category. (ii) In the error checking section, select the Enable background error checking check box. (iii) To change the colour of the triangle, that marks where an error occurs in the indicate errors using the colour box, select a new colour. (iv) Select a cell with triangle in top left corner of a cell. (v) Next to the cell click error checking button that appears, and then click the option that we want. The commands are different for each type of error and the first entry describes the error. If we click Ignore Error, the error is marked to be ignored for each consecutive check. • Repeat the two previous steps

How to use 'Mark Common Formula Error' in Excel ? Explain.

Marking-scheme solution

More from Spreadsheet