Exam #3 Practice Test Instructor Jim Mollo
1. All of the
following are constants except:
a. 100
b. (201) 555-1212
c. =B3+C3
d. Pete Dunegan
2. How can you
determine if a workbook contains more than one worksheet?
a. Check the worksheet tabs at the bottom of the
window
b. Check the worksheet tabs at the top of the
window
c. Check the Taskbar
d. Pull down the View menu
3. How can you
tell which cell in a worksheet is the active cell?
a. It is blinking
b. It is displayed in reverse video
c. It is surrounded by a heavy border
d. All of the above
4. Which of the
following may be included in a formula?
a. Cell references
b. Functions
c. Numeric constants
d. All of the above
5. How can you
change the active cell?
a. Only by clicking in a different cell
b. Only by using the arrow keys to move to a
different cell
c. By clicking or by using the arrow keys
d. By using the Taskbar
6. Assume that cell
C4 contains a formula. Where would you see the formula displayed?
a. In cell C4
b. In the Formula bar
c. In the Name box
d. In the Status bar
7. Where is the
address of the active cell displayed?
a. In the Name box to the left of the formula
bar
b. In the Status bar at the bottom of the window
c. In the Title bar at the top of the window
d. All of the above
Page 2
8. Which Excel
screen element displays the Caps Lock indicator when it is on?
a. The Title bar
b. The Formula bar
c. The Status bar
d. The Name box
9. Which command
enables you to change the margins and/or orientation for a printed worksheet?
a. Options
b. Page Setup
c. View
d. Edit
10. Which of the
following commands will save the current workbook under a different name?
a. File New
b. Save
c. Save As
d. Open
11. Which of the
following commands will save the current workbook so that it is readable in
both Excel 2000 and Excel 97?
a. File New
b. Save
c. Save As and change file type to Excel 97
d. Open
12. Which of the
following pull-down menus is used to print an Excel workbook?
a. File
b. Edit
c. Tools
d. Window
13. Which part of
the formula =B9/4+(C6*D7) is considered a constant?
a. B9
b. 4
c. C6
d. D7
14. Which of the following
is a false statement about workbooks and worksheets?
a. A workbook contains one or more worksheets
b. The Open command references a worksheet
rather than a workbook
c. The title bar displays the name of the open
workbook
d. The same cell reference can be used for every
worksheet within a workbook
Page 3
15. How do you
display a context-sensitive menu?
a. By clicking the Context-sensitive Menu button
on the Standard toolbar
b. By clicking the Context-sensitive Menu button
on the Formatting toolbar
c. By double-clicking in the worksheet where you
want to see the context-sensitive menu
d. By clicking the right mouse button on the
part of the worksheet for which you want to see a context-sensitive menu
16. What happens if
you point to a cell and click the right mouse button?
a. The cell contents are erased
b. The entire row is erased
c. A context-sensitive menu pertaining to the
cell is displayed
d. The TipWizard tip that relates to the current
operation is displayed
17. What is the
character limit on Excel filenames?
a. 8 characters
b. 16 characters
c. 25 characters
d. 255 characters
18. What happens if
you double click the border between columns C and D?
a. Column C is hidden
b. Column D is hidden
c. The width of column C is changed to
accommodate the widest entry in that column
d. The width of column D is changed to
accommodate the widest entry in that column
19. In the formula
=C10-D10*(B3+B4)+2/B7, which expression would Excel evaluate first?
a. C10-D10
b. B3+B4
c. 2/B7
d. It is not possible to determine without
knowing the contents of the referenced cells
20. Excel cell
references refer to the row by letter and the column by number.
a. True
b. False
21. An Excel
workbook may be opened using either the File menu or an icon on the Standard
toolbar.
a. True
b. False
Page 4
22. Which command
will erase the contents of cell B10 without changing cell references throughout
the rest of the worksheet?
a. Edit Clear
b. Edit Delete
c. Both Edit Clear and Edit Delete
d. Neither Edit Clear nor Edit Delete
23. Which of the
following actions will display the cell formulas in a worksheet?
a. Double click the border between any two
columns
b. Select Unhide from the shortcut menu
c. Pull down the View menu and select Formulas
d. None of the above
24. Which of the
following are valid mathematical symbols in Excel?
a. *
b. ^
c. /
d. All of the above
25. Cell formulas
are usually displayed in the cell, while the contents are displayed in the Name
box.
a. True
b. False
26. If you use the
Save As command to rename a worksheet, all subsequent editing will affect the
original worksheet.
a. True
b. False
27. Which command deletes
cell B10 from a worksheet, which in turn changes cell references throughout the
rest of the worksheet?
a. Edit Clear
b. Edit Delete
c. Both Edit Clear and Edit Delete
d. Neither Edit Clear nor Edit Delete
28. A cell at the
intersection of the first row and third column has the cell reference:
a. A3
b. 3A
c. C1
d. 1C
Page 5
29. Which of the
following is not a valid mathematical symbol in Excel?
a. *
b. /
c. #
d. ^
30. A cell formula will
not be adjusted if a row or column is inserted in a worksheet.
a. True
b. False
31. The value of a
constant is changed by clicking in the cell containing the constant, entering a
new value, then pressing the enter key.
a. True
b. False
32. Which of the
following commands will remove a selected row or column from a worksheet?
a. Edit Clear
b. Edit Delete
c. Both Edit Clear and Edit Delete
d. Neither Edit Clear nor Edit Delete
33. The formula
=B3+C4 is stored in cell D5. How will the formula change if a row is inserted
above the second row in the worksheet?
a. =B3+C4
b. =B4+C5
c. =C3+D4
d. =B2+C3
34. In the formula
=D7/C4/B3*B2, which expression will Excel evaluate first?
a. D7/C4
b. C4/B3
c. B3*B2
d. Impossible to determine since no parentheses
are specified
35. A constant is
preceded by an equal sign.
a. True
b. False
36. The Undo
command will undo the effects of only the last three commands issued.
a. True
b. False
Page 6
37. Which of the following
is true regarding a printed worksheet?
a. It may be printed with or without the row and
column headings
b. It may be printed with or without the
gridlines
c. It may be printed in landscape or portrait
orientation
d. All of the above
38. The formula
=B3+C4 is stored in cell D5. How will the formula change if row two is deleted
from the worksheet?
a. =B2+C4
b. =B3+C3
c. =B3+C4
d. =B2+C3
39. In the formula
=B5*B6+C3/D4^2, which expression will Excel evaluate first?
a. B5*B6
b. B6+C3
c. C3/D4
d. D4^2
40. All Excel
formulas must be preceded by the equal sign (=).
a. True
b. False
41. Inserting a row
in an Excel worksheet will adjust the formulas using cell references.
a. True
b. False
42. Which of the following
commands will automatically adjust formulas in the affected cells?
a. Insert
b. Delete
c. Both Insert and Delete
d. Neither Insert nor Delete
43. When you move
your mouse over a button on a toolbar, a message will appear detailing what the
button will do when clicked. What is that message called?
a. A tip from the Office Assistant
b. A screen tip
c. The Tip Wizard
d. None of the above
Page 7
44. The cell
contents of B3 and B4 are 4 and 5 respectively. What will be the displayed value
in cell B5 if you enter B3+B4 in cell B5 and then press the enter key?
a. B3+B4
b. =B3+B4
c. 9
d. It is not possible to determine from the
information given
45. If cells B1,
B2, and B3 contain the values 2, 3, and 4, respectively, what value will be
displayed in a cell containing the formula =B3/B1+B2+1?
a. 6
b. 1.8
c. 0.6667
d. An error message; the formula is invalid
46. Excel functions
such as AVERAGE(B9:B12) do not need to be preceded by the equal sign.
a. True
b. False
47. The Page Setup
command allows you to scale a worksheet to print on one page.
a. True
b. False
48. Which of the
following options is controlled through the Page Setup command?
a. Margins
b. Orientation (portrait or landscape)
c. Headers and footers
d. All of the above
49. The purpose of
the Office Assistant is to:
a. Provide easy access to a button where you can
ask questions
b. Answer questions about tasks
c. Suggest tips for increasing your productivity
using Excel
d. All of the above
50. Which of the
following is a valid Excel formula?
a. =C4*D4
b. B4*D4
c. Both =C4*D4 and B4*D4
d. Neither =C4*D4 nor B4*D4
Page 8
51. If cells C1,
C2, and C3 contain the values 4, 2, and 5, respectively, what value will be displayed
in a cell containing the formula =C3-C1/C2^2*C3?
a. 20
b. 1.25
c. -5
d. None of the above
52. An Excel
worksheet may contain several workbooks.
a. True
b. False
53. The most
recently used workbook can be opened by clicking on a list at the bottom of the
File menu.
a. True
b. False
54. What happens if
you press the Ctrl+' key combination, given that the displayed values for each
cell are shown in the worksheet?
a. The worksheet formulas are displayed
b. A new column is inserted in the worksheet
c. A new row is inserted in the worksheet
d. A duplicate worksheet is created in the
workbook
55. Which command
in which menu enables you to display the row and column headings when printing
a worksheet?
a. View command in the Print menu
b. View command in the File menu
c. Page Setup command in the File menu
d. Page Setup command in the View menu
56. In Excel, a
function is:
a. A predefined computational task such as
averaging a group of cells
b. A command such as File Open
c. A mathematical operation such as =B6+B7
d. All of the above
57. A blinking
border shows the active cell.
a. True
b. False
58. If you want to
save an Excel 2000 worksheet to use in Excel 95 workbook, use the Save As command.
a. True
b. False
Page 9
59. Which of the
following worksheet options is controlled through the Page Setup command?
a. Centering the worksheet horizontally on the
page
b. Printing in landscape mode
c. Creating a header
d. All of the above
60. A worksheet
currently displays the cell contents rather than the displayed (computed)
values of each cell. Which keystroke combination will change the worksheet view
from displaying the cell contents to the displayed values?
a. Ctrl+'
b. Ctrl+F
c. Ctrl+DV
d. None of the above
61. You deleted a
row from the current worksheet three actions ago and realize you made a
mistake. You entered two formulas and would like to keep those formulas intact.
Which of the following actions should you take to correct your error?
a. Retrieve the row from the Recycle Bin
b. Click the Open button on the Standard toolbar
to open a fresh copy of the worksheet
c. Click the Undo button on the Standard toolbar
to restore the row
d. It is not possible to undo the row and not
change the formulas too.
62. The function
=AVERAGE(A6:A8) is the equivalent of the formula:
a. A6+A7+A8/3
b. =(A6+A7+A8/3)
c. =(A6+A7+A8)/3
d. =(A6+A8)/2
63. If you press the
Caps Lock key on the keyboard, an indicator will appear on the Status bar.
a. True
b. False
64. The Edit Clear
command does not adjust cell references.
a. True
b. False
65. Which of the
following is the easiest way to reopen a workbook from the previous session?
a. Select the workbook from the appropriate list
using the Open command
b. Pull down the File menu and select the file
from the list at the bottom of the menu
c. Click the Open button on the Standard toolbar
d. All of these methods open the workbook with
equal ease
Page 10
66. Which of the
following actions will increase the column width of column B to fit the widest
entry?
a. Click the border between columns A and B
b. Double click the border between columns A and
B
c. Click the border between columns B and C
d. Double click the border between columns B and
C
67. Which of the
following commands is available from the File menu?
a. Save
b. Print
c. Open
d. All of the above
68. Which of the
following will compute the average of cells B1 through B4?
a. (B1+B2+B3+B4)/4
b. =AVG(B1:B4)
c. AVERAGE(B1:B4)
d. None of the above
69. The tabs at the
bottom of an Excel window display the name(s) of the open workbook(s).
a. True
b. False
70. A column may be
inserted using a context-sensitive menu or a pull-down menu.
a. True
b. False
71. Which chart
type is the most appropriate to show percentages, such as how much of your
total budget you spend on entertainment?
a. A pie chart
b. A column chart
c. A stacked column chart
d. A line chart
72. Which of the
following types of pie charts can be used to create three-dimensional charts?
a. Non-exploded only
b. Exploded only
c. Both exploded and non-exploded
d. Neither exploded nor non-exploded
73. What is the
maximum recommended number of categories for a column or pie chart?
a. 3
b. 7
c. 15
d. 25
Page 11
74. Which of the
following statements about sizing and moving a chart is true?
a. A chart can be sized horizontally
b. A chart can be sized vertically
c. A chart can be moved to any location in the
worksheet
d. All of the above
75. All of the
following are places you can find the Chart Wizard in Excel 2000 except:
a. Click on more button on the toolbar
b. Separate the Standard and Formatting toolbars
and it will be on the Standard toolbar
c. Click on Tools and Chart Wizard
d. Click on Insert Chart and the Chart Wizard
will appear
76. Which of the
following can be modified after a chart is created using the Chart Wizard?
a. The chart type
b. The legend
c. The formatting of the title
d. All of the above
77. Which of the
following is true about an embedded chart?
a. It can be moved elsewhere in the worksheet
b. It can be made larger or smaller
c. It can be deleted
d. All of the above
78. What is the
easiest way to delete a chart from a worksheet?
a. Click on the data range from which the chart
was created, then click on Edit and drag to Delete Chart
b. Click on the chart, then press the Del key
c. Click on the chart, then press Ctrl+Del
d. Once a chart is created, it cannot be deleted
79. How do you
activate the context-sensitive menu for a selected item on a worksheet?
a. Press Ctrl+S
b. Point to the item, then click the right mouse
button
c. Double click the right border of the object
d. Click the Tools button on the Standard
toolbar
80. What happens
when you point to a cell and click the right mouse button?
a. A shortcut menu is displayed
b. The cell contents are deleted
c. The cell contents are displayed
d. The AutoFill command is executed
Page 12
81. Which of the
following would you recommend to show both the number of cars sold and the
revenues of six dealerships in the district?
a. Pie chart
b. Side-by-side column chart
c. Stacked column chart
d. Combination chart
82. An embedded
chart can be:
a. Moved
b. Copied
c. Sized
d. All of the above
83. What happens if
you select multiple data series in a worksheet and then press F11?
a. The cell formats are deleted
b. The Copy command is invoked
c. A default chart is created
d. The worksheet is recalculated
84. Which technique
would you use to include the same Excel chart in both a Word document and a
PowerPoint presentation?
a. Linking
b. Embedding
c. Compounding
d. Multitasking
85. A column chart
with multiple data series can always display the series side by side or in
stacked format with equally meaningful results.
a. True
b. False
86. A Word document
cannot contain both an Excel chart and the associated worksheet.
a. True
b. False
87. The clipboard
is not used to copy data between a worksheet and a word processing document
during object linking and embedding.
a. True
b. False
88. The title of a
chart must be entered as a text box using the Charting toolbar; it cannot be
entered using the Chart Wizard.
a. True
b. False
Page 13
89. Which of the
following is true?
a. A linked object must be stored in its own file
prior to including it in a compound document
b. An embedded object must be stored in its own
file prior to including it in a compound document
c. An object must be stored in its own file
regardless of whether it is linked or embedded
d. An object can not be stored in its own file
if it is to be linked or embedded in a compound document
90. If the data
series in a chart are in columns, the Excel Chart Wizard will:
a. Use the first row for the X axis labels
b. Use the first column for the legend text
c. Use the first row for the X axis labels and
the first column for the legend text
d. None of the above
91. Which of the
following is done using the Drawing toolbar?
a. Adding a text box
b. Changing the chart type
c. Adding gridlines to the chart
d. All of the above
92. A combination
chart is best when you need to show:
a. The proportions of more than one data series
b. Different scales for multiple data series
plotted against the same X axis
c. Both horizontal and vertical data
d. Data that contain both relative and absolute
cell references
93. Which of the
following chart types is the best to show the number of houses sold and the
dollar volume of sales for six real estate agents?
a. A pie chart
b. A side-by-side column chart
c. A combination chart
d. A line chart
94. Which of the
following cannot be done using the Chart Wizard?
a. Adding an arrow and text to the chart
b. Adding a chart title
c. Removing the legend
d. Changing the data series to columns
95. If the data series
in a chart are in rows, the Excel Chart Wizard will:
a. Use the first row for the X axis labels
b. Use the first column for the legend text
c. Use the first row for the X axis labels and
the first column for the legend text
d. None of the above
Page 14
96. The misuse of
charts is common occurrence. What kinds of information, cited in the text, can
be used to easily mislead the reader?
a. Chart type and chart labels
b. Chart labels and adding dissimilar quantities
c. Chart types and adding dissimilar quantities
d. All of the above can be used to mislead the
reader.
97. The location of
a toolbar cannot be changed.
a. True
b. False
98. Pressing
Alt+Tab allows the user to move between open applications.
a. True
b. False
99. Which of the
following is most appropriate to show the trend of revenues and sales growth
over a five-year period?
a. A line chart
b. A side-by-side column chart
c. A pie chart
d. A combination chart
100. Which of the
following chart types is available when using the Chart Wizard to create a
chart?
a. Pie
b. 3D column
c. Combination
d. All of the above
101. If the data
series in a chart are in columns, the Excel Chart Wizard will:
a. Use the first row for the X axis labels
b. Use the first column for the X axis labels
c. Use the first row for the Y axis labels
d. Use the first column for the legend text
102. What is the best
way to move between a floating toolbar and a docked toolbar?
a. Drag the border of the tool bar to the
position you want it on the worksheet
b. Toggle between floating and docked by
toolbars by double clicking on the background of the toolbar
c. Drag the toolbar background to the position
you want on the worksheet
d. Click on Tools menu, select Customize, and
check the Floating box next to the toolbar you want
103. A chart created
using the Chart Wizard cannot be modified.
a. True
b. False
Page 15
104. It is not
possible to edit an Excel worksheet that is embedded in a Word document.
a. True
b. False
105. Which of the
following is used to distinguish one data series from another?
a. The labels on the X axis
b. The legend
c. The key
d. The labels on the Y axis
106. Which of the
following cannot be used to move an embedded chart?
a. Click anywhere in the chart, then click and
drag the chart elsewhere in the worksheet
b. Double click anywhere in the chart, then
click and drag the chart elsewhere in the worksheet
c. Point to the chart, click the right mouse
button to select the chart, then click and drag the chart elsewhere in the
worksheet after it has been selected
d. Select the chart, execute the Cut command,
click elsewhere in the worksheet, then execute the Paste command
107. If the data series
in a chart are in rows, the Excel Chart Wizard will:
a. Use the first row for the X axis labels
b. Use the first row for the Y axis labels
c. Use the first row for the legend text
d. It is not possible to determine
108. Assume that
cells A1 through D5 have been selected, after which the Chart Wizard is used to
create a side-by-side column chart. How many data series will there be, given
that the data are to be plotted in rows?
a. Three
b. Four
c. Five
d. Impossible to determine
109. Pressing the Del
key after selecting an embedded chart erases the chart from the worksheet.
a. True
b. False
110. When creating a
linked object, both source and destination documents will be open.
a. True
b. False
Page 16
111. Which of the following
commands is included in the command sequence to embed a chart in a word
processing document if a dynamic link is required?
a. Copy
b. Paste Special
c. Paste Link
d. All of the above
112. The same
worksheet is the basis for an embedded pie chart, as well as a column chart in
its own chart sheet. Which chart will change if the data points in the
worksheet change?
a. Both the pie chart and the column chart
b. Only the pie chart
c. Only the column chart
d. Neither the pie chart nor the column chart
113. Which of the
following chart types emphasizes the totals for each category label on the X
axis?
a. Bar chart
b. Column chart
c. Stacked column chart
d. Line chart
114. Assume that cells
A1 through E5 have been selected, after which the Chart Wizard is used to
create a side-by-side column chart. Which of the following is true, given that
the data are to be plotted in columns?
a. The category names are in cells B1 through E1
b. The legends are in cells A2 through E5
c. There are five data series
d. None of the above
115. The size and/or
location of an embedded chart cannot be changed once the chart has been
created.
a. True
b. False
116. A chart may be copied
to another area of a workbook.
a. True
b. False
117. Which of the
following creates a dynamic link between an Excel worksheet and a word
processing memo?
a. Cut and Paste
b. Object Linking and Embedding (OLE)
c. Both Cut and Paste, and OLE
d. Neither Cut and Paste, nor OLE
Page 17
118. Which type of
chart is linked to the worksheet data on which it is based?
a. A chart that is embedded in the worksheet
b. A chart that is in its own chart sheet
c. Both the embedded chart and the one in its
own chart sheet
d. Neither the embedded chart nor the one in its
own chart sheet
119. Which of the
following will change if you switch from a side-by-side column chart to a
stacked column chart?
a. The labels on the X axis
b. The scale on the Y axis
c. Both the labels on the X axis and the scale
on the Y axis
d. Neither the labels on the X axis nor the
scale on the Y axis
120. Assume that
cells A1 through E5 have been selected, after which the Chart Wizard is used to
create a side-by-side column chart. Which of the following is true, given that
the data are to be plotted in rows?
a. The category names are in cells B1 through E1
b. The legends are in cells A2 through A5
c. There are four data series
d. All of the above
121. An embedded
chart is not updated if the worksheet is modified unless the Edit Update
command is used.
a. True
b. False
122. The chart type
may be changed using the Format menu, the Chart Wizard, or a shortcut menu.
a. True
b. False
123. If you specify
that data is to be charted in rows, Excel will use the first row for the legend
text.
a. True
b. False
124. If a chart is
kept in a separate chart sheet, it will not be updated when the data points in
the worksheet are updated.
a. True
b. False
125. Another approach
to multitasking in Windows 95/98 or Windows NT is to:
a. Use the Taskbar and click on the application
you want
b. Minimize one application so you can work on
another
c. Both using the Taskbar and Minimizing will
work
d. Neither the Taskbar or Minimizing will work
Page 18
126. Which of the
following will change if you switch from a side-by-side column chart to a
stacked column chart?
a. The height of the columns
b. The number of columns
c. The scale on the Y axis
d. All of the above
127. In which chart
type is the data graphed horizontally?
a. Bar chart
b. Column chart
c. Both a bar and a column chart
d. Stacked column chart
128. Assume you have
used Paste Link to create a compound document using an Excel worksheet in a
word processing document. Which of the following will change if the worksheet
is modified?
a. The chart in the worksheet, but not the chart
in the word processing document
b. The chart in the word processing document,
but not the chart in the worksheet
c. The chart in the worksheet and the chart in
the word processing document
d. Neither the chart in the worksheet, nor the
chart in the word processing document
129. Multiple data
series may be contained in either rows or columns.
a. True
b. False
130. You should limit
the number of categories in a pie chart to seven or fewer.
a. True
b. False
131. Which key
combination allows you to switch back and forth between open applications?
a. Alt+Tab
b. Ctrl+Tab
c. Shift+Tab
d. Alt+Ctrl+Tab
132. Which of the
following will allow you to draw an arrow in a chart at a perfect 45ø angle?
a. Press Ctrl while dragging the mouse to create
the arrow
b. Press Shift while dragging the mouse to
create the arrow
c. Press Alt while dragging the mouse to create
the arrow
d. This is not possible
Page 19
133. If you are
creating a column chart to show monthly sales in each of three cities, which
axis would contain the category labels (the city names)?
a. X axis
b. Y axis
c. Either X or Y axis
d. It is not possible to determine from the
information given
134. Which key will
create a default chart type in its own worksheet after you select the range?
a. F2
b. F4
c. F5
d. F11
135. Which of the following
chart types explicitly totals the data series in each category?
a. Side-by-side columns
b. Stacked columns
c. Both side-by-side and stacked columns
d. Neither side-by-side nor stacked columns
136. Which of the
following can be used to add emphasis to a pie chart?
a. Arrows and text
b. The chart title
c. An exploded slice
d. All of the above
137. You have created
a workbook that includes a revenue worksheet containing two embedded charts.
The workbook also includes one chart in its own worksheet. How many files does
it take to store this workbook?
a. 1
b. 2
c. 3
d. 4
138. The Drawing
Toolbar allows for enhanced 3D effects. Which of the following cannot be
converted to 3D by using the Drawing Toolbar?
a. AutoShapes
b. Styles
c. Chart type
d. Titles
139. A column chart
is the chart type best suited to display proportional data.
a. True
b. False
Page 20
140. A side-by-side
column chart and a stacked column chart of the same data will use the same
scale on the Y axis.
a. True
b. False
141. Which of the
following can be included in a PowerPoint presentation?
a. ClipArt
b. Text
c. WordArt
d. All of the above
142. What happens if,
while working on a presentation and after you have saved the presentation, you
pull down the File menu and click the Close command?
a. The current presentation is closed
b. All open PowerPoint presentations are closed
c. PowerPoint and all open presentations are
closed
d. Windows 98 and all open applications are
closed
143. What happens if
you click the New Slide button while editing slide 3 in Slide view?
a. A new slide with the default layout will be
inserted before slide 3
b. A new slide with the default layout will be
inserted after slide 3
c. You will be asked to select the slide layout
for a new slide which will be inserted before slide 3
d. You will be asked to select the slide layout
for a new slide which will be inserted after slide 3
144. Assume you are
in Outline view and have collapsed the outline so that only the titles are
visible. What happens if you click on the third slide and drag it to the end of
the presentation?
a. The slide title is moved, but the bulleted
items remain and are now included on slide two
b. The slide title remains, but the bulleted
items are moved to the end of the last slide
c. The entire slide, including title, bullets,
and graphics, is moved to the end of the presentation
d. This situation is not possible; it is not
possible to drag a slide in Outline view
145. Which of the
following presentation elements can be displayed with a build effect?
a. Bullets
b. Graphic images
c. Both bullets and graphic images
d. Neither bullets nor graphic images
146. Many of the buttons
on the Standard and Formatting toolbars in PowerPoint are the same as those in
Word and Excel.
a. True
b. False
Page 21
147. You cannot see
graphic elements in Slide Sorter view.
a. True
b. False
148. Which of the
following print options are available in PowerPoint?
a. One slide per page
b. Two or three slides per page
c. Six slides per page
d. All of the above
149. In which view
are you working if, while editing a presentation, you see only text, but no
graphics?
a. Notes Pages view
b. Outline view
c. Normal view
d. Slide Sorter view
150. Which PowerPoint
key combination indents text one level?
a. Tab
b. Ctrl+Tab
c. Shift+Tab
d. Alt+Tab
151. Which key
combination can be used to select all the slides in Outline view?
a. Ctrl+End
b. Ctrl+A
c. Alt+End
d. Alt+A
152. Which of the
following elements can have its color changed within a template?
a. The title text
b. The bullet text
c. The background
d. All of the above
153. When you click the
Save button, your PowerPoint presentation is saved to disk and removed from
memory.
a. True
b. False
154. Text you type in
the notes area in Notes Pages view will be displayed in Slide Show view.
a. True
b. False
Page 22
155. Which toolbar is
displayed by default in all views?
a. The Standard Toolbar
b. The Formatting Toolbar
c. Both (a) and (b)
d. Neither (a) nor (b)
156. In which view
are you working if you see Outline view, Slide view, and Notes Page view in a
single window?
a. Outline view
b. Slide Sorter view
c. Notes Pages view
d. Normal view
157. What happens
when you press the Tab key when starting to enter the text for a bullet?
a. The bullet will be indented one level to the
right
b. The bullet will be moved one level to the
left
c. The bullet symbol changes to the previously
used symbol
d. A new bullet is entered on the line below the
current line
158. Suppose you are
working in Outline view and press Ctrl+A. What happens?
a. The PowerPoint annotation tool is displayed
b. The mouse pointer returns to an arrow
c. The presentation is checked for spelling
d. All the slides in the presentation are
selected
159. Which of the
following is true?
a. Slides can be added to a presentation after a
template has been selected
b. The template can be changed after all of the
slides have been created
c. The template can be changed at any time when
you are editing your presentation
d. All of the above
160. PowerPoint file
names can contain both spaces and commas.
a. True
b. False
161. If you rearrange
the order of slides in Slide Sorter view, you will see the new slide order when
you look at the presentation in Outline view.
a. True
b. False
162. Where are the boldface,
italics, and underlining buttons?
a. On the Standard toolbar
b. On the Formatting toolbar
c. On the Menu bar
d. On the Status bar
Page 23
163. In which
PowerPoint view can you see the text of multiple slides at one time?
a. Outline view
b. Slide Sorter view
c. Normal view
d. All of the above
164. Which PowerPoint
key combination moves indented text back one level to the left?
a. Tab
b. Shift+Tab
c. Shift+Left Arrow
d. Ctrl+Left Arrow
165. Where will the insertion
point be after you complete the text for a bullet in the Outline view and press
the Enter key?
a. On the next bullet at the same level of
indentation
b. On the next bullet at a higher level of
indentation
c. On the next bullet at a lower level of
indentation
d. Impossible to determine
166. Which of the
following can be printed for a presentation?
a. The slides in miniature (up to six to a page)
b. The notes pages
c. The outline
d. All of the above
167. The Open command
is used to create a new PowerPoint presentation.
a. True
b. False
168. If you rearrange
the order of slides in the Outline view, you will not see the new slide order
when you view the presentation in Slide Show view.
a. True
b. False
169. Where do you
find the Open button (icon)?
a. On the Standard toolbar
b. On the Formatting toolbar
c. On the Status bar
d. On the Menu bar
170. In which view
can you rearrange the order of slides in a PowerPoint presentation?
a. Slide Sorter view
b. Outline view
c. Normal view
d. All of the above
Page 24
171. You are editing
a PowerPoint presentation and have entered the text for a bullet on the current
slide. What happens when you press the Enter key?
a. The insertion point moves to a new bullet
indented one level to the right
b. The insertion point moves to a new bullet
indented one level to the left
c. The insertion point moves to a new bullet at
the same indent level as the current bullet
d. It is not possible to determine
172. Which of the
following is true?
a. Shift + Tab promotes an item to the next
higher level
b. Shift + Tab demotes an item to the next lower
level
c. Tab promotes an item to the next higher level
d. All of the above are false
173. You are reviewing
a PowerPoint presentation in Slide Show view and notice that the bullets are
appearing from bottom to top. What is the most likely explanation for this?
a. The slide transition was incorrectly
specified
b. The reverse order build effect was selected
c. The order of the slide was changed using
Slide Sorter view
d. The slide master contains an error
174. The Save As
command can be used to create a copy of an existing PowerPoint presentation.
a. True
b. False
175. It is not
possible to delete a slide while in Slide Show view.
a. True
b. False
176. Which of the
following toolbars is available in PowerPoint?
a. The Standard toolbar
b. The Formatting toolbar
c. Both the Standard and the Formatting toolbars
d. Neither the Standard nor the Formatting
toolbar
177. Which PowerPoint
view allows you to create speaker's notes for display during the slide show?
a. Slide Sorter view
b. Outline view
c. Slide view
d. None of the above
Page 25
178. What is the
fastest way to replace existing text in a PowerPoint presentation?
a. Select the text, then type the new entry
while the text is still selected
b. Select the text, pull down the Edit menu,
press Delete, then type the new entry
c. Position the insertion point at the beginning
of the text to be deleted, press Ctrl+Delete to delete each word, then type the
new entry
d. Select the text, click the Cut button on the
Standard toolbar, then type the new entry
179. Which of the following
PowerPoint features changes the way slides move on and off the screen?
a. Transitions
b. Builds
c. Slide Navigator
d. All of the above
180. Using animation
effects, you can:
a. Build the slide a bullet at a time
b. Build the bullets a letter at a time
c. Build the bullets a word at a time
d. All of the above
181. It is possible
to edit a slide in Slide view.
a. True
b. False
182. To add clip art
to a slide, you should single click the ClipArt placeholder.
a. True
b. False
183. Which PowerPoint
menu contains the Save, Open, and Print commands?
a. Edit
b. File
c. View
d. Insert
184. Which PowerPoint
view is best for viewing multiple slides on the screen at one time?
a. Slide Show view
b. Slide view
c. Slide Sorter view
d. Notes Pages view
185. How can you
determine which slide is selected when you are in Slide Sorter View?
a. The current slide number is shown on the
status bar
b. The current slide is surrounded by a heavy
border
c. The current slide is surrounded by a blinking
marquee
d. The current slide number shows on the
Standard toolbar
Page 26
186. Which of the
following actions could you take to add a graphic element to a slide which
currently contains only text bullets?
a. Click the Graphic button on the Formatting
toolbar, then drag the crosshair to indicate the size and location of the
graphic
b. Click the Slide Layout button on the status
bar and select a layout with text and graphics
c. Switch to Slide Sorter view and drag a
graphic element from another slide to this slide
d. It is not possible to add a graphic to an
existing slide
187. In which view do
you see the animation effects for a slide?
a. Slide Show view
b. Outline view
c. Both Slide Show and Outline view
d. Neither Slide Show nor Outline view
188. You can set up a
PowerPoint slide show to advance automatically through the slides.
a. True
b. False
189. When you execute
the New Slide command, the slide will be added immediately before the current
slide.
a. True
b. False
190. Which of the
following is a valid file name for a PowerPoint presentation?
a. History 201 Presentation
b. PresHist201
c. Both History 201 Presentation and PresHist201
d. Neither History 201 Presentation nor
PresHist201
191. It is possible
to delete a slide while in any of the following views except:
a. Slide view
b. Slide Show view
c. Slide Sorter view
d. Normal view
192. Assume you are in
the middle of a PowerPoint slide show and want to add an annotation to the
current slide. Where can you find the annotation pen?
a. On the Standard toolbar
b. On the Formatting toolbar
c. On the shortcut menu
d. On the status bar
Page 27
193. You are in the
Slide Sorter view. How can you determine whether a slide includes a transition
effect?
a. The slide title appears in boldface
b. The slide title blinks
c. A special slide icon appears below the slide
d. You cannot determine in Slide Sorter that a
slide contains a transition effect
194. You are working
on a PowerPoint presentation and execute the command to apply a design
template. Which slide(s) does the command affect?
a. Only the current slide
b. All slides in the current presentation
c. All new presentations subsequently created in
this session
d. All existing presentations subsequently
opened in this session
195. Suppose you have
just advanced to the next slide while viewing a PowerPoint presentation in
Slide Show view. Pressing the Esc key will close the presentation, leaving you
with an empty PowerPoint window.
a. True
b. False
196. A template
determines the slide color scheme and the arrangement of the placeholders only.
a. True
b. False
197. You are working
on a PowerPoint presentation and execute the Save command for the first time.
Which of the following statements is true?
a. The presentation is saved to disk but is no
longer in memory
b. The presentation is closed
c. The presentation is saved to disk and remains
in memory
d. None of the above
198. Which view
enables you to use the Delete key to delete a slide?
a. Notes Pages view
b. Slide view
c. Slide Sorter view
d. All of the above
199. Which of the
following design specifications is preset in a PowerPoint template?
a. Color scheme
b. Arrangement of placeholders on each slide
c. Size of bulleted text
d. All of the above
Page 28
200. Where can you
find the Slide Transition command?
a. Slide Show menu
b. Slide Sorter toolbar
c. On both the Slide Show menu and the Slide
Sorter toolbar
d. On neither the Slide Show menu or Slide
Sorter toolbar
201. How do you
select a slide in Outline view?
a. Click the slide icon
b. Click the slide number
c. Click either the slide icon or the slide
number
d. It is not possible to select a slide in
Outline view
202. You can drag a
slide to a new location in Slide Sorter view.
a. True
b. False
203. Animation effects
can be applied to bulleted lists only, not to charts or ClipArt.
a. True
b. False
204. You open a
PowerPoint presentation called Sample Presentation. You pull down the
File menu, select Save As, and save the file with a new name, My First
Presentation. Which of the following statements is true?
a. The presentation is stored twice in memory,
and you can use the Window menu to toggle between the two files
b. The Sample Presentation is overwritten on
disk by My First Presentation
c. The Title bar at the top of the PowerPoint
window shows My First Presentation
d. All of the above
205. In which view do
you have to use the Delete Slide command on the Edit menu to delete a slide
(the Delete key is not valid)?
a. Slide Sorter view
b. Slide view
c. Both Slide Sorter and Slide views
d. Neither Slide Sorter nor Slide views
206. Which of the
following statements is true about PowerPoint's ability to correct spelling?
a. It will automatically correct all misspelled
words as you type them
b. It will automatically correct only those
words in the main spell check dictionary
c. It will automatically correct only those
words defined in the AutoCorrect feature
d. It cannot automatically correct any
misspellings
Page 29
207. You are rehearsing
a presentation in Slide Show view, but do not see any bullets on the current
slide (which you know has three bullets). What is the most likely explanation?
a. The bullets are defined with a build effect
and have not yet been displayed
b. The bullets on this slide are hidden
c. The option to suppress the bullets was
selected
d. The Show Titles Only command was executed in
the Outline view
208. Which of the
following is the most important element in a PowerPoint presentation?
a. The content
b. The template
c. The slide layout
d. The transition and build effects
209. The Normal view
displays Slide and Outline view only.
a. True
b. False
210. Both transition
and animation effects are available through the Slide Show menu.
a. True
b. False
211. To select
multiple slides while in Slide Sorter view, press and hold the Shift key then
click each slide.
a. True
b. False
212. Transitions
control the way in which one slide moves off the screen and the next slide
appears.
a. True
b. False
213. A template will
typically define different colors for the background, text, and title on a
slide.
a. True
b. False
214. Once you have
selected a layout for a slide, you cannot change it to add a new object at a
later time.
a. True
b. False
215. Any markings
made with the PowerPoint annotation pen will be removed when you advance to the
next slide.
a. True
b. False
Page 1
1. c
2. a
3. c
4. d
5. c
6. b
7. a
8. c
9. b
10. c
11. b
12. a
13. b
14. b
15. d
16. c
17. d
18. c
19. b
20. False
21. True
22. a
23. d
Page 2
24. d
25. False
26. False
27. b
28. c
29. c
30. False
31. True
32. b
33. b
34. a
35. False
36. False
37. d
38. d
39. d
40. True
41. True
42. c
43. b
44. a
45. a
46. False
Page 3
47. True
48. d
49. d
50. a
51. a
52. False
53. True
54. a
55. c
56. a
57. False
58. False
59. d
60. a
61. d
62. c
63. True
64. True
65. b
66. d
67. d
68. d
69. False
Page 4
70. True
71. a
72. c
73. b
74. d
75. c
76. d
77. d
78. b
79. b
80. a
81. d
82. d
83. c
84. a
85. False
86. False
87. False
88. False
89. a
90. d
91. a
92. b
Page 5
93. c
94. a
95. c
96. d
97. False
98. True
99. a
100. d
101. b
102. b
103. False
104. False
105. b
106. b
107. a
108. b
109. True
110. True
111. d
112. a
113. c
114. d
115. False
Page 6
116. True
117. b
118. c
119. b
120. d
121. False
122. True
123. False
124. False
125. c
126. d
127. a
128. c
129. True
130. True
131. a
132. b
133. a
134. d
135. b
136. d
137. a
138. c
Page 7
139. False
140. False
141. d
142. a
143. d
144. c
145. c
146. True
147. False
148. d
149. b
150. a
151. b
152. d
153. False
154. False
155. c
156. d
157. a
158. d
159. a
160. True
161. True
Page 8
162. b
163. d
164. b
165. a
166. d
167. False
168. False
169. a
170. d
171. c
172. a
173. b
174. True
175. True
176. c
177. d
178. a
179. a
180. d
181. True
182. False
183. b
184. c
Page 9
185. b
186. b
187. a
188. True
189. False
190. c
191. b
192. c
193. c
194. b
195. False
196. False
197. c
198. c
199. d
200. c
201. c
202. True
203. False
204. c
205. b
206. c
207. a
Page 10
208. a
209. False
210. True
211. True
212. True
213. True
214. False
215. True