Name _________________________ Date
___________
Instructions: Circle the correct response.
1. Which of
the following is not a main type
of maintenance as discussedIf 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, ____________..
a. correctiveDeductions
b. adaptiveNo deductions
c. production#REF!
d. preventiveF5
2. Use A help desk is often called a(n)the ____________
functioncommand? when the value you want to assign to a cell is
dependent on a logical tebecause it is the first place users turn when they
need assistance.st.
a. help centerASSIGNssign
b. information centerIFf_THENhen_ELSElse
c. activity point WHAT IFhat_If
d. first responderIFIf
3. Which of
the following task is typically
handled by a help desk?A cell
reference of $B17 is a(n) ____________ cell
reference.
a. help a user recover damaged dataabsolute
b. offer tips for better operationrelative
c. show a user how to write a macromixed
d. all of the aboveinvalid
4. You can use the Split command to split a window into ____________ maintenance is
performed to fix errors.
a. Correctivetwo horizontal
panes
b. Adaptivetwo vertical
panes
c. Perfectivefour panes
d. Performanceall of the
above
5. If 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 ________________________ maintenance reduces the possibility of future system
failure..
a. CorrectiveQtr 5, Qtr 6, Qtr 7
b. PerfectiveQtr 1, Qtr 2, Qtr 3
c. PreventiveQtr 3, Qtr 3,
Qtr 1
d. Debug#REF!
6. 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 the process of tracking system releases..
a. Version controlcross hair
b. Creating a
baselinearrow
c. Tracking
controlblock plus
sign
d. Benchmarkingsplit double
arrow
7. ATo
freeze worksheet titles use the ___________ command
on the ___________ me is a formal
reference point that measures system
characteristics at a specific time. nu.
a. benchmarkSplit, Format
b. baselineSplit, Window
c. functionalFreeze Panes, Window
d. controlFreeze Panes,
Tools
8. Which of
the following describes
the amount of data that a system can transfer in a fixed time periodExcel displays
the error message ____________ t?o indicate
when there is a cell reference error.
a. Megabits######
b. Megabytes******
c. Bandwidth#REF!
d. errBaselineor
9. You can use the Shadow button on the ____________ is the
process that monitors current activity and performance
levels, anticipates future activity, and forecasts the resources neededtoolbar to add a drop shadow to a cell.
a. Capacity planningStandard
b. System
maintenanceDrawing
c. What-if analysisFormatting
d. Production
maintenanceChart
10. To change the
elevation of a selected pie chart, click ____________ include formal degrees, diplomas, or certificates granted by learning institutions to show a level of
education has been achieved
successfully. on the Chart
menu.
a. CredentialsFo rmat Data
Series
b. Certifications3-D View
c. ControlsFormat 3-D
Pie Group
d. bBoth
a & b
Systems Analysis &
Design Chapter 10 – True/False
Instructions: Circle T if
the statement is true or F if the statement is false.
|
T |
F |
1. A
systems analyst is like an internal consultant who provides guidance,
support, and training. |
|
T |
F |
2. The systems operation and support phase begins when a
system becomes operational and continues until the system reaches the end of
its useful life. |
|
T |
F |
3. Operational costs of a system include items such as
supplies, equipment rental, and software leases. |
|
T |
F |
4. The maintenance expenses of a system typically drop to
nothing as a system ages. |
|
T |
F |
5. Preventive maintenance results in decreased user
satisfaction and increased downtime. |
|
T |
F |
6. When a maintenance release method is used, all non-critical
changes are individually released as soon as they are ready. |
|
T |
F |
7. The product baseline describes the system at the
beginning of system operation. |
|
T |
F |
8. A benchmark is the overall time between a request for
system activity and the delivery of a response. |
|
T |
F |
9. Turnaround time measures the time between submitting a
request for information and the fulfillment of that request. |
|
T |
F |
10. All
maintenance activities increase dramatically during the final phase of
operations of an old system, as a replacement system is being developed. |
Chart Type