DATABASE FUNDAMENTALS
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 also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection.
Detailed explanation-2: -To select the non-adjacent cells, press Shift+F8. This, in turn, enables the Add or Remove Selection mode. Now, use the arrow keys to move the selection and select the cells you want.
Detailed explanation-3: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. You can nest IF functions as deep as you want, but after you get yet beyond a nest of three IF functions, the logic becomes difficult to follow.
Detailed explanation-4: -When should you use the shift key for selecting multiple cells? When you wish to select very large groups of cells. What are format attributes? Pieces of information that describe the appearance of the cells content.
Detailed explanation-5: -First, all of the cells must be adjacent to each other. This means that they must be next to each other horizontally or vertically, but not diagonally. Second, the cells must be in the same row or column; you cannot select a range of cells that are in different rows or columns.