COCS1371
Test-3
Fall 2011
Keys
Used:
1-5:
DCCAD
6-10:
BCBED
11-15:
CBCCB
16-20:
DCBDC
21-25:
DCDCA
26-32:
ABDCADD
Name__________________________________________
In
each multiple choice question, mark the BEST one choice.
1.
A slide show can be started by clicking
a.
F5-key
b.
the ‘Slide Show View’ button
c.
“From Beginning” button available in the “Start Slide Show” Group on the
“Slide Show” Tab.
d.
all above
e. two
above.
2.
In the Slide Show view, which command does NOT
function?
a.
CTRL-M
b. CTRL-S
c. Both.
d.
Neither.
3.
Which is not to be shown to the audience during the slide show?
a.
the
contents of the Slides Tab Pane
b.
the
contents of the Slide Pane
c.
the
contents of Notes Pane
d.
none
4.
Which View lets you work either on the Slide Pane or on the Slides Tab
Pane with the same results?
a.
Normal
View
b.
Slide
Sorter View
c. Slide
Show View
d.
None
5.
During the Slide Show, which is to get to the next
slide?
a.
N-key
b. ENTER-Key
c. The Right Arrow in the Navigation
Bar that appears in the bottom-left corner of the current
slide
during a slide show.
d. all
above.
e. two
above.
6.
Which view is most suitable for rearranging the order of existing
slides?
a.
Normal View
b.
Slide Sorter View
c.
Notes Page View
7.
Which insertion requires entering key words such as
“Target”?
a.
charts
b.
SmartArt Graphic
c.
Clip Art
d.
all above
e.
two above
8.
Which finishes a slide show?
a.
F5 key
b.
ESC-key
c.
Enter-key
d.
two above
9.
Which inserts a new slide?
a.
CRTL-M
b.
the “New Slide” Menu available in the Slides Group on the Home Tab which
also lets us choose a slide layout
c.
F5 key
d.
all above
e.
two above
10. Which
options are available in the Outline (Tab) Pane?
a.
Promote and Demote
b.
Expand and Collapse
c.
Move Up
d.
all above.
e.
two above.
11. A
theme can be applied to
a.
all existing slides at the same time
b.
just one slide that has been selected at the moment in the Slide Sorter
view.
c.
both.
d.
neither.
12. An
animation can be activated to
a.
an entire slide as a whole.
b.
an object of a slide
c.
both.
d.
neither.
13. Which
button shows an immediate live preview when clicked?
a.
a transition button (such as Push, Wipe or Cover) in the “transition to
This Slide” Group on the
Transitions Tab.
b.
an animation button (such as Float In, Fly In, Wipe or Zoom) in the
Animation Group on the
Animations Tab.
c.
both.
d.
neither.
14. Which
Tab lets you choose and apply a theme?
a.
Home Tab
b.
Insert Tab
c.
Design Tab
d.
two above.
15. Which
Tab lets you record your (voice) narration?
a.
Design Tab
b.
Slide Show Tab
c.
Review Tab.
d. two
above.
16. Which
Tab lets you check spelling errors?
a.
Home Tab
b.
Design Tab.
c.
Insert Tab.
d.
Review Tab
e.
two above.
17. Which
Tab lets you choose the slide layout?
a.
Design Tab
b.
Insert Tab
c.
Home Tab.
18. Which
function key checks Spelling & Grammar errors?
a.
F5
b.
F7
c.
SHIFT+F7
d.
none above.
19. The
Text Placeholder let us immediately insert
a.
tables and charts
b.
SmartArt Graphic and Picture (from file)
c.
Clip Art and Media Clip such as Video and Audio
clips
d.
all above.
e.
Two above
20. In
most cases, Animation Effect Options include
a.
Direction
b.
Sequence
c.
Both.
d.
Neither
21. Which is true about the
Primary Key Field?
a.
A table may two fields both designated as a primary key
field.
b. Two records
of a table may have the same primary key value.
a.
Both.
d.
neither.
22. The referential
integrity is not enforced unless
a.
the primary table has
all the values of the primary key field that the related table has in
the
foreign key field.
b.
every foreign key value
of the related table equals a value of
the primary key of the primary table..
c.
Both.
d.
neither.
23. Which is true about
Relationship Button?
a.
it is available inside the Database Tools Tab.
b.
it lets us select tables on which to establish a
relationship.
c.
it lets us establish a desired relationship among selected
tables.
d.
all above.
e.
two above.
24. Which is the primary
object?
a.
reports
b.
queries
c.
tables
d.
none of above.
25. Each row of a table
represents
a.
a record
b.
a field
c.
an attribute
For
next three questions, Consider the following Filter being set
up:
---------------------------------------------------------------------------------------
Field| DAY
TIME
Sort |
descending
Criteria| TUESDAY
> 16:00
OR |
< = 11:00
---------------------------------------------------------------------------------------
26. Selected records will
include those
a. whose DAY
is MONDAY and whose TIME is 11AM.
b. whose DAY
is MONDAY and whose TIME is
2PM.
c. Both.
d.
Neither.
27. Selected records will include those
a. whose DAY
is TUESDAY and whose TIME is 9AM.
b. whose DAY
is TUESDAY and whose TIME is 5PM.
c. Both.
d.
Neither.
28. Selected records will
be sorted so that
a.
Monday 9AM classes will
appear before Monday 10 AM classes
b.
Monday 10AM classes will
appear before Tuesday 6PM classes.
c.
both.
d.
neither.
29. A change made to
a. a query will
change the underlying table from which the query is made.
b. a table will
change a query which is based on the table.
c. both.
d.
neither.
30. A One-to-Many
relationship is made
a.
from the primary key of the primary table to a foreign key of the related
table.
b.
from a foreign key of the primary table to a primary key of a related
table even when the two
field
names are not the same.
c.
both.
d.
neither.
31. Which text object can be
inserted to Powerpoint?
D a.
Microsoft Word documents
b.
Excel Worksheet
c.
Adobe Acrobat documents
d.
all above
e.
two above
32. Which is an option in
the Query Wizard?
a.
Simple Query Wizard
b.
Find Duplicate Query Wizard
c.
Find Unmatched Query Wizard
d.
All above.
e.
two above.