DATABASE FUNDAMENTALS
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 two or more named cell references or ranges, click the arrow next to the Name box, and then click the name of the first cell reference or range that you want to select. Then, hold down CTRL while you click the names of other cells or ranges in the Name box.
There is 1 question to complete.