USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data
|
|
|
Proofing
|
|
|
Formulas
|
|
|
Advanced
|
Detailed explanation-1: -If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.
Detailed explanation-2: -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-3: -If you have the Excel desktop application, you can use the Open in Excel button to open your workbook to use error checking rules that help you check your formulas for errors. Here’s how: Click Open in Excel and use error checking to detect errors in formulas.
Detailed explanation-4: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.