Home

While Finding and Replacing some data in Excel, which of the following statement is valid?

A. You can Find and Replace within the sheet or workbook

B. Excel does not have option to match case for find

C. Both are valid

D. None are valid

You can do it
  1. To create a formula, you can use:
  2. Long text can be broken down into many lines within a cell. You can do this through
  3. You can auto fit the width of column by
  4. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  5. MS Excel provides the default value for step in Fill Series dialog box
  6. Multiple calculations can be made in a single formula using
  7. A worksheet can have a maximum of . Number of rows
  8. How can you show or hide the gridlines in Excel Worksheet?
  9. Which of the following is not a term of MS-Excel?
  10. When a row of data is to be converted into columns
  11. Which of the following is not information you can specify using the solver?
  12. How can you remove borders applied in cells?ACC
  13. Which of following is Not one of Excels what-if function?
  14. Data can be arranged in a worksheet in a easy to understand manner using
  15. Which of the following you can paste selectively using Paste Special command?
  16. The spelling dialog box can be involved by choosing spelling from ________ menu.
  17. To record a sequence of keystrokes and mouse actions to play back later we use:
  18. You can use the drag and drop method to
  19. To select an entire column in MS-EXCEL, press?
  20. Edit >> Delete command
  21. Which symbol must all formula begin with?
  22. Which of the following is the latest version of Excel
  23. Which of the following is not a valid data type in Excel?
  24. Which of the following is a correct order of precedence in formula calculation?
  25. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  26. What is the short cut key to replace a data with another in sheet?
  27. Which setting you must modify to print a worksheet using letterhead?
  28. Ctrl + D shortcut key in Excel will
  29. Getting data from a cell located in a different sheet is called ......
  30. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?