Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. The Name box on to the left of formula bar
  2. You can auto fit the width of column by
  3. Which setting you must modify to print a worksheet using letterhead?
  4. How do you rearrange the data in ascending or descending order?
  5. Comments can be added to cells using
  6. To create a formula, you can use:
  7. The Chart wizard term data categories refers to;
  8. Which of the following is an absolute cell reference?
  9. Which key do you press to check spelling?
  10. To center worksheet titles across a range of cells, you must
  11. A circular reference is
  12. You can use the drag and drop method to
  13. Which of the following formulas is not entered correctly?
  14. When a range is selected, how can you activate the previous cell?
  15. You can use the formula pallette to
  16. Which symbol must all formula begin with?
  17. Which command will you choose to convert a column of data into row?
  18. You can use the formula palette to
  19. To create a formula, you first:
  20. The short cut key Ctrl + R is used in Excel to
  21. Which of the following Excel screen components can NOT be turned on or off?
  22. When a row of data is to be converted into columns
  23. Which of the following formulas will Excel Not be able to calculate?
  24. Which tool you will use to join some cells and place the content at the middle of joined cell?
  25. Which of the cell pointer indicate that you can move the content to other cell?
  26. The auto calculate feature
  27. You can activate a cell by
  28. The spelling dialog box can be involved by choosing spelling from ________ menu.
  29. Which of the following methods cannot be used to enter data in a cell
  30. Which elements of a worksheet can be protected from accidental modification?