USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
|
|
ALT
|
|
|
F3
|
|
|
CTRL
|
|
|
F10
|
Explanation:
Detailed explanation-1: -Most people know that you can select a noncontiguous range of cells by using the mouse. All you need to do is click the first cell in the range and then hold down the Ctrl key as you click other cells in the range.
Detailed explanation-2: -Pressing CTRL+A a second time selects the entire worksheet. Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. 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.
There is 1 question to complete.