USING MICROSOFT EXCEL
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 SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your 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: -To switch between sheets in Excel using a keyboard shortcut, just press Ctrl+Page Up or Ctrl+Page Down. This will move you to the previous or next sheet in your workbook, respectively. You can also use the Ctrl+Tab shortcut to cycle through all the sheets in your workbook.
Detailed explanation-4: -Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar.
Detailed explanation-5: -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.