1. In Excel 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.
2. In Excel to create a formula, you first
Correct : A. Select the cell you want to place the formula into
3. In Excel 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
4. In Excel how do you delete a column?
Correct : D. Right click the column heading you want to delet and select delete from the shortcut menu
5. In Excel 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
6. In Excel when integrating word and excel, word is usually the
Correct : D. Both (A) and (C)
7. In Excel when a label is too long to fit within a worksheet cell, you typically must
Correct : B. Increase the column width
8. In Excel name box
Correct : B. Appears to the left of the formula bar
9. In Excel Comments put in cells are called
Correct : B. Cell tip
10. In Excel which is used to perform what if analysis?
Correct : D. All of above
11. In Excel you can use the horizontal and vertical scroll bars to
Correct : B. View different rows and columns edit the contents of a cell
12. In Excel Multiple calculations can be made in a single formula using
Correct : B. array formula
13. In Excel To select several cells or ranges that are not touching each other, you would
… while selecting
Correct : A. hold down the Ctrl key
14. In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button
Correct : D. only the cells with white background will print
15. In Excel constant is another name for this type of data
Correct : A. number
16. In Excel the view that puts a blue a blue line around each page that would be printed is the
Correct : C. Page Break Preview
17. In Excel AutoCalculate will quickly add selected cells if you
Correct : B. click the AutoCalculate button on the toolbar
18. In Excel the cell labeled F5 refers to
Correct : B. column F row 5
19. In Excel when you are typing an equation into a cell the first thing that must be entered is
Correct : D. an equal sign
20. In Excel using the AutoSum button will replace in the selected cell
Correct : D. a formula which will add values in the range Excel guesses you want to add
21. In Excel Book1 is an example of how … are numbered and named during each work session
Correct : D. Name box
22. In Excel the following displays the contents of the active cell
Correct : B. Formula bar
23. In Excel Graphics objects on a chart are used to
Correct : D. All the above
24. In Excel to select a column the easiest method is to
Correct : C. Click the column heading
25. In Excel to select an individual data marker or data label, you must
Correct : D. Double click the marker or label
26. In Excel to delete and embedded object, first
Correct : D. Select it and then press Delete key
27. This type of software contains rows and columns.
Correct : B. Spreadsheet
28. In Excel to open an existing workbook, you can click the Open button on the …… toolbar.
Correct : D. Standard
29. In Excel you can activate a cell by
Correct : D. All of above
30. In Excel the following setup options cannot be set in the page setup dialog box?
Correct : A. Printer selection
31. In Excel term refers to a specific set of values saved with the workbook
Correct : B. Scenario
32. In Excel got functions? No? You need the insert function dialog box. How do you get it?
Correct : B. Click the insert menu and then click function
33. In Excel when you use the fill effects in the format data series dialog box, you cannot
Correct : A. Rotate text on the chart
34. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Correct : C. Speed
35. In Excel the following is not a basic step in
creating a worksheet
Correct : D. Copy the worksheet
36. In Excel what does SUMIF function do?
Correct : A. Adds up cell values based on a condition
37. In Excel you can insert labels for
Correct : D. All of the above
38. In Excel Tab scrolling buttons
Correct : D. Allow you to view additional sheet tabs
39. In Excel All macro keyboard shortcuts include the ….. key
Correct : A. Alt
40. In Excel to open the Format Cells dialog box, press
Correct : B. Ctrl + 1
41. In Excel you can add a hyperlink to your worksheet by pressing
Correct : C. Ctrl + K
42. In Excel to move to the previous worksheet, press
Correct : D. Shift + Tab
43. In Excel which of these will not select all the
cells in a document?
Correct : A. Clicking three times with the right mouse button in the spreadsheet
44. In Excel you can use the formula palette to
Correct : B. Create and edit formulas containing functions
45. In Excel you can convert existing excel worksheet data an charts to an HTML document by using
Correct : B. Internet assistant wizard
46. In Excel circular reference is
Correct : C. A formula that either directly or indirectly depends on itself
47. In Excel when you insert an excel file into a word document. The data are
Correct : B. Linked
48. In Excel the following is not information you can specify using the solver
Correct : A. Input cells
49. In Excel each excel file is called a workbook because
Correct : C. It can contain many sheets including worksheets and chart sheets
50. In Excel you can enter which types of data into worksheet cells?
Correct : A. Labels, values, and formulas
51. In Excel all worksheet formula
Correct : C. Return a formula result
52. In Excel which of the following is a correct order of precedence in formula calculation?
Correct : D. All of above
53. In Excel the Paste Special command lets you copy and paste
Correct : D. The resulting values of a formula instead of the actual formula
54. In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
Correct : C. Click the Currency Style button on the formatting toolbar
55. In Excel which of the following is not a valid data type in excel
Correct : B. Character
56. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Correct : C. Text boxes
57. In Excel which of the following options is not located in the Page Setup dialog box?
Correct : A. Page Break Preview.
58. In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?
Correct : C. Line chart
59. In Excel 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
60. Which of the following methods cannot be used to edit the contents of a cell In Excel?
Correct : A. Press the Alt key
61. In Excel 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
62. In Excel default style for new data keyed in a new workbook is
Correct : C. Normal
63. In Excel LEN function does what?
Correct : A. Compares the content in two cells
64. In Excel this function converts miles to kilometers, kilograms to pounds, and so on
Correct : A. Convert
65. In Excel you can use the drag and drop method to
Correct : A. Copy cell contents
66. In Excel to balance your checkbook, your best method is
Correct : C. Download the Checkbook register templates from Templates on Microsoft Office Online
67. In Excel which formula can add the all the
numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
Correct : C. Sum
68. In Excel to name a constant, you use the
…… dialog box
Correct : B. Define name
69. In Excel to cancel the marquee, press
Correct : C. Esc
70. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
Correct : B. SLN (straight line)
71. In Excel the following is not an underline option in the format cells dialog box
Correct : B. Single Engineering
72. In Excel to center worksheet titles across a range of cell, you must
Correct : A. Select the cells containing the title text and use the fill handle to center the text across a range of cells
73. In Excel when integrating Ms-Word and Excel,
Word is usually the
Correct : C. Client
74. In Excel Charts tips can
Correct : D. Both (B) and (C)
75. In Excel the Name box
Correct : B. Appears t the left of the formula bar
76. In Excel how do you change column width to
fit the contents?
Correct : B. Double click the boundary to the right of the column heading
77. In Excel when you work with large worksheets, you may need to
Correct : D. All of above
78. In Excel you can use the horizontal and vertical scroll bars to
Correct : B. View different rows and columns
79. 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.
Correct : A. Spreadsheet program
80. In Excel you can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Correct : D. Picture
81. In Excel to drag a selected range of data to another worksheet in the same workbook, use the
Correct : D. Ctrl key
82. In Excel when creating a vertical page break
Correct : C. The active cell must be in row 1
83. In Excel to activate the previous cell in a pre- selected range, press
Correct : D. None of above
84. In Excel when the formula bar is activated,
you can see
Correct : D. All of above
85. In a worksheet you can select
Correct : D. All of the above
86. When you print preview a worksheet
Correct : D. All of the above
87. In Excel to access the Go To Special feature, you can press
Correct : A. Ctrl + G
88. In Excel which do you press to enter the current date in a cell?
Correct : B. Ctrl + ;
89. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when
Correct : B. No data will be entered in the adjacent cells
90. In Excel you can group noncontiguous worksheets with
Correct : C. The ctrl key and mouse
91. In Excel Weight refers to
Correct : A. The print density of characters
92. When you link data maintained in Excel workbook to a Word document
Correct : B. The Word document contains a refe- rence to the original source application
93. In Excel when you see a cell with a red triangle in the top right corner, what does this signify?
Correct : B. There is a comment associated with the cell
94. In Excel to hold row and column titles in
places so that they do not scroll when you scroll a worksheet, click the
Correct : B. Freeze panes command on the window menu
95. In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Correct : C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
96. To edit data in an embedded Excel worksheet object in a Word document
Correct : A. Use the Excel menu bar and toolbars inside the word application
97. In Excel Status indicators are located on the
Correct : C. Formula bar
98. In Excel Rounding errors can occur
Correct : A. When you use multiplication, division, or exponentiation in a formula
99. In Excel one can copy data or formulas
Correct : D. All of the above
100. In Excel you cannot link excel worksheet data to a word document
Correct : D. With the copy and paste buttons on the standard toolbar