FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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.
A
ALT
B
F3
C
CTRL
D
F10
Explanation: 

Detailed explanation-1: -To select noncontiguous ranges with the keyboard in Excel, hold down the Ctrl key while selecting the individual ranges you want to select. For example, if you wanted to select cells A1:A5, C1:C5, and E1:E5, you would hold down the Ctrl key and click on each of those ranges individually.

Detailed explanation-2: -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-3: -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.
Previous
Next