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 is invalid statement?
  2. Which of the following series type is not valid for Fill Series dialog box?
  3. When you copy a formula
  4. What does COUNTA () function do?
  5. Which menu option can be used to split windows into two?
  6. Text formulas:
  7. Which of following is Not one of Excels what-if function?
  8. Multiple calculations can be made in a single formula using
  9. What are the tabs that appear at the bottom of each workbook called?
  10. You can edit a cell by
  11. Tab scrolling button
  12. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  13. Excel displays the current cell address in the ........
  14. You can copy data or formulas
  15. To create a formula, you can use:
  16. The spelling dialog box can be involved by choosing spelling from ________ menu.
  17. Which tool you will use to join some cells and place the content at the middle of joined cell?
  18. Which of the following is not the correct method of editing the cell content?
  19. How can you delete a record?
  20. Which of the following is not true regarding Conditional Formatting?
  21. How do you wrap the text in a cell?
  22. A typical worksheet has . Number of columns
  23. How do you select an entire column?
  24. To copy formatting from one area in a worksheet and apply it to another area you would use:
  25. It is acceptable to let long text flow into adjacent cells on a worksheet when
  26. Which Chart can be created in Excel?
  27. Which button do you click to add up a series of numbers?
  28. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  29. The short cut key Ctrl + R is used in Excel to
  30. The command Edit >> Fill Across Worksheet is active only when