DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
blue square
|
|
|
red circle
|
|
|
green triangle
|
|
|
green diamond
|
Detailed explanation-1: -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. When you click the arrow next to the button, a list of options for error checking appears. For more information, see Detect errors in formulas.
Detailed explanation-2: -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.
Detailed explanation-3: -A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.
Detailed explanation-4: -It means the Excel believes the formula is in error. Go to Tools, Error Checking, Options, to disable all error checking, or select. the rules that should ‘flag’ an error.