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. Tab scrolling button
  2. A worksheet range is a
  3. Which of the following is not a way to complete a cell entry?
  4. Which of the following is an absolute cell reference?
  5. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  6. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  7. The active cell:
  8. You can use the drag and drop method to
  9. What is the short cut key to replace a data with another in sheet?
  10. Which of the following series type is not valid for Fill Series dialog box?
  11. Which menu option can be sued to split windows into two
  12. How can you show or hide the gridlines in Excel Worksheet?
  13. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  14. Which of the following is not a basic step in creating a worksheet?
  15. Which menu option can be used to split windows into two?
  16. Which of the following is the oldest spreadsheet package?
  17. How many worksheets can a workbook have?
  18. A typical worksheet has …. Number of columns
  19. When a row of data is to be converted into columns
  20. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  21. You can use the formula pallette to
  22. To record a sequence of keystrokes and mouse actions to play back later we use:
  23. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  24. Multiple calculations can be made in a single formula using
  25. Which of the cell pointer indicates you that you can make selection?
  26. Excel displays the current cell address in the ........
  27. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  28. An excel workbook is a collection of
  29. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  30. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply