Microsoft Excel Quiz

1. Files created with Lotus 1-2-3 have an extension

2. Comments can be added to cells using

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

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

5. What is the address of the cell in the seventh column of the sixth row in an MS-Excel worksheet?

6. To delete an embedded objects, first

7. A data map is helpful

8. Tab scrolling button

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

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

11. Which of the not correct method of editing the cell content

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

13. Which of the following describes how to select all the cells in a single column?

14. Data marker on a chart are linked to data points in a worksheet, therefore,

15. To save a workbook, you:

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

17. When the formula bar is activated, you can see

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

19. The auto calculate feature

20. Which of the following is an absolute cell reference in MS Excel?

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

22. Data can be arranged in a worksheet in a easy to understand manner using

23. You can open the consolidate dialog box by choosing Consolidate from the ….. Menu.

24. Getting data from a cell in another sheet is called ______

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

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

27. How can you show or hide the gridlines in Excel Worksheet?

28. Statistical calculations and preparation of tables and graphs can be done using

29. Excel uniquely identifies cells within a worksheet with a cell name

30. Comments put in cells are called

31. What is the best way to reference cell A10 on sheet 3 from sheet 1?

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

33. The shortcut key Ctrl + R is used in Excel to

34. Which of following is Not one of Excel’s what-if function?

35. You can use the format painter multiple times before you turn it off by

36. Where can you set the shading color for a range of cells in Excel?

37. What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20.

38. Which would you choose to create a bar diagram?

39. Which of the following is not an example of a value?

40. The auto calculate feature

41. Excel displays the current cell address in ______

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

43. What function displays row data in a column or column data in a row?

44. Concatenation of text can be done using

45. An Excel workbook is a collection of ______

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

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

48. Shortcut key for line break is

49. The keyboard shortcut for creating a chart from selected cells in excel is

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