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 do you display current date only in MS Excel?
  2. How do you delete a column?
  3. You can use the horizontal and vertical scroll bars to
  4. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  5. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  6. The Paste Special command lets you copy and paste:
  7. Getting data from a cell located in a different sheet is called ......
  8. Which menu option can be sued to split windows into two
  9. You can select a single range of cells by
  10. To create a formula, you first:
  11. The spelling dialog box can be involved by choosing spelling from ________ menu.
  12. Which of the following is not the correct method of editing the cell content?
  13. MS Excel provides the default value for step in Fill Series dialog box
  14. Excel displays the current cell address in the ........
  15. Which of the following is not a basic step in creating a worksheet?
  16. Which is used to perform what if analysis?
  17. To copy cell contents using drag and drop press the
  18. Which area in an Excel window allows entering values and formulas?
  19. To create a formula, you can use:
  20. You can copy data or formulas
  21. MS-EXCEL is based on .........?
  22. Which of the following action removes a sheet from workbook?
  23. When you link data maintained in an excel workbook to a word document
  24. How do you display current date and time in MS Excel?
  25. Which of following is Not one of Excels what-if function?
  26. Which function is not available in the Consolidate dialog box?
  27. To view a cell comment
  28. The command Edit >> Fill Across Worksheet is active only when
  29. How do you rearrange the data in ascending or descending order?
  30. Which symbol must all formula begin with?