Home

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

Correct Answer : B.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. While Finding and Replacing some data in Excel, which of the following statement is valid?
  2. The Paste Special command lets you copy and paste:
  3. How do you select an entire column?
  4. Status indicators are located on the
  5. When you want to insert a blank imbedded excel object in a word document you can
  6. Text formulas:
  7. When you link data maintained in an excel workbook to a word document
  8. To copy formatting from one area in a worksheet and apply it to another area you would use:
  9. What is represented by the small, black square in the lower-right corner of an active cell or range?
  10. Which is used to perform what if analysis?
  11. You can use drag-and-drop to embed excel worksheet data in a word document
  12. The Cancel and Enter buttons appear in the:
  13. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  14. The command Edit >> Fill Across Worksheet is active only when
  15. What does COUNTA () function do?
  16. Which function is not available in the Consolidate dialog box?
  17. You can check the conditions against __________ when applying conditional formatting
  18. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  19. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  20. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  21. Which of the following is a correct order of precedence in formula calculation?
  22. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  23. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  24. To center worksheet titles across a range of cells, you must
  25. When integrating word and excel, word is usually the
  26. To activate the previous cell in a pre-selected range, press
  27. When a label is too long to fit within a worksheet cell, you typically must
  28. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  29. Edit >> Delete command
  30. Documentation should include