back

 final exam answers

IT 4116 - Introduction to PC Software and Information Systems

Final Exam

May 17, 2005

 

The exam is one hour. Read all questions before starting.

STOP! Read the questions completely BEFORE you start the exam.

Multiple choice questions are indicated by a list of possible answers following the question. Each possible answer is preceded by either a radio button or a check box.

A radio button is a small white circle. When you click on it it turns black. Radio buttons allow only one choice from the set of possible answers; therefore, when you click on one button it clears any other checked button in that set. These are sample radio buttons:

A check box is a small white square. When you click on it you get a check mark in the box. You may click any, all, or none of the check boxes. You check all check boxes that apply. These are sample check boxes:

Short text answer have a text field. A text field is a longish white box. Type your answer in the box. You are limited in the amount of space you have for your answer. If you run out of space, type something shorter.

Long text answers use a text box. A text box is a long white box with scroll buttons on it. Type your answer in the box. There is essentially no limit to the amount of space, but remember that Shakespeare said "brevity is the soul of wit".

All answers are to be made on this web page. Please keep written answers short. There are no essay questions. Good luck.

 

Your name (required):

Your email address or (required):

Your student id (required):

 

Question 1

Microwave transmission is used in environments where installing physical transmission media is ____.

difficult or impossible and where line-of-sight transmission is unavailable
easy or promising and where line-of-sight transmission is unavailable
difficult or impossible and where line-of-sight transmission is available
easy or promising and where line-of-sight transmission is available

 

Question 2

Advantages of using a network include ____.

facilitating communications
sharing hardware and software
sharing data and information
all of the above

 

Question 3

Instant messaging (IM) ____.

is a real-time Internet communications service that notifies users when one or more people are online and then allows the exchange of messages
functions much like an answering machine, allowing callers to leave a voice message for the called party
enables users to talk to other people over the Internet
involves using video and computer technology to conduct a meeting between participants at geographically separate locations

 

Question 4

Groupware ____.

pis a real-time Internet communications service that notifies users when one or more people are online and then allows the exchange of messages
is software that helps people work together on projects and share information over a network
is a real-time Internet communications service that notifies users when one or more people are online and then allows the exchange of messages
is an area of the Web where users conduct written discussions about a particular subject

 

Question 5

An advertiser at a site usually pays based on the number of _____, which occur when a visitor moves to the advertiser's home page.

snap shots
click-throughs
slip-shots
brick-throughs

 

Question 6

Developing a website "in-house" requires a very _____ control over its retail site.

small financial outlay and gives the merchant total
large financial outlay but gives the merchant total
small financial outlay and gives the merchant no
large financial outlay but gives the merchant no

 

Question 7

Most businesses that engage in B2C e-commerce also participate in _____ e-commerce.

C2C
B2E
B2B
all of the above

 

Question 8

_____ is internet junk mail.

A banner ad
Spam
A revenue stream
A cookie

 

Question 9

Workers telecommute for all of the following reasons except to ____.

implement an unyielding, inflexible work schedule
reduce time and expense spent traveling
eliminate travel during unsafe weather conditions
provide a convenient, comfortable work environment

 

Question 10

Airline tickets can be ordered from any computer connected to the Web through an online ____ reservation service and made available at the airport or delivered directly to the door.

hotel
restaurant
travel
car rental

 

Question 11

Symptoms of computer addiction include all of the following except ____.

neglects family and friends
irritable when at the computer
unable to stop computer activity
problems at work or school

 

Question 12

In essence, ____ is long-distance health care and is used in such areas as medical training, research, collaboration, decision making, and treatment.

telemedicine
neural networking
simulation
green computing

 

Question 13

To prevent virus infection, take each of the following precautions except ____.

check all downloaded programs for viruses
never open an e-mail attachment unless it is from a trusted source
only enable macros if a document is from a trusted source
always start the computer with a floppy disk in drive A

 

Question 14

A ____ uses the language of an application that records a sequence of keystrokes and instructions in an application, such as word processing or spreadsheet, to hide virus code.

system virus
Trojan horse virus
file virus
macro virus

 

Question 15

A computer security plan should do all of the following except ____.

identify all information assets of an organiza
for each information asset, identify a person responsible for reimbursing the company
identify all security risks that may cause an information asset loss
for each risk, identify the safeguards that exist to detect, prevent, and recover from a loss

 

Question 16

In a three-generation backup policy, the ____ is the most recent copy of the file.

great-grandparent
grandparent
parent
child

 

Question 17

A Trojan horse ____.

modifies its program code each time it attaches itself to another program or file
is a malicious-logic program that copies itself repeatedly in memory or on a disk drive until no memory or disk space remains
is a malicious-logic program that hides within or looks like a legitimate program
infects a program file, but still reports the size and creation date of the original, uninfected program

 

Question 18

Many programs perform a(n) ____ that analyzes entered data to help ensure that it is correct.

validity check
relevance check
pertinence check
efficacy check

 

Question 19

With Microsoft ____, a popular spreadsheet program, users can model data and create what-if scenarios.

Word
Excel
PowerPoint
Access

 

Question 20

The database approach has all of the following advantages except ____.

improved data integrity
increased data redundancy
reduced development time
easier reporting

 

Question 21

A(n) ____ test verifies that all programs in an application work together properly.

data
systems
integration
acceptance

 

Question 22

A ____ is the liaison between the users and the IT professionals; that is, they convert user requests into technical specifications.

systems analyst
network administrator
vendor
steering committee

 

Question 23

A(n) ____ test verifies that an application works with other applications.

data
systems
integration
acceptance

 

Question 24

During ____ design, the systems analyst carefully designs every menu, screen, and report specified in the requirements.

database
input and output
program
documentation

 

Question 25

In MS Word, if a word you type is not in Word's dictionary, a _____ wavy underline displays below the word, and a red _____ displays on the Spelling and Grammar Checking Status icon.

green, check mark
green, X
red, check mark
red, X

 

Question 26

To scroll down one entire screenful at a time, _____.

click anywhere below the scroll box on the scroll bar
click the scroll arrow at the bottom of the scroll bar
press PAGE DOWN
both a and c

 

Question 27

When editing a header or footer text, the Header and Footer toolbar may be used to ___________.

insert AutoText
insert the time
insert the page number
all of the above

 

Question 28

How can you view header text?

switch to page layout view
display the document in print preview
in normal or outline view, click View on the menu bar and then click Header and Footer
all of the above

 

Question 29

To quit Excel, click the ____________.

Close button on the title ba
Control-menu icon on the menu bar
Close command on the File menu
all of the above

 

Question 30

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

ampersand (&)
equal sign (=)
number sign (#)
asterisk (*)

 

Question 31

If cell E5 contains 42, F5 contains 11, and cell G5 contains the function =E5 + F5,then cell G5 displays, ____________.

53
462
#REF!
F5

 

Question 32

To freeze worksheet titles use the ___________ command on the ___________ menu.

Split, Format
Split, Window
Freeze Panes, Window
Freeze Panes, Tools

 

Question 33
Extra Credit
doesn't burn rice

The brand name of this motorcycle is _____.

Honda
Suzuki
Yamaha
BMW

 

Additional Item
Enter any feedback you'd like to give on this exam, taking the exam on the 'net, or any other topic.
Thanks for being in the class.

 

Click SUBMIT to submit your exam. SUBMIT is final and irretrievable. Review your answers before clicking it.

If everything is all bollixed up, RESET will erase all answers you've entered in the form and let you start all over again.

 

                            

  

 final exam answers