USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To quickly highlight an entire range within a column, you can click on the first cell of that range and:
|
|
Press Ctrl + Shift + ↓
|
|
|
Press Ctrl + Alt + ↓
|
|
|
Double-click cell border
|
|
|
Hold the shift key
|
Explanation:
Detailed explanation-1: -Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
Detailed explanation-2: -To select a larger range, it’s easier to click the first cell and hold down the Shift key while you click the last cell in the range. You can scroll to make the last cell visible.
Detailed explanation-3: -Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK.
There is 1 question to complete.