Home

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. You cannot link excel worksheet data to a word document
  2. How can you print three copies of a workbook?
  3. How do you display current date only in MS Excel?
  4. In Excel, a Data Series is defined as what?
  5. To activate the previous cell in a pre-selected range, press
  6. Which of the following methods can not be used to edit the contents of a cell?
  7. A circular reference is
  8. You can use the drag and drop method to
  9. Which is used to perform what if analysis?
  10. Which of the following is a correct order of precedence in formula calculation?
  11. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  12. Excel displays the current cell address in the ........
  13. To save a workbook, you:
  14. The Chart wizard term data categories refers to;
  15. Multiple calculations can be made in a single formula using
  16. To select an entire column in MS-EXCEL, press?
  17. You can convert existing excel worksheet data an charts to an HTML document by using
  18. Which of the following is not a term of MS-Excel?
  19. A worksheet range is a
  20. The chart wizard term data series refers to
  21. The name box
  22. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  23. Documentation should include
  24. What is the short cut key to replace a data with another in sheet?
  25. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  26. How can you remove borders applied in cells?ACC
  27. Which area in an Excel window allows entering values and formulas?
  28. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  29. What symbol is used before a number to make it a label?
  30. Concatenation of text can be done using