Home

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. Text formulas:
  2. Which function is not available in the Consolidate dialog box?
  3. How do you display current date and time in MS Excel?
  4. Which area in an Excel window allows entering values and formulas?
  5. Which of the following is invalid statement?
  6. A numeric value can be treated as label value if ...... precedes it.
  7. Which menu option can be sued to split windows into two
  8. You can edit a cell by
  9. An Excel Workbook is a collection of .......
  10. Which menu option can be used to split windows into two?
  11. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  12. You can use the formula pallette to
  13. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  14. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  15. Data can be arranged in a worksheet in a easy to understand manner using
  16. Excel probably considers the cell entry January 1, 2000 to be a
  17. Which of the following formulas will Excel Not be able to calculate?
  18. Comments can be added to cells using
  19. When a row of data is to be converted into columns
  20. It is acceptable to let long text flow into adjacent cells on a worksheet when
  21. Which button do you click to add up a series of numbers?
  22. What is the short cut key to highlight the entire column?
  23. The active cell:
  24. The Cancel and Enter buttons appear in the:
  25. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  26. A __________ is a grid with labeled columns and rows.
  27. Right clicking something in Excel:
  28. To save a workbook, you:
  29. You can check the conditions against __________ when applying conditional formatting
  30. Which setting you must modify to print a worksheet using letterhead?