Home

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. When integrating word and excel, word is usually the
  2. Which setting you must modify to print a worksheet using letterhead?
  3. What do you mean by a Workspace?
  4. Which of the following is not a valid data type in Excel?
  5. How do you display current date only in MS Excel?
  6. Which of following is Not one of Excels what-if function?
  7. Multiple calculations can be made in a single formula using
  8. How can you find specific information in a list?
  9. What is the short cut key to replace a data with another in sheet?
  10. It is acceptable to let long text flow into adjacent cells on a worksheet when
  11. You can check the conditions against __________ when applying conditional formatting
  12. Which of the following series type is not valid for Fill Series dialog box?
  13. MS Excel provides the default value for step in Fill Series dialog box
  14. You can use the horizontal and vertical scroll bars to
  15. You can use the format painter multiple times before you turn it off by
  16. How do you delete a column?
  17. Concatenation of text can be done using
  18. Where can you set the shading color for a range of cells in Excel?
  19. Files created with Lotus 1-2-3 have an extension
  20. Text formulas:
  21. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  22. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  23. Which of the following is not an example of a value?
  24. Excel displays the current cell address in the ........
  25. Which would you choose to create a bar diagram?
  26. Which key do you press to check spelling?
  27. Comments can be added to cells using
  28. Which menu option can be used to split windows into two?
  29. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  30. You can move a sheet from one workbook into new book by