Home

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. Multiple calculations can be made in a single formula using .......
  2. Edit >> Delete command
  3. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  4. Which symbol must all formula begin with?
  5. It is acceptable to let long text flow into adjacent cells on a worksheet when
  6. Concatenation of text can be done using
  7. You can move a sheet from one workbook into new book by
  8. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  9. Status indicators are located on the
  10. Which of the following is not a term of MS-Excel?
  11. Which of the following is the latest version of Excel
  12. Which of the following methods can not be used to edit the contents of a cell?
  13. Comments can be added to cells using ......
  14. To record a sequence of keystrokes and mouse actions to play back later we use:
  15. The chart wizard term data series refers to
  16. When you insert an excel file into a word document. The data are
  17. Which of the following is not the correct method of editing the cell content?
  18. Data can be arranged in a worksheet in a easy to understand manner using
  19. How can you delete a record?
  20. To delete an embedded objects, first
  21. Text formulas:
  22. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  23. The command Edit >> Fill Across Worksheet is active only when
  24. To center worksheet titles across a range of cells, you must
  25. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  26. Which of the cell pointer indicates that you can fill series?
  27. Which of the following is not a basic step in creating a worksheet?
  28. You can set Page Border in Excel from
  29. To copy formatting from one area in a worksheet and apply it to another area you would use:
  30. You can use the formula palette to