Home

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

You can do it
  1. Which of the following Excel screen components can NOT be turned on or off?
  2. Which of the following is not a valid data type in Excel?
  3. Which elements of a worksheet can be protected from accidental modification?
  4. The command Edit >> Fill Across Worksheet is active only when
  5. Which of the following is a correct order of precedence in formula calculation?
  6. Excel uniquely identifies cells within a worksheet with a cell name
  7. A numeric value can be treated as label value if ...... precedes it.
  8. How can you find specific information in a list?
  9. Multiple calculations can be made in a single formula using .......
  10. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  11. You cannot link excel worksheet data to a word document
  12. You can select a single range of cells by
  13. The active cell:
  14. Where can you change automatic or manual calculation mode in Excel?
  15. You can set Page Border in Excel from
  16. How many worksheets can a workbook have?
  17. Which of the following option is not available in Paste Special dialog box?
  18. You can activate a cell by
  19. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  20. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  21. It is acceptable to let long text flow into adjacent cells on a worksheet when
  22. MS Excel provides the default value for step in Fill Series dialog box
  23. Where can you set the shading color for a range of cells in Excel?
  24. Which of the following is invalid statement?
  25. What is the short cut key to replace a data with another in sheet?
  26. An Excel Workbook is a collection of .......
  27. Which language is used to create macros in Excel?
  28. Which of following is Not one of Excels what-if function?
  29. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  30. The auto calculate feature