Copying and moving data!

Question 1

What does copying refer to?

Answer 1

Copying refers to duplicating dat, like formulae, text or numbers either in the same worksheet or in another worksheet.

Question 2

What does moving refer to?

Answer 2

Moving refers to the changing the position of data either in the same worksheet or in another worksheet.

Question 3

Where is the moved or copied data temporarily stored?

Answer 3

The moved or copied data is temporarily stored in a location in computer memory called Clipboard.

Question 4

How to copy and paste data?

Answer 4

Select the cell or range of cells you want to copy and click on the Copy button in the Clipboard group. The dashed line will appear around the selected cells. Select the destination cell and click on the Paste button in the Clipboard group.

Question 5

What to do if you want to paste the same data repeatedly?

Answer 5

If you want to paste the same data repeatedly, click on the Paste button in different cells.

Question 6

How to remove the border around the selected cells after you finish copying?

Answer 6

To remove the border around the selected cells after you finish copying, press the Esc key.

Question 7

How to move data around using the drag and drop method?

Answer 7

Select a cell or range of cells and position the mouse pointer at the edge of the selected cells, which has changed from a white cross symbol to a move pointer symbol. Drag the cell or range of cells to a new destination and release the mouse.

Question 8

How to move data by using the shortcut menu?

Answer 8

Right-click on the cell and chose the Cut command and choose the destination cell and, right-click on it and select the Paste option

Question 9

What are the control keys to perform the cut, copy and paste operations?

Answer 9

Cut=Ctrl+X ,Copy=Ctrl+C, Paste=Ctrl=V

Question 10

Where are the Cut, Copy and Paste buttons present?

Answer 10

The Cut, Copy, and Paste buttons are present in the Clipboard group.