USING MICROSOFT EXCEL
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: -The Trace Error button appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left corner of the cell.
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.