Microsoft Excel Quiz

1. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

2. How do you wrap the text in a cell?

3. How can you view two workbooks simultaneously to compare sales figures?

4. The ____ feature of MS Excel quickly completes a series of data

5. An Excel workbook is a collection of ______

6. You can check the conditions against __________ when applying conditional formatting

7. The “Spelling” dialog box can be accessed by choosing “Spelling” from the ________.

8. In MS Excel, Page border option is available under _______ tab.

9. The cell reference M$4 is a..........

10. Which command is used to edit the cell content

11. Which of the following Excel charts represents only one value for each variable?

12. When you open a new Excel workbook 2013, how many worksheets are there by default at the time of opening?

13. To delete an embedded objects, first

14. Which of the following methods can not be used to edit the contents of a cell?

15. What is the maximum height of a row in MS Excel 2010?

16. Comments put in cells are called

17. To remove the content of selected cells you must issue ______ command

18. Multiple calculations can be made in a single formula using ________

19. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.

20. Which of the following is used to move an active cell to the first column on the current row?

21. Formatting a cell in currency, you can specify

22. What tabs show up at the bottom of each workbook?

23. When a range is selected, how can you activate the previous cell?

24. The command Edit > Fill Across Worksheet is active only when

25. _____ are equations that perform calculations on values in your worksheet.

26. In MS-Excel which function enters today's data in a cell?

27. Which of the following is not information you can specify using the solver?

28. Excel probably considers the cell entry January 1, 2000 to be a

29. Tab scrolling button

30. To drag a selected range of data to another worksheet in the same workbook, use the

31. Concatenation of text in MS Excel can be done using

32. You can open the scenario Manager dialog box by choosing scenarios from the .......... menu.

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

34. Select correct statement

35. Which of the cell pointer indicates you that you can make selection?

36. Which is used to perform what if analysis?

37. In a worksheet you can press Shift+ Space to select entire

38. Which of the following action removes a sheet from workbook?

39. What does COUNTA () function do?

40. A circular reference is

41. Which one is not a Function in MS Excel ?

42. Another name for a pre-programmed formula in Excel is

43. While Finding and Replacing some data in Excel, which of the following statement is valid?

44. Which sentence is false for Microsoft Excel 2010?

45. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?

46. A function inside another function is called….

47. What is the short cut key to highlight the entire column?

48. ......... appear at the bottom of the Excel window.

49. Comments can be added to cells using ______

50. Gridlines