Home

Where can you change automatic or manual calculation mode in Excel?

A. Double CAL indicator on status bar

B. Go to Tools >> Options >> Calculation and mark the corresponding radio button

C. Both of above

D. None of 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 yup
  1. In a worksheet you can select
  2. To create a formula, you first:
  3. Which of the following options is not located in the Page Setup dialog box?
  4. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  5. When integrating word and excel, word is usually the
  6. What does COUNTA () function do?
  7. A numeric value can be treated as a label value if it precedes with
  8. Which function is not available in the Consolidate dialog box?
  9. Which of the following is not the correct method of editing the cell content?
  10. When a range is selected, how can you activate the previous cell?
  11. Which is not the function of Edit, Clear command?
  12. In help menu of Excel, which of the following tabs are found?
  13. Which of the following Excel screen components can NOT be turned on or off?
  14. Which of the following is not an example of a value?
  15. What are the tabs that appear at the bottom of each workbook called?
  16. Which of the following methods can not be used to edit the contents of a cell?
  17. We can save and protect the workbook by
  18. It is acceptable to let long text flow into adjacent cells on a worksheet when
  19. The name box
  20. Which menu option can be used to split windows into two?
  21. An Excel Workbook is a collection of .......
  22. While Finding and Replacing some data in Excel, which of the following statement is valid?
  23. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  24. It is acceptable to let long text flow into adjacent cells on a worksheet when
  25. Which of the following series type is not valid for Fill Series dialog box?
  26. You can move a sheet from one workbook into new book by
  27. How do you display current date only in MS Excel?
  28. Each excel file is called a workbook because
  29. The short cut key Ctrl + R is used in Excel to
  30. How many worksheets can a workbook have?