Home

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

You can do it
  1. Excel displays the current cell address in the ........
  2. You can use the formula pallette to
  3. Ctrl + D shortcut key in Excel will
  4. The autofill feature
  5. You can move a sheet from one workbook into new book by
  6. Edit >> Delete command
  7. Which of the following is not an example of a value?
  8. Multiple calculations can be made in a single formula using
  9. B7:B9 indicates:
  10. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  11. Which of the following is not a valid data type in excel
  12. How can you delete a record?
  13. Which of the following is not a worksheet design criterion?
  14. A worksheet can have a maximum of . Number of rows
  15. Which of the cell pointer indicates you that you can make selection?
  16. When you insert an excel file into a word document. The data are
  17. How many worksheets can a workbook have?
  18. Which of the following is not true regarding Conditional Formatting?
  19. While Finding and Replacing some data in Excel, which of the following statement is valid?
  20. Which key do you press to check spelling?
  21. Which of the following is a popular DOS based spreadsheet package?
  22. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  23. A numeric value can be treated as label value if ...... precedes it.
  24. What are the tabs that appear at the bottom of each workbook called?
  25. Which of the following option is not available in Paste Special dialog box?
  26. Which function is not available in the Consolidate dialog box?
  27. How do you display current date and time in MS Excel?
  28. Comments can be added to cells using ......
  29. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  30. Which of the cell pointer indicates that you can fill series?