Computer Applications
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
Answer
The Delete All option deletes all content from the selected cell range.
The Text option deletes text only. Formats, formulas, numbers and dates are not affected.The Text option deletes text only and does not affect formats, formulas, numbers and dates.
The Formats option deletes format attributes applied to cells. All the cell content remains unchanged.The Text option deletes text only and does not affect formats, formulas, numbers and dates.
The Notes option deletes notes added to cells. All other elements remain unchanged.
Related Questions
Differentiate between mixed referencing and absolute referencing by giving suitable examples.
What is the difference between copying and moving a range ?
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
Create the following worksheet in Ooo Calc.
(i) From the above worksheet find out the average marks for the entire class.
(ii) Now copy the range consisting of the mentioned data (including total, average & class average) to a new location. Find out whether the cell references change or not.
(iii) Now move the original data range to a new location. Find out whether the cell references change or not.
(iv) Again move back the data to its original position and make changes in the marks obtained by students. Notice total, average and class average. What happens ? Why does this happen ?