Home

The auto calculate feature

Share latest video status. Download from playstore now!

A. Can only add values in a range of cells

B. Provides a quick way to view the result of an arithmetic operation on a range of cells

C. Automatically creates formulas and adds them to a worksheet

D. A and c

Share this question with your friends

Correct Answer : B.


Download Objective type questions of Microsoft Excel PDF

Get all objective type questions of Microsoft Excel MCQ

Related Questions

  1. Excel files have a default extension of
  2. Multiple calculations can be made in a single formula using .......
  3. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  4. You can use the format painter multiple times before you turn it off by
  5. Long text can be broken down into many lines within a cell. You can do this through
  6. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  7. Which of the following is the oldest spreadsheet package?
  8. Which of the following formulas is not entered correctly?
  9. To save a workbook, you:
  10. Edit >> Delete command
  11. Which of the following options is not located in the Page Setup dialog box?
  12. The Chart wizard term data categories refers to;
  13. Which menu option can be used to split windows into two?
  14. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  15. B7:B9 indicates:
  16. You can use the formula palette to
  17. Which of the following is a correct order of precedence in formula calculation?
  18. The Paste Special command lets you copy and paste:
  19. When you copy a formula
  20. Excel uniquely identifies cells within a worksheet with a cell name
  21. To edit in an embedded excel worksheet object in a word document
  22. You can use drag-and-drop to embed excel worksheet data in a word document
  23. What is represented by the small, black square in the lower-right corner of an active cell or range?
  24. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  25. Which of the following is not true regarding Conditional Formatting?
  26. Which of the following is a popular DOS based spreadsheet package?
  27. The Cancel and Enter buttons appear in the:
  28. When integrating word and excel, word is usually the
  29. Which function is not available in the Consolidate dialog box?
  30. You can copy data or formulas

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..

Also checkout these categories

p-Block Element MCQ Design of Masonry Structures MCQ Chemical Equilibrium MCQ Microsoft Access MCQ Ecology MCQ Decimal Fraction MCQ Current Affairs June 2017 MCQ Decision Making MCQ Rearrangement Set 1 MCQ Cause & Effect MCQ Active and Passive Voice MCQ Senile enlargement of the prostate MCQ