If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

A. From Edit menu choose Clear and then Formats

B. From Edit menu choose Delete

C. Click on Remove Formatting tool on Standard Toolbar

D. Double click the Format Painter and then press Esc key in keyboard

You can do it
  1. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  2. What is represented by the small, black square in the lower-right corner of an active cell or range?
  3. You can use the formula pallette to
  4. Excel files have a default extension of
  5. Excel probably considers the cell entry January 1, 2000 to be a
  6. How do you insert a row?
  7. When you insert an excel file into a word document. The data are
  8. When integrating word and excel, word is usually the
  9. Excel uniquely identifies cells within a worksheet with a cell name
  10. Which menu option can be sued to split windows into two
  11. In help menu of Excel, which of the following tabs are found?
  12. To center worksheet titles across a range of cells, you must
  13. What are the tabs that appear at the bottom of each workbook called?
  14. How do you wrap the text in a cell?
  15. Hyperlinks can be
  16. MS-EXCEL is based on .........?
  17. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  18. How many worksheets can a workbook have?
  19. Which of the following is not a valid data type in Excel?
  20. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  21. Text formulas:
  22. Which of the following is not true regarding Conditional Formatting?
  23. Which of the following action removes a sheet from workbook?
  24. The command Edit >> Fill Across Worksheet is active only when
  25. Which of the following is a correct order of precedence in formula calculation?
  26. Which of the following is the latest version of Excel
  27. B7:B9 indicates:
  28. Right clicking something in Excel:
  29. In the formula, which symbol specifies the fixed columns or rows?
  30. To create a formula, you can use: