DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL+HOME
|
|
|
CTRL+END
|
|
|
HOME
|
|
|
END
|
Detailed explanation-1: -Ctrl + Home is used to move the active cell to the cell A1 in MS-Excel. Alternatively referred to as Control+Home and C-Home, Ctrl+Home is a keyboard shortcut that moves the cursor to the beginning of a document.
Detailed explanation-2: -Jump to cell A1 by shortcuts If you want to quickly jump to cell A1 from anywhere of the sheet, you just need to hold Ctrl key, and press Home, then the cursor jumps to the cell A1 at once.
Detailed explanation-3: -You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.
Detailed explanation-4: -Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK.
Detailed explanation-5: -Detailed Solution. The correct answer is Moves the cursor to the beginning of the document. Ctrl + Home is a shortcut key used in MS Word to move the cursor to the beginning of the document.