DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
|
|
Find Error
|
|
|
Explain Error
|
|
|
Fix Error
|
|
|
Trace Error
|
Explanation:
Detailed explanation-1: -On the Formulas tab of the Ribbon, under Error Checking, you’ll find an option called Trace Error. To use this feature, first select a cell that contains an error, then choose “Trace Error.” Excel will draw errors in red that indicate the source of the problem.
Detailed explanation-2: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.
There is 1 question to complete.