Multiple
Choice
Identify
the letter of the choice that best completes the statement or answers the
question.
|
| |
1. |
Which
function will display today's date in a worksheet?
|
a. |
DATE |
c. |
NOW |
|
b. |
PRESENT |
d. |
DAY |
|
|
|
|
|
| |
2. |
Which
type of cell reference adjusts to its new location when copied or
moved?
|
a. |
stable |
c. |
adapted |
|
b. |
relative |
d. |
absolute |
|
|
|
|
|
| |
3. |
____
allows you to work with several items as if they were one
object.
|
a. |
Highlighting |
c. |
Gathering
|
|
b. |
Grouping |
d. |
Selecting |
|
|
|
|
|
| |
4. |
Labels
appear in the form of
|
a. |
numbers. |
d. |
all
of the above. |
|
b. |
letters. |
e. |
none
of the above. |
|
c. |
mathematical expressions |
|
|
|
|
|
| |
5. |
The
drag-and-drop method is the same for moving data as it is for copying data
except that you do not hold down the ____ key.
|
a. |
Insert |
c. |
Alt |
|
b. |
Ctrl |
d. |
Shift |
|
|
|
|
|
| |
6. |
Which
type of cell reference does not change when it is moved or copied to a new
cell?
|
a. |
relative |
c. |
absolute |
|
b. |
mixed |
d. |
stable |
|
|
|
|
|
| |
7. |
What
would happen if you entered AVERAGE(B3:B7) into a spreadsheet
cell?
|
a. |
it would average B3:B7 |
d. |
it
would add B3:B7 |
|
b. |
nothing |
e. |
none
of the above |
|
c. |
it would display AVERAGE(B3:B7) |
|
|
|
|
|
| |
8. |
Which
calculation will be performed first in a formula that does not contain
parentheses?
|
a. |
multiplication |
c. |
subtraction |
|
b. |
addition |
d. |
exponentiation |
|
|
|
|
|
| |
9. |
A
presentation can include which item?
|
a. |
text |
c. |
multimedia |
|
b. |
graphics |
d. |
all
of the above |
|
|
|
|
|
| |
10. |
An
effective presentation should be ____.
|
a. |
consistent |
c. |
visually appealing |
|
b. |
error-free |
d. |
all
of the above |
|
|
|
|
|
| |
11. |
What
is a collection of worksheets called?
|
a. |
work area |
c. |
workbook |
|
b. |
notebook |
d. |
spreadsheet |
|
|
|
|
|
| |
12. |
When
you open a new document, the new document window becomes the ____
window.
|
a. |
old |
c. |
original |
|
b. |
active |
d. |
none of the above |
|
|
|
|
|
| |
13. |
What
can you change in a bulleted list?
|
a. |
bullet's size |
c. |
distance between bullets |
|
b. |
bullet's
color |
d. |
all
of the above |
|
|
|
|
|
| |
14. |
Formulas
appear in the form of
|
a. |
numbers. |
d. |
all
of the above. |
|
b. |
letters. |
e. |
none
of the above. |
|
c. |
mathematical expressions. |
|
|
|
|
|
| |
15. |
Which
view displays your slides on the top of the page with the speaker notes
for each slide in the Notes pane on the bottom of the page?
|
a. |
Notes Sorter |
c. |
Notes Pages |
|
b. |
Slide
Show |
d. |
Slide
Sorter |
|
|
|
|
|
| |
16. |
You
can choose which option when printing your presentation?
|
a. |
Slide |
c. |
Outline
View |
|
b. |
Notes
Pages |
d. |
All
of the above |
|
|
|
|
|
| |
17. |
Values
appear in the form of
|
a. |
numbers. |
d. |
all
of the above. |
|
b. |
letters. |
e. |
none
of the above. |
|
c. |
mathematical expressions. |
|
|
|
|
|
| |
18. |
The
____ function displays the number of cells with numerical values in the
argument range.
|
a. |
VAR |
c. |
AVERAGE |
|
b. |
MAX |
d. |
COUNT |
|
|
|
|
|
| |
19. |
Which
key do you press to remove data from the selected cell?
|
a. |
Shift
+ End |
c. |
Delete |
|
b. |
Alt |
d. |
Ctrl |
|
|
|
|
|
| |
20. |
What
is the formula in cell D4 which subtracts Actual money spent on food from
Budget spent on food?
| |
A |
B |
C |
D |
|
1 |
Expenses |
Budget |
Actual |
Difference |
|
2 |
Clothes |
50 |
49 |
1 |
|
3 |
Insurance |
75 |
75 |
0 |
|
4 |
Food |
125 |
113 |
12 |
|
5 |
|
|
|
|
|
6 |
Total |
350 |
342 |
8 |
|
|
|
|
|
|
a. |
=B4-C4 |
d. |
=125-113 |
|
b. |
B4-C4 |
e. |
none
of the above |
|
c. |
=113-125 |
|
|
|
|
|
| |
21. |
To
sort text,, open the ____ menu and choose sort.
|
a. |
Format |
c. |
Window |
|
b. |
Edit |
d. |
Tables |
|
|
|
|
|
| |
22. |
What
is the purpose of the COUNT function?
|
a. |
It determines the number of filled cells in a
range. |
|
b. |
It determines the number of cells in a
range. |
|
c. |
It determines the number of columns in a
range. |
|
d. |
It determines the number of empty cells in a
range. |
|
|
|
| |
23. |
Which
function determines the payment needed each period to repay a
loan?
|
a. |
PV |
c. |
PAY |
|
b. |
PMT |
d. |
FV |
|
|
|
|
|
| |
24. |
Use
____ to select more than one object on a slide.
|
a. |
object selection |
c. |
Shift-clicking |
|
b. |
multiple
selection |
d. |
auto
selection |
|
|
|
|
|
| |
25. |
Which
option is an arrangement of text or numbers in rows and columns, similar
to a spreadsheet?
|
a. |
section |
c. |
data |
|
b. |
document |
d. |
table |
|
|
|
|
|
| |
26. |
Data
stored on the ____ will remain until it is replaced with new
data.
|
a. |
formula
bar |
c. |
Clipboard |
|
b. |
toolbar |
d. |
border |
|
|
|
|
|
| |
27. |
What
can you change by clicking the Fill Color button or the Line Color button
on the toolbar?
|
a. |
fill
color |
c. |
font
color |
|
b. |
line color |
d. |
all of the above |
|
|
|
|
|
| |
28. |
Which
chart type shows values in what’s referred to as “slices?”
|
a. |
scatter |
c. |
doughnut |
|
b. |
column |
d. |
pie |
|
|
|
|
|
| |
29. |
Some
purposes of using a spreadsheet include:
|
a. |
grade
averaging |
d. |
all
of the above |
|
b. |
costs of items |
e. |
none
of the above |
|
c. |
math homework |
|
|
|
|
|
| |
30. |
Which
is not a tab stop?
|
a. |
right |
c. |
decimal |
|
b. |
justified |
d. |
center |
|
|
|
|
|
| |
31. |
Suppose
that the value in B3 is equal to 12 and the value in C3 is 3. Which
formula would display the value of 3?
|
a. |
=B3/(C3+1) |
c. |
=B3/C3+1 |
|
b. |
=(B3/C3+1) |
d. |
=(B3/C3)+1 |
|
|
|
|
|
| |
32. |
What
is the formula in cell F2 which gives the total proceeds from ticket sales
in row 2?
| |
A |
B |
C |
D |
E |
F |
|
1 |
Section |
Friday |
Saturday |
Total |
Price
of Each Ticket |
Proceeds |
|
2 |
Section A |
210 |
148 |
358 |
5 |
1790 |
|
3 |
Section
B |
65 |
85 |
150 |
3 |
450 |
|
|
|
|
|
|
|
|
a. |
=D2*5 |
d. |
=SUM(B2:D2)*E2 |
|
b. |
=D2*E2 |
e. |
none
of the above |
|
c. |
=210+148*5 |
|
