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. You can check the conditions against __________ when applying conditional formatting
  2. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  3. The Cancel and Enter buttons appear in the:
  4. Excel uniquely identifies cells within a worksheet with a cell name
  5. Which of the following options is not located in the Page Setup dialog box?
  6. MS Excel provides the default value for step in Fill Series dialog box
  7. What is the short cut key to replace a data with another in sheet?
  8. How many worksheets can a workbook have?
  9. Which setting you must modify to print a worksheet using letterhead?
  10. While Finding and Replacing some data in Excel, which of the following statement is valid?
  11. What do you mean by a Workspace?
  12. When you link data maintained in an excel workbook to a word document
  13. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  14. Which of the following is an absolute cell reference?
  15. Comments can be added to cells using ......
  16. MS-EXCEL is based on .........?
  17. Multiple calculations can be made in a single formula using
  18. How do you display current date only in MS Excel?
  19. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  20. How can you remove borders applied in cells?ACC
  21. Which of the following you can paste selectively using Paste Special command?
  22. How do you wrap the text in a cell?
  23. The name box
  24. Multiple calculations can be made in a single formula using .......
  25. Tab scroll buttons are place on Excel screen
  26. The short cut key Ctrl + R is used in Excel to
  27. Which of the following option is not available in Paste Special dialog box?
  28. To center worksheet titles across a range of cells, you must
  29. Which button do you click to add up a series of numbers?
  30. Which of the following is not true regarding Conditional Formatting?