USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula. When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.
Detailed explanation-2: -Double click cell to follow formula or edit cell The default setting when you double click a cell is it allows you to edit the cell without going to the formula bar. To change this so that you can double click and you will be taken to the first link in the formula, you just need to change a setting.
Detailed explanation-3: -When you double-click on a cell, you are effectively re-entering the cell contents, which are then interpreted as numeric. One way that happens is: the cells were formatted as Text when data was entered, then the cell format was changed to General or a numeric format.
Detailed explanation-4: -Double clicking a formula cell does not highlight reference cells anymore between different worksheets. They show on the individual worksheet, just not between worksheets. Double clicking a formula cell does not highlight reference cells anymore between different worksheets.