FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.

Detailed explanation-2: -With the spreadsheet open that you want to check, click on the Formulas tab and then ‘Error Checking’ in the formula auditing group. This is what will open up. It will go to the 1st error on the sheet in this dialog box. Click on the ‘Edit in formula bar’ and correct it.

Detailed explanation-3: -If you click on the Excel ribbon tab called Formulas, you can see the section labeled Formula Auditing. You may have to customize the ribbon to see this option. Below are the various ways that you can audit a formula. Trace Precedents shows you all of the cells used to calculate a certain cell’s value.

Detailed explanation-4: -Error checking is part of Excel’s auditing tools. It is set up to check your formulas for errors. Like spellcheck, the Error checker tool won’t necessarily find all errors, but it is a useful auditing tool as it works through your document to flag up the errors it spots.

Detailed explanation-5: -You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.