USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Error Checking
|
|
|
Evaluate Formula
|
|
|
Trace Dependents
|
|
|
Trace Precedents
|
Detailed explanation-1: -The FORMULATEXT function returns a text string that shows the formula in a worksheet cell.
Detailed explanation-2: -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-3: -Trace Dependents is an in-built formulas auditing tool provided in Microsoft Excel. It helps users to analyze the relationship between the cells in a worksheet. Trace dependents are used to show the cells that are affected by the active cell.
Detailed explanation-4: -When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window toolbar. The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets.