True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Using a sketch of the worksheet is not very useful for visualizing the worksheet
design.
|
|
|
2.
|
You should enable macros only if you trust the author who created the workbook
with the macro.
|
|
|
3.
|
Protecting a workbook, instead of a worksheet, protects the structure and
windows of the workbook, but not individual worksheets.
|
|
|
4.
|
Most macros created with the macro recorder are workbook-specific and thus are
stored in the active workbook.
|
|
|
Figure 7-2
|
|
|
5.
|
In the accompanying figure, the Developer tab was added automatically when the
macro recorder started recording.
|
|
|
6.
|
Using multiple scenarios on the same worksheet is an expenditure of time because
it reuses the work that you did to create the initial worksheet.
|
|
|
7.
|
The Scenario Summary worksheet generated by the Solver actually is an outlined
worksheet that you can print and manipulate just like any other worksheet.
|
|
|
8.
|
A Scenario PivotTable worksheet gives you the ability to summarize the scenario
data and then rotate the table’s row and column titles to obtain different views of the
summarized data.
|
|
|
9.
|
MSQuery is the supplemental application included in Microsoft Office 2007 that
is used to export data to external data sources.
|
|
|
Figure 9-1
|
|
|
10.
|
In the accompanying figure, data from an Access table is being imported.
|
|
|
Figure 9-3
|
|
|
11.
|
In the accompanying figure, the Web page table column headings were imported
with the data.
|
|
|
12.
|
In the accompanying figure, the column headings in rows 13 and 14 are duplicated
from row 2 because they are imported with the other data.
|
|
|
13.
|
A Microsoft Windows video (.avi) file can be inserted into a PowerPoint
presentation.
|
|
|
14.
|
You cannot combine coloring effect on one photograph.
|
|
|
15.
|
Live preview is available for the Picture Shape gallery.
|
|
|
16.
|
Audio files to be included in a presentation can be from the Microsoft Clip
Organizer but cannot come from an audio track on a CD.
|
|
|
17.
|
The Repeat button on the Rehearsal toolbar resets the timer to 1:00.
|
|
|
18.
|
You can show speaker notes on one monitor while they are hidden on another
monitor.
|
|
|
19.
|
Quick Styles cannot be used in slide masters.
|
|
|
20.
|
The Center button in the Align gallery centers text between the left and right
borders of a placeholder.
|
|
|
21.
|
The Close Master View button is orange with a white X.
|
|
|
22.
|
The starting number for the numbering option must start with 1.
|
|
|
23.
|
SmartArt graphics cannot be animated.
|
|
|
Figure 7-3
|
|
|
24.
|
You can use the Document Map in the accompanying figure to navigate quickly
through the document.
|
|
|
25.
|
Macros are a known carrier of viruses and other malware.
|
|
|
Figure 9-2
|
|
|
26.
|
The macro recorder shown in the accompanying figure records all actions you
perform to a document while the macro recorder is running.
|
|
|
27.
|
It is not possible to assign a shortcut key to a macro like the one created in
the dialog box in the accompanying figure.
|
|
|
28.
|
Word’s prenamed macros are called mechanical macros.
|
|
|
29.
|
Comments have an effect on the execution of a procedure.
|
|
|
30.
|
All users consider self-signed documents as unsafe as documents with no
certificates at all.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
31.
|
When a worksheet is protected, users ____.
a. | cannot change data in locked cells | c. | can change macros in locked
cells | b. | can modify the worksheet | d. | none of the above |
|
|
|
32.
|
Protecting the structure of a workbook means that users cannot ____
sheets.
a. | add | c. | unhide | b. | move | d. | all of the
above |
|
|
|
33.
|
A Command Button control has ____ different properties.
|
|
|
34.
|
The Properties window includes two property sheets: Alphabetic and ____.
a. | Categorized | c. | Symbolic | b. | Numeric | d. | none of the
above |
|
|
|
35.
|
The Min property can be assigned a ____.
a. | whole number | c. | decimal | b. | fraction | d. | all of the
above |
|
|
|
36.
|
Tracer arrows appear in ____ when one of the referenced cells contains an
error.
|
|
|
37.
|
Until a workbook is ____, Excel provides no indication that another user has
changed the shared workbook.
a. | saved | c. | replicated | b. | copied | d. | deleted |
|
|
|
38.
|
You may protect a shared workbook with a(n) ____.
a. | number value substitution | c. | digital
signature | b. | encrypted bullet | d. | password |
|
|
|
39.
|
PivotTables can show the ____ among the data in a list or a database.
a. | relationships | c. | trendline | b. | individual value | d. | change history |
|
|
|
40.
|
Worksheet ____ do not print when all or a portion of the worksheet is
printed.
a. | backgrounds | c. | changes | b. | comments | d. | none of the
above |
|
|
|
Figure 9-2
|
|
|
41.
|
In the accompanying figure, which check box allows you to specify a range of
cells to check for changes?
|
|
|
Figure 9-3
|
|
|
42.
|
In the accompanying figure, the data was imported starting at cell A13 because
____.
a. | the range always ends at row 12 | c. | the cell was specified on the
Export Data dialog box | b. | it was the first blank cell in the
table | d. | it was active when
the Web query was performed |
|
|
|
43.
|
In the accompanying figure, will the box in the top-right corner of the Ribbon
that contains 4” change if you change the box above it?
a. | Yes, it will automatically change in 1” increments. | b. | Yes, it will
automatically change in .10” increments. | c. | Yes, it will change in proportion with the
sizing in the box above it. | d. | No, but it can be changed
manually. |
|
|
|
44.
|
Which of the following is FALSE about the icon that indicates a sound file is
inserted?
a. | it displays as a speaker icon | b. | it can be dragged off of a
slide | c. | it can be moved | d. | it displays as a musical
note |
|
|
|
45.
|
The Elapsed Time button on the Rehearsal toolbar indicates the
____________________.
a. | slide show total time | b. | time per slide | c. | average time per
slide | d. | time up to that point in the slide show |
|
|
|
Figure 2
|
|
|
46.
|
In the accompanying figure, what is the horizontal light blue color bar or
break-line above the “Energy Start equipment...” text known as?
a. | crossbar | c. | status bar | b. | splitter bar | d. | task bar |
|
|
|
47.
|
If you rename a master, the new name will be displayed on the
____________________.
a. | Ribbon | c. | title bar | b. | status bar | d. | slide master
header |
|
|
|
Figure 2
|
|
|
48.
|
If you move your mouse arrow directly over the red triangle at the end of the
downward curving line leading from the Refrigerator shape, your cursor will turn into a
_____________________ arrow.
a. | two-headed | c. | green | b. | four-headed | d. | hand-shaped |
|
|
|
Figure 3
|
|
|
49.
|
In the accompanying figure, the PowerPoint file is shown in
_____________________ view.
a. | Slide Sorter | c. | Normal | b. | Slide Show | d. | Slide and Sort |
|
|
|
50.
|
If an illustration is identified with a number, the ____ may include the word,
Figure, along with the illustration number.
a. | caption | c. | bookmark | b. | index | d. | topic |
|
|
|
Figure 7-3
|
|
|
51.
|
When you click a ____ in the Document Map shown in the accompanying figure, Word
displays the page associated with it in the document window.
a. | footer | c. | heading | b. | dot leader | d. | character set |
|
|
|
52.
|
A selected content control is surrounded by a ____ outline.
a. | blue | c. | black | b. | red | d. | blinking |
|
|
|
53.
|
The ____ command displays the selected object at the top of the stack.
a. | Bring Forward | c. | Top of Stack | b. | Bring to Front | d. | Stack Top |
|
|
|
54.
|
Word provides a gallery of ____ predefined textures you can apply to a
page.
|
|
|
55.
|
A document can contain only one ____ macro.
a. | AutoClose | c. | AutoNew | b. | AutoOpen | d. | all of the
above |
|
|
|
56.
|
In the Visual Basic Editor, click ____ on the menu bar and then click Code to
display the Code window in the Editor.
a. | Display | c. | Show | b. | Options | d. | View |
|
|
|
57.
|
Keywords appear in ____ in the Code window.
|
|
|
58.
|
____ is a language used to encapsulate data and a description of the data in a
single text file.
|
|
|
59.
|
XML uses ____ to describe data items.
a. | icons | c. | indices | b. | tags | d. | keys |
|
|
|
60.
|
In XML, each data item is called a(n) ____.
a. | sharepoint | c. | element | b. | constant | d. | variable |
|