Name _________________________ Date
___________
Systems
Analysis & DesignExcel 2002
Chapter 13
– Multiple Choice
Instructions: Circle the correct response.
1.
An information system called a(n)If you assign the
value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function
=IF(E5>4*F5,“Deductions”,“No deductions”), then cell G5 displays the message, ____________ is one that
was developed by the company that will use it.
a. in-house applicationDeductions
b. on-house
applicationNo deductions
c. CASE tools#REF!
d. software
packagesF5
2.
A(n)Use the ____________ functioncommand? when the value you want to assign to a cell is
dependent on a logical testis a set of components
that produce specific results.
a. serverASSIGNssign
b. systemIFf _THENhen_ELSElse
c. component WHAT IFhat_If
d. ITIFIf
3.
A(n) cell
reference of $B17 is a(n) ____________
is a system that can be adapted for use in many different types of companies.
a. IT
systemsolute
b. vertical systemlative
c. horizontal systemixed
d.
4.
The primary purpose of an information system is to ____________.
a. have fast computershorizontal
panes
b. have the newest softwarevertical
panes
c. provide valuable information to userspanes
d. all of the above of the
above
5.
A company that manufactures and sells products is called
a(n) cell E8 contains the label, Qtr 4, and you select
cell E8 and then drag the fill handle to the left, then cells D8, C8, and B8
will contain the labels ____________
company.
a.
I-commerce5, Qtr 6,
Qtr 7
b. B2C1, Qtr 2,
Qtr 3
c. service-oriented3, Qtr 3,
Qtr 1
d. product-orientedREF!
6.
The technique called ____________
allows inferences to be drawn from imprecise relationships.
a. expert systemsross hair
b. enterprise systemsrrow
c. fuzzy logicck plus
sign
d. empowermentplit double
arrow
7.
Knowledge management systems are called freeze
worksheet titles use the ___________ command on the ___________
because they simulate human reasoning by combining a knowledge base and
inference rules that determine how the knowledge is applied.
a. expert systemsplit,
Format
b. enterprise systemslit, Window
c. productivity systemseeze Panes,
Window
d. reasoning systemseeze Panes,
Tools
8.
displays the error message ____________ gives employees more
responsibility and accountability.
a. A User productivity system#####
b. Inference rules*****
c. GroupwareREF!
d. Empowerment
9.
can use the
Shadow button on the ____________
toolbar to add a drop shadow to a provides
a graphical representation of a concept or process that system developers can
analyze, test, and modify.
a. CASEandard
b. Modelingawing
c. Strategic planningrmatting
d. TPart
10.
A(n) change the
elevation of a selected pie chart, click ____________ describes
the design and protocols of telecommunications links the Chart
menu.
a.
object modelrmat Data
Series
b. process modelD View
c. network modelrmat 3-D
Pie Group
d. prototype model
Systems Analysis & Design Chapter 1 – True/False
Instructions: Circle T if the statement is true or F
if the statement is false.
|
T |
F |
1. IT refers to the software products and
services that companies use to manage, access, communicate, and share
information. |
|
T |
F |
2. Systems
analysis and design is a six step process for installing high-quality
information systems. |
|
T |
F |
3. Data is
information that has been transformed into output for users. |
|
T |
F |
4. A
mission-critical system is one that is vital to a company’s operations. |
|
T |
F |
5. |
|
T |
F |
6. A vertical
system is designed to meet the unique requirements of a specific business or
industry. |
|
T |
F |
7. A
service-oriented company primarily offers goods that it produces. |
|
T |
F |
8. TP processing
systems protect data integrity by ensuring that if any single element of a
transaction fails, the system does not process the rest of the transaction. |
|
T |
F |
9. Inference
rules are logical rules that identify data patterns and relationships. |
|
T |
F |
10. Object-oriented analysis combines data
and the processes that act on the data into things called process modules. |