Question

Before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.

Answer 1

Formula auditing tool displays the relationship between the formula and the cell in the excelsheet. There are following three steps before using formula editing tool :

Fix obvious errors : Before using the formula auditing tool, the errors which generally come across, should be rectified and sorted out.

Use Error Alert Button : If any error still comes, there should be an error alert button beeps up.

Examine the formula: The formula to solve the problem should be examined properly that there should not be any error in the same and it gives accurate results.