Microsoft Excel Quiz

1. What is the intersection of a column and a row on a worksheet called ?

2. when you print preview a worksheet

3. when you work with large worksheets, you may need to

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

5. A data map is helpful

6. Which of the following identifies a cell in Excel?

7. What type of chart is useful for showing trends or changes over time ?

8. Which of the following is not a valid data type in Excel?

9. What happens when the dollar sign ($) is entered in a cell address? (ex. $B$2:$B$10)

10. You want to track the progress of the stock market on daily basis. Which type of chart should you use?

11. Which of the cell pointer indicate that you can move the content to other cell?

12. The Chart wizard term data categories refers to;

13. Comments can be added to cells using ______

14. Long text can be broken down into many lines within a cell. You can do this through

15. Which of the following shortcuts can be used to insert a new line in the same cell?

16. You can add an image to a template by clicking the Insert Picture From File button on the ............. Toolbar.

17. What does the VLOOKUP function do?

18. Which field in Excel is used to enter values and formulas?

19. You can enter which types of data into worksheet cells?

20. Getting data from a cell located in a different sheet is called

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

22. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

23. The view that puts a blue line around each page that would be printed is the

24. We can save and protect the workbook by ________

25. The default header for a worksheet is

26. To view a cell comment

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

28. You can use the horizontal and vertical scroll bars to

29. Which one would you choose to create a bar chart?

30. The autofill feature

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

32. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

33. To save a workbook, you:

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

35. How do you change column width to fit the contents?

36. What is the extension of saved file in MS Excel?

37. Which of the following formulas is not entered correctly?

38. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

39. What term refers to a specific set of values saved with the workbook?

40. What setting do you need to change to print a spreadsheet with the header?

41. To edit data in an embedded Excel worksheet object in a Word document

42. To select an entire column in MS-EXCEL, you click on ________?

43. In a formula, which symbol specifies the fixed columns or rows?

44. Which functionin Excel tells how many numeric entries are there ?

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

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

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

48. How can you remove borders applied in cells?

49. Which of the following format you can decide to apply or not in AutoFormat dialog box?

50. The chart wizard term data series refers to