DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Shift + Spacebar
|
|
|
Ctrl + Spacebar
|
|
|
Shift + End
|
|
|
Ctrl + End
|
Detailed explanation-1: -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-2: -SHIFT+SPACEBAR Select the entire row. CTRL+A Select the entire worksheet. SHIFT+BACKSPACE With multiple cells selected, select only the active cell.
Detailed explanation-3: -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.
Detailed explanation-4: -Select an entire column in a worksheet. Ctrl+Spacebar. Select an entire row in a worksheet. Shift+Spacebar. Select all objects on a worksheet when an object is selected.
Detailed explanation-5: -Close a task pane Press Ctrl+Spacebar. Use the arrow keys to select Close, and then press Enter.