DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Arrow keys
|
|
|
Tab key
|
|
|
Enter key
|
|
|
All of the above
|
Detailed explanation-1: -Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet.
Detailed explanation-2: -The correct answer is Ctrl and Home. CTRL + home brings you back to the top of the sheet. However, if you froze a part of the screen with the freeze option under the window menu then it will not work. CTRL+ Arrow key will move the cursor one word at a time left and right and a paragraph at a time up and down.
Detailed explanation-3: -Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar.
Detailed explanation-4: -Note: To select the very last cell in a row or column, press END, and then press the RIGHT ARROW key or the DOWN ARROW key.
Detailed explanation-5: -Use the keyboard shortcut CTRL + TAB Simply press CTRL + TAB to move to the next sheet, or CTRL + SHIFT + TAB to move to the previous sheet.