Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. The active cell:
  2. Where can you set the shading color for a range of cells in Excel?
  3. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  4. What are the tabs that appear at the bottom of each workbook called?
  5. To view a cell comment
  6. Text formulas:
  7. Which elements of worksheet can be protected from accidental modification
  8. You cannot link excel worksheet data to a word document
  9. You can use drag-and-drop to embed excel worksheet data in a word document
  10. Documentation should include
  11. Which of the following is not the correct method of editing the cell content?
  12. Which of the following formulas is not entered correctly?
  13. A worksheet can have a maximum of . Number of rows
  14. Which would you choose to create a bar diagram?
  15. You can move a sheet from one workbook into new book by
  16. You can use the formula pallette to
  17. Microsoft Excel is a powerful ...........
  18. A worksheet range is a
  19. Excel files have a default extension of
  20. An Excel Workbook is a collection of .......
  21. Data can be arranged in a worksheet in a easy to understand manner using
  22. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  23. A numeric value can be treated as label value if ...... precedes it.
  24. Right clicking something in Excel:
  25. When you want to insert a blank imbedded excel object in a word document you can
  26. Comments can be added to cells using ......
  27. The spelling dialog box can be involved by choosing spelling from ________ menu.
  28. Concatenation of text can be done using
  29. It is acceptable to let long text flow into adjacent cells on a worksheet when
  30. When you link data maintained in an excel workbook to a word document