Microsoft Excel Quiz

1. __________is NOT a Function in Microsoft Excel spreadsheets.

2. If 10/2 entered in a cell without applying any formats, excel will treat this as

3. The Name box on to the left of formula bar

4. MS Excel provides the default value for step in Fill Series dialog box

5. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

6. The Name box

7. You can merge the main document with data source in Excel. In mail merge operation, Word is usually

8. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

9. MS Excel file can NOT be directly exported as ______

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

11. Documentation should include

12. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.

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

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

15. A circular reference is

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

17. Select correct statement

18. Tab scroll buttons are place on Excel screen

19. The chart wizard term data series refers to

20. Status indicators are located on the

21. Which menu option can be used to split windows into two?

22. The Chart wizard term data categories refers to;

23. What type of chart is useful for comparing parts of a whole ?

24. In A3 cell edit = A1 + A2 refers to

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

26. The name box

27. You can use drag-and-drop to embed excel worksheet data in a word document

28. How many characters can be typed in a single cell in Excel?

29. Shortcut for Auto sum function in excel is

30. When you group worksheets

31. The Chart wizard term data categories refers to;

32. When integrating Ms-Word and Excel, Word is usually the

33. A circular reference is

34. The Chart wizard term data categories refers to;

35. Which of the following is not a worksheet design criterion?

36. Ctrl + D shortcut key in Excel will

37. Which of the following is not a valid function in MS Excel?

38. The active cell:

39. The autofill feature

40. Which setting you must modify to print a worksheet using letterhead?

41. When you insert an Excel file into a Word document, the data are

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

43. Which symbol must all formula begin with?

44. Each excel file is called a workbook because

45. A numeric value can be considered as a label value if it is preceded by _______.

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

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

48. The  default Row height MS excel worksheet is ............. point

49. An Excel Workbook is a collection of ________

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