DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -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.
Detailed explanation-4: -Trace Dependents is an Excel auditing tool that shows the cells that are affected by an active cell by displaying arrows linking the related cells to the active cell.