Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
When a program window is minimized, you still see its ________ displayed on the taskbar.
1)
A)
icon
B)
crest
C)
table
D)
graph
Answer:
Explanation:
A)
B)
C)
D)
2)
If you ________ Excel data pasted into a Word document, Excel opens to allow for editing of the
data.
2)
A)
point to
B)
click
C)
double–click
D)
right–click
Answer:
Explanation:
A)
B)
C)
D)
3)
When you ________ data from Access to Excel a copy of the data is created in Excel.
3)
A)
import
B)
compress
C)
explode
D)
export
Answer:
Explanation:
A)
B)
C)
D)
4)
When you open a Word document that contains links to other files, a(n) ________ will
automatically display.
4)
A)
Paste Special Warning
B)
Export Warning
C)
Security Notice
D)
Link Warning
Answer:
Explanation:
A)
B)
C)
D)
5)
Excel’s ________ handle can be used to drag formulas to adjacent cells.
5)
A)
paste
B)
fill
C)
copy
D)
export
Answer:
Explanation:
A)
B)
C)
D)
1
6)
When you export an Access query to Excel, the query name also becomes the name of the Excel
________ where the data is stored.
6)
A)
table
B)
chart
C)
workbook
D)
worksheet
Answer:
Explanation:
A)
B)
C)
D)
7)
An Excel chart can be placed on a worksheet called a ________ where it will appear by itself
without any of the underlying data.
7)
A)
table sheet
B)
graph sheet
C)
legend sheet
D)
chart sheet
Answer:
Explanation:
A)
B)
C)
D)
8)
The data in an Excel table can be quickly totaled by displaying a ________ at the end of the table.
8)
A)
Function Row
B)
Total Row
C)
Summation Row
D)
Math Row
Answer:
Explanation:
A)
B)
C)
D)
9)
To make managing and analyzing a group of Excel data easier, turn the data into a
9)
A)
table.
B)
database.
C)
query.
D)
report.
Answer:
Explanation:
A)
B)
C)
D)
10)
Access data can be ________ so that only records that meet specified conditions are shown and
records that do not meet the conditions are hidden.
10)
A)
filtered
B)
tabled
C)
transposed
D)
grouped
Answer:
Explanation:
A)
B)
C)
D)
2
11)
Excel allows the user to create a range made up of nonadjacent cells by holding down the ________
key as the cells are selected.
11)
A)
Shift
B)
Ctrl
C)
Alt
D)
Tab
Answer:
Explanation:
A)
B)
C)
D)
12)
The file extension ________ indicates an Excel file.
12)
A)
.xlsx
B)
.excel
C)
.ppt
D)
.docx
Answer:
Explanation:
A)
B)
C)
D)
13)
You can modify data in the ________ file and all linked data to the file will be updated.
13)
A)
source
B)
chained
C)
placeholder
D)
object
Answer:
Explanation:
A)
B)
C)
D)
14)
When saving an Access database, if the Security Warning displays, you should click the ________
button.
14)
A)
External Data
B)
Enable Content
C)
Import
D)
Export
Answer:
Explanation:
A)
B)
C)
D)
15)
________ is a way to output an Access database to another database, spreadsheet, or file format so
another program can use the data.
15)
A)
Moving
B)
Importing
C)
Transferring
D)
Exporting
Answer:
Explanation:
A)
B)
C)
D)
16)
Excel’s ________ is used to copy formulas to adjacent cells.
16)
A)
drag handle
B)
function bar
C)
fill handle
D)
formula bar
Answer:
Explanation:
A)
B)
C)
D)
3
17)
After a column of data in a table has been sorted, a small ________ displays on the Filter button to
indicate the sort order.
17)
A)
chevron
B)
bullet
C)
arrow
D)
letter
Answer:
Explanation:
A)
B)
C)
D)
18)
When exporting an Access database, you use the ________ button to determine the location where
the new file will be saved.
18)
A)
Enable Content
B)
Text from File
C)
Fill
D)
Browse
Answer:
Explanation:
A)
B)
C)
D)
19)
When pasting data into an Excel worksheet, if a column is not wide enough to display the number,
the symbol ________ will be displayed in the cell.
19)
A)
$
B)
?
C)
!
D)
#
Answer:
Explanation:
A)
B)
C)
D)
20)
When data is changed in the ________ all data linked to the source will be updated when the files
containing the links are opened and the user says he or she does want to update.
20)
A)
placeholder file
B)
main file
C)
data file
D)
source file
Answer:
Explanation:
A)
B)
C)
D)
21)
Once a SmartArt graphic is created, you can ________ it into another program.
21)
A)
shift
B)
merge
C)
copy and paste
D)
transfer
Answer:
Explanation:
A)
B)
C)
D)
4
22)
The Mail Merge process starts with two files, the main document and the
22)
A)
data source.
B)
executable file.
C)
intermediate file.
D)
object file.
Answer:
Explanation:
A)
B)
C)
D)
23)
To link data from Excel to Word you need to use options found in the ________ dialog box.
23)
A)
Insert Special
B)
Insert
C)
Paste Special
D)
Paste
Answer:
Explanation:
A)
B)
C)
D)
24)
A visual way to illustrate data in an understandable manner is to create a
24)
A)
cell.
B)
table.
C)
worksheet.
D)
chart.
Answer:
Explanation:
A)
B)
C)
D)
25)
An Excel ________ can be managed independently from other data in the worksheet.
25)
A)
diagram
B)
database
C)
table
D)
prototype
Answer:
Explanation:
A)
B)
C)
D)
26)
If the Security Warning comes up when you are saving an Access database you should click the
________ button.
26)
A)
Ignore Warning
B)
Export Content
C)
Export File
D)
Enable Content
Answer:
Explanation:
A)
B)
C)
D)
27)
In PowerPoint, a bulleted list can be converted into a(n) ________ to illustrate a message visually.
27)
A)
SmartArt graphic
B)
Export graphic
C)
chart
D)
WordArt graphic
Answer:
Explanation:
A)
B)
C)
D)
5
28)
Excel’s ________ function is used to add numbers together.
28)
A)
ADD
B)
ADDER
C)
SUM
D)
PLUS
Answer:
Explanation:
A)
B)
C)
D)
29)
When pasting data into an Excel range, the pasting begins in the
29)
A)
upper left corner of the range.
B)
lower right corner of the range.
C)
upper right corner of the range.
D)
lower left corner of the range.
Answer:
Explanation:
A)
B)
C)
D)
30)
One way to move data from one application to another is to ________ the data.
30)
A)
copy and paste
B)
transpose
C)
filter
D)
group
Answer:
Explanation:
A)
B)
C)
D)
31)
An Excel table’s Total Row provides functions found in a
31)
A)
series of check boxes.
B)
series of option buttons.
C)
dialog box.
D)
drop–down list.
Answer:
Explanation:
A)
B)
C)
D)
32)
If a Word document and an Excel spreadsheet are ________, any change in the spreadsheet will be
updated in the Word document when it is opened.
32)
A)
in the same folder
B)
shared
C)
linked
D)
on the same storage device
Answer:
Explanation:
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
33)
Access data that has been ________ displays only records that meet specified conditions.
33)
Answer:
filtered
Explanation:
6