USING MICROSOFT EXCEL
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: -In Microsoft Excel, green triangles indicate possible errors in a cell’s contents. Red triangles indicate the presence of user comments in the worksheet cell. The green triangle appears in the top left corner of a cell, while the red triangle appears in the top right corner of a cell.
Detailed explanation-3: -Select the cell to which the arrow is pointing. On the Formulas tab, click Remove All Arrows in Formula Auditing group, and then click Remove Precedent Arrows.
Detailed explanation-4: -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.