Name _________________________ Date
___________
Instructions: Circle the correct response.
1.
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 the measure of a systems ability to expand and
change to meet the changing needs of business. .
a. TCODeductions
b. ScalabilityNo deductions
c. Technology#REF!
d. CentricF5
2.
Use Athe ____________
functioncommand? when the value you want to assign to a cell is
dependent on a logical teis typically an older system that usually runs on a main frame computer. st.
a. Web-centric systemASSIGNssign
b. serverIFf_THENhen_ELSElse
c. legacy system WHAT IFhat_If
d. database systemIFIf
3.
A ____________ is
a computer that supplies data, processing services,
or other support to one or more computers. A cell
reference of $B17 is a(n) ____________ cell
reference.
a. data centerabsolute
b. fat client systemrelative
c. clientmixed
d. serverinvalid
4.
In a You can use the Split command to split a window into ____________ design, an individual LAN client has a copy of the
application program installed locally, while the data is stored on a
centralized computer. .
a. file serverhorizontal
panes
b. LAN clienttwo vertical panes
c. LAN serverfour panes
d. Legacyof the
above
5.
A ____________
design locates all or most of the processing logic at the server..
a. fat clientQtr 5, Qtr 6, Qtr 7
b. thick clientQtr 1, Qtr 2, Qtr 3
c. thin clientQtr 3, Qtr 3, Qtr 1
d. server-client#REF!
6.
A(n) When copying a
range of cells using the drag and drop method, you first point to the border of
the selected range so that the mouse pointer changes to a (n) ____________ is an entrance to a
multifunctional Web site.
a. channelcross hair
b. portalarrow
c. switchblock plus sign
d. openingsplit double arrow
7.
A(n)o
freeze worksheet titles use the ___________ command
on the ___________ me handles transactions when and where
they occur and provides output directly to users. nu.
a. online system Split,
Format
b. batch systemSplit, Window
c. LAN systemFreeze Panes, Window
d. PSO systemFreeze Panes, Tools
8.
The way a network is configured is called ___________. o indicate when there is a cell reference error.
a. network centric######
b. network topology******
c. Star LAN#REF!
d. errLAN/WANor
9.
AYou
can use the Shadow button on the ____________ toolbar to
add a drop shadow to a network has a central computer with a
network of devices connected to it.
a. ringStandard
b. hubDrawing
c. busFormatting
d. starChart
10.
Which of the following is not part of a
system design specificationon the Chart menu?
a.
System Environmentrmat Data
Series
b. Implementation Requirements3-D View
c. Management SummaryFormat 3-D Pie Group
d. None of the above
Systems Analysis & Design Chapter 8 – True/False
Instructions: Circle T if the statement is true or F
if the statement is false.
|
T |
F |
1. Most companies engage in a process
called resource enterprise planning (REP) to establish a strategy for using
IT resources. |
|
T |
F |
2. A Web-centric
application can run on the Internet or a company intranet or extranet. |
|
T |
F |
3. While a LAN
can be useful, only a WAN can be called a distributed system. |
|
T |
F |
4. Because of current
technology, legacy data is very easy to access and transport to a
client/server environment. |
|
T |
F |
5. A thin client
is usually much faster because less network traffic is required. |
|
T |
F |
6. A network
allows the sharing of hardware, software, and data. |
|
T |
F |
7. In an OSI
model, the Display Layer provides for all displays to the user. |
|
T |
F |
8. A ring network
resembles a circle of computers that communicate with each other and is used
when processing is performed at local sites, rather then a central location. |
|
T |
F |
9. The term FTP
stands for File Transfer Protocol. |
|
T |
F |
10. RAID systems are called fault-tolerant,
because a failure of any one disk does not disable the system. |
Chart Type