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

You can do it
  1. Which area in an excel window allows entering values and formulas
  2. You can select a single range of cells by
  3. A numeric value can be treated as a label value if it precedes with
  4. The Cancel and Enter buttons appear in the:
  5. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  6. You can use the format painter multiple times before you turn it off by
  7. To edit in an embedded excel worksheet object in a word document
  8. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  9. Which of the following formulas will Excel Not be able to calculate?
  10. Which of the following series type is not valid for Fill Series dialog box?
  11. Concatenation of text can be done using
  12. Which of the following is not a way to complete a cell entry?
  13. Which is used to perform what if analysis?
  14. How many characters can be typed in a single cell in Excel?
  15. When you copy a formula
  16. When a range is selected, how can you activate the previous cell?
  17. What symbol is used before a number to make it a label?
  18. How can you remove borders applied in cells?ACC
  19. Edit >> Delete command
  20. Which of the following is not true regarding Conditional Formatting?
  21. You can use the formula pallette to
  22. Tab scrolling button
  23. You can edit a cell by
  24. Which tool you will use to join some cells and place the content at the middle of joined cell?
  25. Right clicking something in Excel:
  26. Which of the following formulas is not entered correctly?
  27. Which button do you click to add up a series of numbers?
  28. When the formula bar is active, you can see
  29. The spelling dialog box can be involved by choosing spelling from ________ menu.
  30. How do you display current date and time in MS Excel?