Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. Excel files have a default extension of
  2. Getting data from a cell located in a different sheet is called ......
  3. How do you insert a row?
  4. You can edit a cell by
  5. Documentation should include
  6. Which tool you will use to join some cells and place the content at the middle of joined cell?
  7. A worksheet range is a
  8. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  9. A typical worksheet has . Number of columns
  10. Which of the following is not the correct method of editing the cell content?
  11. The Name box on to the left of formula bar
  12. Which of the following is a correct order of precedence in formula calculation?
  13. You can enter which types of data into worksheet cells?
  14. To activate the previous cell in a pre-selected range, press
  15. Which symbol must all formula begin with?
  16. Which function is not available in the Consolidate dialog box?
  17. To create a formula, you first:
  18. Multiple calculations can be made in a single formula using
  19. Comments can be added to cells using ......
  20. Concatenation of text can be done using
  21. Which of the following action removes a sheet from workbook?
  22. Which would you choose to create a bar diagram?
  23. Where can you change automatic or manual calculation mode in Excel?
  24. The spelling dialog box can be involved by choosing spelling from ________ menu.
  25. You can use the drag and drop method to
  26. The Paste Special command lets you copy and paste:
  27. An excel workbook is a collection of
  28. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  29. Which language is used to create macros in Excel?
  30. Which menu option can be used to split windows into two?