DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
error indicator
|
|
|
message
|
|
|
dialog box launcher
|
|
|
None of the above
|
Detailed explanation-1: -Green triangle A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error. button appears. Click the arrow next to the button for a list of options. For more information, see Detect errors in formulas.
Detailed explanation-2: -The simple answer is that it is an error checking feature in Excel. Whenever you see the green triangles it means that Excel has found something in the cell that could be a risk. If Excel errors worry you, look at our free Auditing Spreadsheets course.
Detailed explanation-3: -If a cell contains a formula that breaks a rule that Excel uses to check for problems, a triangle appears in the top-left corner of the cell. You can prevent these indicators from displaying. On the Excel menu, click Preferences., and then clear the Enable background error checking check box.
Detailed explanation-4: -What Are the Little Green Arrows in Excel? The little green arrows that sometimes how up in your Excel cells are error checking indicators show Microsoft has detected an error in your formula or calculation.