Home

Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit >> Delete Sheet

B. Select the sheet then choose Format >> Sheet >> Hide

C. Both of above

D. None of above

You can do it
  1. How many characters can be typed in a single cell in Excel?
  2. Which tool you will use to join some cells and place the content at the middle of joined cell?
  3. Which language is used to create macros in Excel?
  4. The Delete key of keyboard is assigned to which command in Excel?
  5. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  6. What do you mean by a Workspace?
  7. The auto calculate feature
  8. B7:B9 indicates:
  9. Which of the following methods can not be used to edit the contents of a cell?
  10. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  11. In a worksheet you can select
  12. When a row of data is to be converted into columns
  13. Where can you change automatic or manual calculation mode in Excel?
  14. Which of the following options is not located in the Page Setup dialog box?
  15. You can copy data or formulas
  16. Which of the following formulas is not entered correctly?
  17. Which of the following is not true regarding Conditional Formatting?
  18. Excel displays the current cell address in the ........
  19. Which of the following methods cannot be used to enter data in a cell
  20. Which of the following you can paste selectively using Paste Special command?
  21. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  22. The first cell in EXCEL worksheet is labeled as
  23. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  24. Where can you set the shading color for a range of cells in Excel?
  25. While Finding and Replacing some data in Excel, which of the following statement is valid?
  26. How do you display current date and time in MS Excel?
  27. You can select a single range of cells by
  28. Which of the following option is not available in Paste Special dialog box?
  29. You can auto fit the width of column by
  30. To return the remainder after a number is divided by a divisor in EXCEL we use the function?