No products in the cart.

State the difference between copying and …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

State the difference between copying and moving cell in spreadsheet
  • 1 answers

Yogita Ingle 5 years, 1 month ago

Copy leaves the information in its original location and makes another copy of the information when you use Paste. But in moving it removes the information and pastes it to another location.

Usually, in computer science, "moving" is equivalent to "copying" something, then deleting the original. In other words, after copying something, you have two copies of the thing you copy; if you move something, only one, at the new place. However, specifically in Excel (and probably other spreadsheet programs as well), when you move a cell or a range, any formulae that refer to the cell (or to one of the cells in the range) will be updated; thus, in this sense, moving is no longer equivalent to "copy, then delete the original". For example: Cell B1 has the formula "=A1*10". If you move the contents of cell A1 to A5 (you can do this in several ways; one is by selecting the cell, and dragging the border), then the formula in B1 will change to "=A5*10".

http://mycbseguide.com/examin8/

Related Questions

All notes
  • 0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App