FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -Select the cell or range of cells from which you want to clear formatting. On the Home tab, in the Editing group, click the arrow next to the Clear button. Select the Clear Formats option.

There is 1 question to complete.