Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. Which of the following is an absolute cell reference?
  2. To create a formula, you can use:
  3. Concatenation of text can be done using
  4. Which of the following options is not located in the Page Setup dialog box?
  5. Which of the following is not true regarding Conditional Formatting?
  6. Which key do you press to check spelling?
  7. Rounding errors can occur
  8. You can convert existing excel worksheet data an charts to an HTML document by using
  9. The command Edit >> Fill Across Worksheet is active only when
  10. Which of the following is not information you can specify using the solver?
  11. Status indicators are located on the
  12. When integrating word and excel, word is usually the
  13. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  14. A numeric value can be treated as a label value if it precedes with
  15. Which of the following is not a basic step in creating a worksheet?
  16. Hyperlinks can be
  17. Which command will you choose to convert a column of data into row?
  18. How can you delete a record?
  19. When you insert an excel file into a word document. The data are
  20. A __________ is a grid with labeled columns and rows.
  21. How can you print three copies of a workbook?
  22. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  23. Which of the following is not a way to complete a cell entry?
  24. In Excel, a Data Series is defined as what?
  25. Which of following is Not one of Excels what-if function?
  26. Which of the following methods cannot be used to enter data in a cell
  27. Tab scrolling button
  28. When you link data maintained in an excel workbook to a word document
  29. You can activate a cell by
  30. Comments put in cells are called .....