Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 44 of 53

Spreadsheet Tool : OO Calc I — Question 16

Back to all questions
16
Question

Question 17

What is the difference between the following commands :

  1. Edit → Delete Contents → Delete all and
    Edit → Delete Contents → Text

  2. Edit → Delete Contents → Text and
    Edit → Delete Contents → Formats

  3. Edit → Delete Contents → Text and
    Edit → Delete Contents → Notes

Answer

  1. 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.

  2. 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.

  3. 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.