Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

Related Questions

  1. It is acceptable to let long text flow into adjacent cells on a worksheet when
  2. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  3. The short cut key Ctrl + R is used in Excel to
  4. How can you delete a record?
  5. Which area in an Excel window allows entering values and formulas?
  6. Comments can be added to cells using ......
  7. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  8. To copy formatting from one area in a worksheet and apply it to another area you would use:
  9. Which would you choose to create a bar diagram?
  10. Which function is not available in the Consolidate dialog box?
  11. What is represented by the small, black square in the lower-right corner of an active cell or range?
  12. Which of the following you can paste selectively using Paste Special command?
  13. Which of the cell pointer indicates that you can fill series?
  14. B7:B9 indicates:
  15. Which of the following is invalid statement?
  16. Comments put in cells are called
  17. To create a formula, you first:
  18. When you insert an excel file into a word document. The data are
  19. Status indicators are located on the
  20. Hyperlinks can be
  21. Right clicking something in Excel:
  22. Which elements of a worksheet can be protected from accidental modification?
  23. Which is used to perform what if analysis?
  24. Which of the following formulas is not entered correctly?
  25. Which tool you will use to join some cells and place the content at the middle of joined cell?
  26. The active cell:
  27. How can you show or hide the gridlines in Excel Worksheet?
  28. You can use the formula pallette to
  29. Which of the following option is not available in Paste Special dialog box?
  30. How do you display current date only in MS Excel?

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