Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  2. How can you remove borders applied in cells?ACC
  3. When you link data maintained in an excel workbook to a word document
  4. Rounding errors can occur
  5. The auto calculate feature
  6. To save a workbook, you:
  7. Each excel file is called a workbook because
  8. Multiple calculations can be made in a single formula using
  9. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  10. What symbol is used before a number to make it a label?
  11. The Cancel and Enter buttons appear in the:
  12. Hyperlinks can be
  13. How do you wrap the text in a cell?
  14. Long text can be broken down into many lines within a cell. You can do this through
  15. Which of the following methods can not be used to edit the contents of a cell?
  16. While Finding and Replacing some data in Excel, which of the following statement is valid?
  17. Comments put in cells are called .....
  18. How do you rearrange the data in ascending or descending order?
  19. Which button do you click to add up a series of numbers?
  20. When a row of data is to be converted into columns
  21. Files created with Lotus 1-2-3 have an extension
  22. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  23. How do you display current date only in MS Excel?
  24. Which of the following is not an example of a value?
  25. Ctrl + D shortcut key in Excel will
  26. The name box
  27. How can you delete a record?
  28. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  29. What are the tabs that appear at the bottom of each workbook called?
  30. When a label is too long to fit within a worksheet cell, you typically must