DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL-END
|
|
|
CTRL-ALT
|
|
|
CTRL-HOME
|
|
|
none of these
|
Detailed explanation-1: -The correct answer is Ctrl + Home. 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: -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-3: -HOME Move to the beginning of the row. CTRL+HOME Move to the beginning of the worksheet. 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.
Detailed explanation-4: -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-5: -For example, press Alt+H to open the Home tab, and Alt+Q to move to the Tell me or Search field. Press Alt again to see KeyTips for the options for the selected tab.