FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What command allows you to leap to the last row of the spreadsheet?
A
CTRL + (Down Arrow)
B
ALT + (Down Arrow)
C
SHIFT + (Down Arrow)
D
CTRL + SHIFT + (Down Arrow)
Explanation: 

Detailed explanation-1: -To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key. Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.

Detailed explanation-2: -Locate the last cell that contains data or formatting on a worksheet. To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.

Detailed explanation-3: -In both Excel and Google Sheets it is possilbe to do [Ctrl] [Arrow key] to jump to the last filled non-blank row or column in series of rows/columns which allows quick navigation around a spreadsheet.

Detailed explanation-4: -CTRL+END Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. PAGE DOWN Move down one screen. PAGE UP Move up one screen. ALT+PAGE DOWN Move one screen to the right.

There is 1 question to complete.