Computer Applications
Answer
| Copying a Range | Moving a Range |
|---|---|
| When we copy a range of cells, we create a duplicate copy of the selected cells. | When we move a range of cells, we are relocating the selected cells from their original location to a new location. |
| The original cells remain at their original location, and a copy is placed elsewhere in the worksheet. | The original cells are deleted from their original position and placed at the new location. |
| This is useful when we want to preserve the original data while using a copy for calculations, analysis, or other purposes. | This is useful when we want to reorganize our data within the same worksheet or between worksheets. |
Related Questions
Explain what are the different methods of cell referencing in OOo Calc ?
Differentiate between mixed referencing and absolute referencing by giving suitable examples.
What is the difference between the following commands :
Edit → Delete Contents → Delete all and
Edit → Delete Contents → TextEdit → Delete Contents → Text and
Edit → Delete Contents → FormatsEdit → Delete Contents → Text and
Edit → Delete Contents → Notes
Create the following worksheet and save the workbook as WAGES.ods.
(i) Find out the number of days each worker has worked, by subtracting date on which worker was hired from today's date.
(ii) Calculate Gross wages for each worker. The gross wages can be calculated by using the following formula :
Gross wages = No. of days worked * Pay rate