FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What keyboard shortcut makes the active cell A1
A
Ctrl + End
B
Ctrl + Page Up
C
Ctrl + Home
D
Ctrl + Tab
Explanation: 

Detailed explanation-1: -Detailed Solution. 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: -The correct answer is Ctrl + R. In Excel, shortcut key Ctrl + R is used to fill the selected cell with active cells to the right.

Detailed explanation-3: -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-4: -Double clicking on a cell will simply activate and make it editable. You can also make a cell editable by clicking in the formula bar. This method works only if the cell you want to edit is active.

Detailed explanation-5: -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.

There is 1 question to complete.