FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which command would you use if you wanted to move row 6 in between rows 3 and 4 without overwriting any data?

A	Paste
B	Merge
C	Insert
D	Insert copied cells

Explanation:

Detailed explanation-1: -Copy the completed cell (CTRL +C), then select the cells (SHIFT + Arrow Keys) where you want to repeat the formula and do a Paste (CTRL + V or Enter), or Paste Special (CTRL + ALT + V) if you only want to paste some attributes of the copied cell.

Detailed explanation-2: -Note: You can still do simple cut, copy, and paste the way you’re used to, either by using the buttons on the ribbon or the keyboard shortcuts CTRL+X (Cut), CTRL+C (Copy), or CTRL+V (Paste).

Detailed explanation-3: -To undo an action press Ctrl+Z.

Detailed explanation-4: -Ctrl + U: Underline the selected text. This shortcut will underline the selected text in the worksheet. If no text is selected, the shortcut will underline the cell that the cursor is currently in.

There is 1 question to complete.