Question

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

Hint:

Common formula errors include \textit{\#DIV/0!}, \textit{\#REF!}, and \textit{\#NAME?}. Always use proper references and check for typos in formulas.

Answer 1

The ‘Mark Common Formula Error’ feature in Excel helps identify common formula issues, such as division by zero, invalid cell references, or inconsistent formulas. Follow these steps to use it: Enable Error Checking: Go to \textit{File > Options > Formulas} and ensure the \textit{Error Checking} option is enabled. Identify Errors: When an error occurs, Excel displays a small green triangle in the top-left corner of the affected cell. Review Error Messages: Hover over the cell to see a warning icon. Click the icon to view a dropdown list of possible errors. Fix the Error: Select an appropriate option from the dropdown menu, such as \textit{Edit in Formula Bar}, to correct the formula. Use Formula Auditing Tools: Access \textit{Formulas > Formula Auditing} to trace errors or evaluate formulas step-by-step.