34)
Clicking the ________ of a SmartArt graphic selects the entire object, not just a part of the
object.
34)
Answer:
border
Explanation:
35)
If you have data in an Excel spreadsheet that you wish to manage independently from the
other data in the worksheet, you should turn the data into a(n) ________.
35)
Answer:
table
Explanation:
36)
In any Office application, clicking the File tab causes the ________ view to display.
36)
Answer:
Backstage
Explanation:
37)
Match the following terms to their meanings:
I. SUM A. visual way to illustrate data
II. Fill handle B. Excel data that can be manipulated separately from other data
in a spreadsheet
III. Chart C. Excel function for adding numbers
IV. Table D. similar to copy and paste
V. Export E. used to copy formulas to adjacent cells in Excel
37)
Answer:
C, E, A, B, D
Explanation:
38)
An Excel worksheet where only a chart is displayed is called a(n) ________.
38)
Answer:
chart sheet
Explanation:
39)
Click the ________ button if a Security Warning message displays as you are saving an
Access database.
39)
Answer:
Enable Content
Explanation:
40)
________ is similar to copying and pasting, but you do not have to select the data to copy
it.
40)
Answer:
Exporting
Explanation:
41)
After an Excel table has been sorted, its sort order is indicated by a(n) ________ on the
Filter button.
41)
Answer:
arrow
Explanation:
42)
When doing a Mail Merge, ________ serve as placeholders for the data that will be inserted
from the Access database.
42)
Answer:
merge fields
Explanation:
7
43)
To link an Excel chart to a Word document, you use options found in the ________ dialog
box.
43)
Answer:
Paste Special
Explanation:
44)
The file extension ________ indicates an Excel file.
44)
Answer:
.xlsx
Explanation:
45)
Excel’s ________, found on the lower right corner of the active cell, is used to copy a
formula to adjacent cells.
45)
Answer:
fill handle
Explanation:
46)
In Excel, the Where is the data for your table? question appears in the ________ dialog box.
46)
Answer:
Create Table
Explanation:
47)
Match the following terms to their meanings:
I. Total Row A. dialog box that shows options for data that has been copied
II. Paste Special B. used in Excel tables to sum columns of data
III. Clipboard C. where data that has been copied is stored on a temporary
basis
IV. Mail Merge D. creating letters from various sources
47)
Answer:
B, A, C, D
Explanation:
48)
To select a range made up of nonadjacent cells or groups of cells you must hold down the
________ key while making your selections.
48)
Answer:
Ctrl
Explanation:
49)
Clicking an icon that appears on the taskbar makes that the ________ window.
49)
Answer:
active
Explanation:
50)
When you ________ data from Access to Excel, the data is copied into an Excel worksheet
much like doing a copy and paste.
50)
Answer:
export
Explanation:
51)
The names of the tables and queries in an Access database are displayed in the ________
pane.
51)
Answer:
navigation
Explanation:
52)
A(n) ________ can be used to visually illustrate Excel data in an understandable manner.
52)
Answer:
chart
Explanation:
8
53)
The file that originally contained the data that was pasted into another document is called
the ________ file.
53)
Answer:
source
Explanation:
54)
Excel’s ________ function is used to add numbers together.
54)
Answer:
SUM
Explanation:
55)
When Word data is pasted into Excel, the pasting begins in Excel’s ________ cell.
55)
Answer:
active
Explanation:
56)
Match the following terms to their meanings:
I. Data source A. display only records that meet a set of criteria
II. Merge fields B. names and addresses to be used in a Mail Merge
III. Filter C. where data is entered in an Excel spreadsheet
IV. Sort D. place data into ascending or descending order
V. Active cell E. placeholders for names and addresses in the main document
of a Mail Merge
56)
Answer:
B, E, A, D, C
Explanation:
57)
When a Word table is selected, the ________ contextual tabs display.
57)
Answer:
Table Tools
Explanation:
58)
After a Mail Merge has been carried out, you can click the ________ button under the
Preview Results group to look at each document created, one at a time.
58)
Answer:
Next Record
Explanation:
59)
Any time a Word document that contains a link to an external file is opened, a(n) ________
will display.
59)
Answer:
Security Notice
Explanation:
60)
If the two files are ________, you can refer to and edit an Excel worksheet within a Word
document.
60)
Answer:
linked
Explanation:
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
61)
The same technique is used to insert a header on a chart sheet and a worksheet.
61)
Answer:
True
False
Explanation:
9
62)
The Mail Merge process begins with two files.
62)
Answer:
True
False
Explanation:
63)
Double–clicking data that was copied and pasted from Excel and linked in a Word document will
open Excel so the data can be changed.
63)
Answer:
True
False
Explanation:
64)
Copying and pasting is faster and less error prone than exporting data.
64)
Answer:
True
False
Explanation:
65)
A PowerPoint bulleted list can be turned into a SmartArt graphic, which can then be copied and
pasted into another program.
65)
Answer:
True
False
Explanation:
66)
Data from an Access database cannot be exported to an Excel spreadsheet.
66)
Answer:
True
False
Explanation:
67)
An Excel chart can be placed on a chart sheet, which is a worksheet separate from the data the chart
is based on.
67)
Answer:
True
False
Explanation:
68)
A Word document can be linked to Excel data by using options found in the Paste Special menu.
68)
Answer:
True
False
Explanation:
69)
Excel has more mathematical capabilities than Word does.
69)
Answer:
True
False
Explanation:
70)
After a column has been sorted, an arrow will display on the Filter button that indicates the sort
order of the column.
70)
Answer:
True
False
Explanation:
71)
Copy and pasting data from one program to another keeps the user from having to retype the data.
71)
Answer:
True
False
Explanation:
72)
An Access database can contain more than one table.
72)
Answer:
True
False
Explanation:
10
73)
It is rare to have to make changes to a document after it is completed.
73)
Answer:
True
False
Explanation:
74)
A SmartArt graphic created in PowerPoint can be copied and pasted into an Excel worksheet.
74)
Answer:
True
False
Explanation:
75)
An Excel table can be created with or without headers.
75)
Answer:
True
False
Explanation:
76)
Minimizing a window is the same as closing a window.
76)
Answer:
True
False
Explanation:
77)
Applications from a software suite work well with one another.
77)
Answer:
True
False
Explanation:
78)
When an Access query is exported to Excel, the query name becomes the Excel worksheet name.
78)
Answer:
True
False
Explanation:
79)
Chevron symbols surround the field names in the main document of a mail merge and will not
display in the final document.
79)
Answer:
True
False
Explanation:
80)
An Excel table can be managed independently from the other data in the worksheet.
80)
Answer:
True
False
Explanation:
81)
An Excel chart cannot be pasted into a Word document.
81)
Answer:
True
False
Explanation:
82)
An Access database cannot be saved as a rich text format (.rtf) file.
82)
Answer:
True
False
Explanation:
83)
The Table Tools contextual tabs display even when no table is selected.
83)
Answer:
True
False
Explanation:
84)
In Excel, you can select nonadjacent cells as long as you hold down the Shift key as you select.
84)
Answer:
True
False
Explanation:
11
85)
When a Word document contains links to other files, the data in the Word document will be
updated automatically each time the Word document is opened.
85)
Answer:
True
False
Explanation:
86)
Data and graphics created with one program from a suite can be exported to another program from
the suite.
86)
Answer:
True
False
Explanation:
87)
Copying and pasting is a better option than exporting if you are dealing with large amounts of
data.
87)
Answer:
True
False
Explanation:
12