COCS1371
Final Exam.
5/6/2009
Keys
Used:
1-10:
CCCAC BBCAC
11-20:
BAAAC CAAAC
21-30:
AACCA BCCAC
31-40:
BBBAA ADCAD
41-50:
ADDCA CABCD
51-62:
BAEBA BCBCDBA
Name__________________________________________
In
each multiple choice question, mark the BEST one choice.
1.
Which
is true of the Desktop?
a.
It is
the basic interface of the Operating System
b.
It
displays icons that represent folders or application
programs.
c.
Both.
d.
neither.
2.
The Desktop
displays
a.
Icons
b.
The
Task Bar that contains the Start Button and minimized
windows
c.
Both.
d.
neither.
3.
The Windows Explorer can be opened
by
a.
Pressing
the MS Logo key and E-key simultaneously.
b.
Selecting
the Explore command on the shortcut menu of a folder.
c.
Both.
d.
neither.
4.
The Folders pane of the Windows
Explorer window shows
a.
A
hierarchy of folders that you can navigate and open.
b.
File
names of the folder you opened.
c.
Both.
d.
neither.
5.
The second generation
computers
a.
Were
characterized by the use of transistors.
b.
Were
more reliable and faster than first generation computers such as
ENIAC.
c.
Both.
d.
neither.
6.
HTML
a.
Stands
for Hyper Text Microscopic Language
b.
Is
the standard language to write WWW pages.
c.
Both.
d.
neither.
7.
The shortcut menu can be opened
by
a.
Left
clicking the mouse button.
b.
Right
clicking the mouse button.
c.
Both.
d.
neither.
8.
Which is the word
processor?
a.
Excel
b.
Powerpoint
c.
Word
d.
a and b above.
9.
Which is the spreadsheet
application for business operation?
a.
Excel
b.
Powerpoint
c.
Access
d.
b and c above.
10.
Which is true of RAM(Random Access
Memory)
a.
It is
the majority of the Main Memory
b.
Is
volatile.
c.
Both.
d.
neither.
11.
Typical computer speed can be
measured by the frequency of Synchronizing Pulses and is
roughly
a.
1
GHZ
b.
2
GHZ
c.
20
MHZ
12.
Hourly US population increase and
world population increase are roughly
a.
280
and 9500
b.
600
and 9500
c.
2000
and 40000
d.
280
and 40000
13.
The
command used in saving a file for the first time is
a.
Save
As
b.
Save
c.
Copy
d.
Paste
14.
CTRL-C and CTRL-P are
respectively
a.
Copy
and Print
b.
Copy
and Paste
c.
Cut
and Print
d.
None
of above
15.
Word2007 Home Tab displays buttons
for
a.
Font
and paragraph
b.
Clipboard
and Styles
c.
Both.
d.
neither.
16.
Word 2007 Font Group displays buttons
for
a.
Font
(Face), font size, font color and text highlight color.
b.
Bold,
underlining, subscripting and superscripting
c.
Both.
d.
neither.
17.
Which is to insert a non-breaking
hyphen?
a.
CRTL+Shift+Hyphen
b.
CTRL+Alt+Hyphen
c.
Both.
d.
neither.
18.
Default view of Word2007
is
a.
Print
Layout View
b.
Web
Layout View
c.
Full
Screen Reading View
d.
Outline
View
19.
The Full Screen Reading View is useful
when
a.
multiple
pages need to be displayed together on the full screen.
b.
just
one page needs to be displayed in larger font size.
c.
Both.
d.
neither
20.
Word2007 Insert Tab displays buttons
for
a.
Pages,
tables and Illustrations
b.
Header&Footer
and Symbols
c.
Both.
d.
neither.
21.
In sorting a table
a.
You
can use Sort button that appears when Layout Tab is
clicked
b.
You
can use as many as four sorting keys which may be used as either ascending or
descending keys.
c.
Both.
d.
neither.
22.
In sorting a table
a.
You
can arrange its rows only.
b.
You
can arrange its columns only.
c.
either.
d.
neither.
23.
CTRL-A selects the entire document
including
a.
All
tables
b.
All
surrounding texts such as table titles.
c.
Both.
d.
neither.
24.
Triple-clicking in Word2007
selects
a.
A
word
b.
A
sentence
c.
A
paragraph.
d.
The
entire document.
Next
12 questions are about Excel2007.
For the first
five questions, assume that the following ten cells have been set
up:
F4:
GOODFRIDAY
F5:
HAPPYSATURDAY
F6:
$3000
F7:
$4000
F8:
$5000
F9:
=SUM(F6:F8)
F10: =FV(1%, 48,
-1000)
F11: =IF (F9<F7, F9, F7)
F12: =$F$11
F13:
=F11
25. The value
of F9 is
a. $12000
b. $9000
c. $7000
d. None
26. If F6:F11
are copied into G6:G11, then G11 will contain:
a.
=IF (F9<F7, F9, F7)
b. =IF (G9<G7, G9, G7)
c.
Neither.
27. If F10:F13
are copied into H9:H12, then H11 will contain:
a.
=$H$11
b. =F11
c.
=$F$11
d. None
28. The value
of F10 is at least
a. 6000
b. 36000
c. 48000
d. None
29. The value
of F11 is
a. $4000
b. $7000
c. $12000
d. None
*****************************************************************
30. Suppose that a
new column #B has been inserted.
In this case, '=$D$4'
automatically turns into:
a. =$E$5
b.
=$D$5
c.
=$E$4
d. none
of above.
31. Suppose that a
new column #B has been inserted.
In
this case, “=D4” automatically turns into:
a.
=D5
b.
=E4
c.
=E5
d.
none above.
32. EXCEL worksheet can have up to
roughly
a. 256 columns and 1000000 rows.
b. 15000 columns and 1000000
rows.
c. 256 columns and 32768 rows.
33.
Which is
smallest?
a. SYD(20000,4000,8,6)
b. SYD(20000,4000,8,7)
c. SLN(20000,4000,8)
d. Cannot tell.
34. Which is
largest?
a. PMT (5%,24,-10000)
b. PMT
(4%,24,-10000)
c. PMT (4%,36,-10000)
d. Cannot
tell
35. Which gives
the Net Income?
a.
the
difference between Gross Margin and Selling/Administrative expenses such as
advertising
and sales commissions.
b.
the
difference between Total Sales and Selling/Administrative expenses.
c.
neither
36. Which is to
compute the sum of the first two year depreciation amounts for the SYD depreciation method
where Cost=$30000, Salvage=$6000, and Life=8 years?
a.
=
SYD(30000,6000,8,1)+SYD(30000,6000,8,2)
b.
=
SLN(30000,6000,8,1)+ SLN(30000,6000,8,2)
c.
=
2*SYD(30000,6000,8)
d.
None
of above
Next
11 questions are on ACCESS2007:
37. Which is
true about the Primary Key Field?
a.
A table must have exactly one field designated as the primary key
field.
b.
Two
records of a table may have the same primary key field
value.
c.
Both.
d.
neither.
38. The report
wizard lets us select as it becomes
available when “Create” tab has been selected
a.
table
fields to appear on the report.
b.
a
table field or fields for grouping levels.
c.
Both.
d.
All above
39. The
referential integrity is not
enforced unless
a.
the
primary table has all the values of the reference field that the related table
has.
b.
the
referenced field of the related table is designated as the primary key field.
c.
Both.
d.
neither.
40. In order to
create a one-to-many relationship, we can left-drag the reference
field
a.
of
the related table to that of the primary table.
b.
of
the primary query to that of the related query instead of a
table.
c.
Both.
d.
neither.
41. Which is
true about applying a filter?
a. the
result can be saved by "Save As Query" button either after or before applying a
filter.
b. the
filter must be advanced that can be created only by the “Advanced Filter/Sort”
button available
inside the Sort/Filter Group under the Create Tab instead of the Home
Tab..
c. both.
d. Neither way.
42. Which Group
is included in the Home Tab?
a.
Views
b.
Records
c.
Sort & Filter
d.
all above.
43. Which is
true about Relationship Button?
a.
it is available inside the DataBase Tools (or Datasheet)
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.
44. Which is
the primary object?
a.
reports
b.
queries
c.
tables
d.
none of above.
45. Each row of
a table represents
a.
a record
b.
a field
c.
an attribute
For
next two questions, Consider the following Filter being set
up:
Field| DAY
TIME
Sort |
descending
Criteria| TUESDAY
< 10AM OR > 6PM
OR |
MONDAY
46. Selected
records will include those
a. whose DAY
is MONDAY and whose TIME is 11AM.
b. whose DAY
is MONDAY and whose TIME is
5PM.
c. Both.
d.
Neither.
47. Selected records will
include those
a. whose DAY
is TUESDAY and whose TIME is 9AM.
b. whose DAY
is TUESDAY and whose TIME is 11AM.
c. Both.
d.
Neither.
********Next
15 questions are on POWERPOINT********.
48. A slide show can
be started by clicking
a. F2-key or ESC-key
b.
the ‘Slide Show View’ button
c.
both.
d.
neither.
49. In the
Slide Show view, which command does NOT function?
a.
CTRL-M
b. CTRL-S and CTRL-V
c. Both.
d.
Neither.
50. Which shows
the COLLAPSE and the PROMOTE commands?
a.
Slide Pane available in Normal View
b.
Formatting Pane available in Slide Show View
c. Outline Pane
available in Slide Sorter View
d. None
above.
51.
Which is
not to be shown to the audience during the slide show?
a. the
contents of Outline Pane
b. the
contents of Notes Page Pane
c.
neither.
52. Which View
lets you work either on the Slide Pane or on the Outline Pane with the same
results?
a.
Normal
View
b.
Slide
Sorter View
c. Slide
Show View
d.
None
53. During the
Slide Show, which is to get to the next slide?
a.
N-key
b. ENTER-Key
c. Right-clicking
d. all
above.
e. two
above.
54. Which is
the most suitable for splitting a slide into two?
a. the
“Collapse All” Command
b. the
“Promote” command
c.
the “Collapse” Command
55. The primary
difference between using the “link” and not using it when inserting an object
such as
Word file or Excel file is in
a.
having
the effect of changes to the source file directly reflected to the target
file.
b. having
the effect of changes to the target file directly reflected to the source
file.
c. Both.
d.
neither.
56. An
Organization Chart can be most conveniently created by inserting
a.
a Chart
b.
a Smartart Graphic
c.
Media Clips
57. Which
object can be imported to Powerpoint presentation?
a.
Word
documents
b.
Excel
worksheets
c. Both.
d. neither
58.
Which view is most suitable for rearranging the order of existing
slides?
a.
Normal View
b.
Slide Sorter View
c.
Notes Page
59. An object can be inserted
by
a.
creating new
b.
creating from (existing) file
c.
both.
d.
neither
60. Which transition type is available in
“Transition to This Slide” group under the Animation Tab?
a.
Fades and Dissolves
b.
Wipes and Random
c.
Push and Cover
d.
all above
e.
two above.
61. Which finishes a slide
show?
a.
F5-key
b.
ESC-key
c.
Enter-key
d.
two above
62. Which inserts a new
slide?
a.
CRTL-M
b.
the “New Slide” button available under the Insert Tab which also lets us
choose a slide layout
c.
F2-key
d.
all above
e.
two above