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

You can do it
  1. In the formula, which symbol specifies the fixed columns or rows?
  2. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  3. Which of the cell pointer indicates that you can fill series?
  4. How can you delete a record?
  5. The command Edit >> Fill Across Worksheet is active only when
  6. Which Chart can be created in Excel?
  7. Each excel file is called a workbook because
  8. Which of the following formulas will Excel Not be able to calculate?
  9. Which of the following series type is not valid for Fill Series dialog box?
  10. Which of the following is the oldest spreadsheet package?
  11. An Excel Workbook is a collection of .......
  12. A numeric value can be treated as a label value if it precedes with
  13. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  14. Which of the following methods cannot be used to enter data in a cell
  15. Which menu option can be sued to split windows into two
  16. How can you find specific information in a list?
  17. Which of the following is an absolute cell reference?
  18. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  19. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  20. Long text can be broken down into many lines within a cell. You can do this through
  21. Documentation should include
  22. Which of the cell pointer indicates you that you can make selection?
  23. Data can be arranged in a worksheet in a easy to understand manner using
  24. Which elements of worksheet can be protected from accidental modification
  25. It is acceptable to let long text flow into adjacent cells on a worksheet when
  26. When a range is selected, how can you activate the previous cell?
  27. Which of the following is not a way to complete a cell entry?
  28. Which of the following is not information you can specify using the solver?
  29. How do you display current date and time in MS Excel?
  30. Which of the following is not true regarding Conditional Formatting?