Quiznetik

Microsoft Excel (MS Excel) | Set 3

1. An excel workbook is a collection of

Correct : D. Worksheets and charts

2. Excel files have a default extension of

Correct : A. Xls

3. In Excel one can use the format painter multiple times before one turn it off by

Correct : B. Double clicking the format painter button

4. In Excel Status indicators are located on the

Correct : C. Formula bar

5. In Excel you can open the scenario Manager dialog box by choosing scenarios from the ….. menu.

Correct : D. Tools

6. In Excel you can open the Sort dialog box by choosing Sort from the ….. menu

Correct : D. Data

7. In Excel to edit in an embedded excel worksheet object in a word document

Correct : A. Use the excel menu bar and toolbars inside the word application

8. In Excel to create a formula, you can use

Correct : D. Value and cell references

9. In Excel when working in the page break preview, you can

Correct : D. All of above

10. In Excel A data map is helpful

Correct : B. To show a geographic distribution of data 8

11. In Excel Rounding errors can occur

Correct : A. When you use multiplication, division or exponentiation in a formula

12. In Excel you can copy data or formulas

Correct : D. All of the above

13. In Excel Hyperlinks can be

Correct : D. All of above

14. In Excel to activate the previous cell in a pre- selected range, press

Correct : D. None of the above

15. In Excel when the formula bar is active, you can see

Correct : D. All of the above

16. To copy formatting from one area in a worksheet and apply it to another area you would use

Correct : D. The Format Painter button on the standard toolbar

17. In Excel In a worksheet you can select

Correct : B. Rows

18. When you link data maintained in an excel workbook to a word document

Correct : B. The word document contains a reference to the original source application

19. Which area in an excel window allows entering values and formulas ?

Correct : C. Formula bar

20. Which of the following methods can not be used to enter data in a cell

Correct : C. Pressing the Esc key

21. Which of the following will not cut information?

Correct : A. Pressing Ctrl + C

22. Which of the following is not a way to complete a cell entry?

Correct : D. Pressing spacebar

23. You can activate a cell by

Correct : D. All of the above

24. Text formulas:

Correct : C. Concatenate and manipulate text

25. How do you insert a row?

Correct : A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

26. Which of the following is not a basic step in creating a worksheet?

Correct : D. Copy the worksheet

27. How do you select an entire column?

Correct : B. Click the column heading letter

28. How can you print three copies of a workbook?

Correct : B. Select File >Print from the menu and type 3 in the Number of copies text box.

29. To create a formula, you first:

Correct : A. Select the cell you want to place the formula into

30. To center worksheet titles across a range of cells, you must

Correct : A. Select the cells containing the title text plus the range over which the title text is to be centered

31. How do you delete a column?

Correct : D. Right click the column heading you want to delet and select delete from the shortcut menu

32. How can you find specific information in a list?

Correct : D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

33. When integrating word and excel, word is usually the

Correct : D. Both b and c

34. When a label is too long to fit within a worksheet cell, you typically must

Correct : B. Increase the column width

35. The name box

Correct : B. Appears to the left of the formula bar

36. Comments put in cells are called

Correct : B. Cell tip

37. Which is used to perform what if analysis?

Correct : D. All of above

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

Correct : B. View different rows and columns edit the contents of a cell

39. Multiple calculations can be made in a single formula using

Correct : B. array formula

40. Hyperlinks can be

Correct : D. All of above

41. To activate the previous cell in a pre-selected range, press

Correct : D. None of the above

42. Which button do yu click to add up a series of numbers?

Correct : A. The autosum button

43. When the formula bar is active, you can see

Correct : D. All of the above

44. To copy formatting from one area in a worksheet and apply it to another area you would use:

Correct : D. The Format Painter button on the standard toolbar

45. In a worksheet you can select

Correct : B. Rows

46. When you link data maintained in an excel workbook to a word document

Correct : B. The word document contains a reference to the original source application

47. Which area in an excel window allows entering values and formulas

Correct : C. Formula bar

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

Correct : B. Freeze panes command on the window menu

49. To edit in an embedded excel worksheet object in a word document

Correct : A. Use the excel menu bar and toolbars inside the word application

50. To create a formula, you can use:

Correct : D. Value and cell references

51. Status indicators are located on the

Correct : C. Formula bar

52. Which of the following is the oldest spreadsheet package?

Correct : A. VisiCalc

53. Rounding errors can occur

Correct : A. When you use multiplication, division, or exponentiation in a formula

54. You can copy data or formulas

Correct : D. All of the above

55. You can not link excel worksheet data to a word document

Correct : D. With the copy and paste buttons on the standard toolbar.

56. Which of the following is a popular DOS based spreadsheet package?

Correct : D. Lotus 1-2-3

57. An excel workbook is a collection of

Correct : D. Worksheets and charts

58. Excel files have a default extension of

Correct : A. Xls

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

Correct : B. Double clicking the format painter button

60. You can use the formula palette to

Correct : B. Create and edit formulas containing functions

61. You can convert existing excel worksheet data an charts to an HTML document by using

Correct : B. Internet assistant wizard

62. A circular reference is

Correct : C. A formula that either directly or indirectly depends on itself

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

Correct : D. Auto Outline

64. When you insert an excel file into a word document. The data are

Correct : B. Linked

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

Correct : A. Input cells

66. Each excel file is called a workbook because

Correct : C. It can contain many sheets including worksheets and chart sheets

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

Correct : B. Value

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

Correct : A. Labels, values, and formulas

69. All worksheet formula

Correct : C. Return a formula result

70. Which of the following is a correct order of precedence in formula calculation?

Correct : D. All of above

71. The Paste Special command lets you copy and paste:

Correct : D. The resulting values of a formula instead of the actual formula

72. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

Correct : C. Click the Currency Style button on the formatting toolbar

73. Which of the following is not a valid data type in excel

Correct : B. Character

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

Correct : C. Text boxes

75. Which of the following options is not located in the Page Setup dialog box?

Correct : A. Page Break Preview.

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

Correct : C. Line chart

77. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Correct : A. Press Ctrl +Home

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

Correct : A. Press the Alt key

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

Correct : B. Press Esc

80. to view a cell comment

Correct : C. position the mouse pointer over the cell

81. When you want to insert a blank imbedded excel object in a word document you can

Correct : A. Click the object command on the insert menu

82. To save a workbook, you:

Correct : A. Click the save button on the standard toolbar from the menu

83. You can edit a cell by

Correct : B. Double clicking the cell to edit it in-place

84. You can select a single range of cells by

Correct : D. Dragging over the desired cells

85. Which elements of worksheet can be protected from accidental modification

Correct : D. All of above

86. You can use the drag and drop method to

Correct : D. a and b

87. It is acceptable ot let long text flow into adjacent cells on a worksheet when

Correct : B. No data will be entered in the adjacent cells

88. How can you delete a record?

Correct : B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

89. Right clicking something in Excel:

Correct : C. Opens a shortcut menu listing everything you can do to the object

90. Documentation should include

Correct : D. All of the above

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

Correct : C. 123

92. To delete an embedded objects, first

Correct : D. Select it and then press the delete key

93. Comments can be added to cells using

Correct : B. Insert > Comments

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

Correct : C. Description

95. To copy cell contents using drag and drop press the

Correct : C. Ctrl key

96. Which of the following is the latest version of Excel

Correct : D. Excel XP

97. When you copy a formula

Correct : B. Excel edits cell references in the newly copied formula

98. The autofill feature

Correct : D. none of the above

99. Which menu option can be sued to split windows into two

Correct : C. Window > split

100. Which of the following is an absolute cell reference?

Correct : B. $A$1