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

Also checkout these categories

Thermodynamics MCQ Transmission of Heat MCQ Order & Ranking MCQ Series MCQ Respiratory System MCQ Synonyms MCQ Engineering Materials MCQ Histology MCQ Fluid Mechanics MCQ Auto CAD 2D MCQ Fact MCQ Investment MCQ

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

Submit
Load More..
You can do it
  1. Which of the following is a popular DOS based spreadsheet package?
  2. To copy cell contents using drag and drop press the
  3. The command Edit >> Fill Across Worksheet is active only when
  4. Which symbol must all formula begin with?
  5. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  6. How many characters can be typed in a single cell in Excel?
  7. To select an entire column in MS-EXCEL, press?
  8. Comments can be added to cells using ......
  9. To activate the previous cell in a pre-selected range, press
  10. Which of the following is not a worksheet design criterion?
  11. Multiple calculations can be made in a single formula using .......
  12. Which command will you choose to convert a column of data into row?
  13. Which of the following series type is not valid for Fill Series dialog box?
  14. You can use the formula pallette to
  15. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  16. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  17. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  18. Which button do you click to add up a series of numbers?
  19. To center worksheet titles across a range of cells, you must
  20. The Name box on to the left of formula bar
  21. Which language is used to create macros in Excel?
  22. When you insert an excel file into a word document. The data are
  23. A worksheet range is a
  24. It is acceptable to let long text flow into adjacent cells on a worksheet when
  25. The Paste Special command lets you copy and paste:
  26. Tab scrolling button
  27. Which tool you will use to join some cells and place the content at the middle of joined cell?
  28. Which of the following is not the correct method of editing the cell content?
  29. You can move a sheet from one workbook into new book by
  30. A typical worksheet has …. Number of columns