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. How do you select an entire column?
  2. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  3. How can you remove borders applied in cells?ACC
  4. You can activate a cell by
  5. Edit >> Delete command
  6. To copy formatting from one area in a worksheet and apply it to another area you would use:
  7. Which of the following is the oldest spreadsheet package?
  8. How can you find specific information in a list?
  9. Multiple calculations can be made in a single formula using .......
  10. Which of the following formulas is not entered correctly?
  11. An Excel Workbook is a collection of .......
  12. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  13. What are the tabs that appear at the bottom of each workbook called?
  14. Getting data from a cell located in a different sheet is called ......
  15. Which Chart can be created in Excel?
  16. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  17. Which of the following is not a valid data type in Excel?
  18. How do you rearrange the data in ascending or descending order?
  19. Long text can be broken down into many lines within a cell. You can do this through
  20. Which of the following action removes a sheet from workbook?
  21. Which of the cell pointer indicate that you can move the content to other cell?
  22. Ctrl + D shortcut key in Excel will
  23. Which of the following methods cannot be used to enter data in a cell
  24. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  25. Comments put in cells are called
  26. Files created with Lotus 1-2-3 have an extension
  27. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  28. To activate the previous cell in a pre-selected range, press
  29. Which of the following options is not located in the Page Setup dialog box?
  30. What is the short cut key to highlight the entire column?