DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
|
|
|
Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
|
|
|
Select the first column. Hold down Shift and press the right arrow on the keyboard.
|
|
|
All of the above options are correct.
|
Detailed explanation-1: -Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse. What is a shortcut for quickly selecting a range of contiguous columns? Select the first column. Hold down Shift and press the right arrow on the keyboard.
Detailed explanation-2: -You may sometimes need to select an entire row or column at once. Luckily, there are a few shortcuts that can help with this. To select an entire row, click the row number or press Shift+spacebar on your keyboard. To select an entire column, click the column letter or press Ctrl+spacebar.
Detailed explanation-3: -To select all cells in a column to the right of the active cell that contain data, press Ctrl+Shift+End. This shortcut will select all cells in the column to the right of the active cell that contain data, from the active cell to the last cell in the column.
Detailed explanation-4: -The shortcut key to group rows in Excel is Alt + Shift + Right Arrow. To use this shortcut key, simply select the range of cells that you want to group together and then press Alt + Shift + Right Arrow on your keyboard. Excel will automatically group the data together.
Detailed explanation-5: -Select one or more rows and columns Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.