Home

The auto calculate feature

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

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. To center worksheet titles across a range of cells, you must
  2. When integrating word and excel, word is usually the
  3. Which is not the function of Edit, Clear command?
  4. To copy formatting from one area in a worksheet and apply it to another area you would use:
  5. When a row of data is to be converted into columns
  6. To create a formula, you first:
  7. Which of the following is not a basic step in creating a worksheet?
  8. What is the short cut key to highlight the entire column?
  9. To edit in an embedded excel worksheet object in a word document
  10. Concatenation of text can be done using
  11. What does COUNTA () function do?
  12. You can auto fit the width of column by
  13. Which of the following option is not available in Paste Special dialog box?
  14. Which of the following methods cannot be used to enter data in a cell
  15. Which of the following is the latest version of Excel
  16. What is represented by the small, black square in the lower-right corner of an active cell or range?
  17. Excel files have a default extension of
  18. How do you wrap the text in a cell?
  19. The Name box on to the left of formula bar
  20. In Excel, a Data Series is defined as what?
  21. You can convert existing excel worksheet data an charts to an HTML document by using
  22. Which symbol must all formula begin with?
  23. An Excel Workbook is a collection of .......
  24. The auto calculate feature
  25. Hyperlinks can be
  26. The Paste Special command lets you copy and paste:
  27. Long text can be broken down into many lines within a cell. You can do this through
  28. Which of the following is an absolute cell reference?
  29. You can set Page Border in Excel from
  30. Excel worksheet cells work very similarly to what common element of the windows graphical user interface