Name _________________________ Date ___________

Systems Analysis & Design Excel 2002 ProjectChapter 23 – - Multiple Choice

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, ____________ planning is the process of identifying long-term organizational goals, strategies, and resources.

a. FeasibilityDeductions
b. StrategicNo deductions
c. Systems#REF!
d. ITF5

2. In a SWOT analysis, the S stands for Use the ____________ functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. SystemASSIGNssign
b. SoftwareIFf_THENhen_ELSElse
c. Strength WHAT IFhat_If
d. StudyIFIf

3. In aA SWOT analysis, the O stands forA cell reference of $B17 is a(n) ____________ cell reference.

a. Objectabsolute
b. Operationrelative
c. Objectionsmixed
d. OpportuniesOpportunitiesinvalid

4. Stakeholders in a company are which of the following? You can use the Split command to split a window into ____________.

a. Communitytwo horizontal panes
b. Supplierstwo vertical panes
c. Employeesfour panes
d. all of the above of the above

5. The starting point for a project is called a(n)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 ____________.

a. systems requestQtr 5, Qtr 6, Qtr 7
b. feasibility studyQtr 1, Qtr 2, Qtr 3
c. key performance indicatorQtr 3, Qtr 3, Qtr 1
d. project definition

#REF!

6. The coding of data to keep it safe from unauthorized users is called ___________ .

a. locking
b. hiding

c. shading
d. encryption

7. Which of the following is not an external factor that will affect a projecten 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) ____________?.

a. Customerscross hair
b. Existing Systemsarrow
c. Economyblock plus sign
d. Technologysplit double arrow

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

a. Split, Format
b. Split, Window

c. Freeze Panes, Window
d. Freeze Panes, Tools

8. Excel displays the error message ____________ tfeasibility means that a proposed system will be used effectively after it has been developedo indicate when there is a cell reference error.

a. Operational######
b. Technical******
c. Economic#REF!
d. Preliminaryerror

9. You can use the Shadow button on the ____________ can be measured in dollarstoolbar to add a drop shadow to a cell.

a. Tangible benefitsStandard
b. Intangible benefitsDrawing
c. Projected salesFormatting
d. Future growthChart

10. To change the elevation of a selected pie chart, click ____________ feasibility means that the projected benefits of a proposed system outweigh the estimated costson the Chart menu.

a. a. Operational Format Data Series
b. Technical3-D View
c. EconomicFormat 3-D Pie Group
d. Discretionary

Systems Analysis & Design Chapter 2 – True/False

Instructions: Circle T if the statement is true or F if the statement is false.

T	F	1. Strategic planning focuses on the day-to-day goals, strategies, and resources.
T	F	2. The T phase in a SWOT analysis stands for Technology.
T	F	3. A formal way to ask for an IT project is with a System Document.
T	F	4. A key internal factor that affects system projects are a company’s strategic plan.
T	F	5. Competition does not really factor into information systems decisions.
T	F	6. An intangible benefit to a system is a system that improves employee satisfaction.
T	F	7. The first step in evaluating feasibility is to identify and weed systems requests that are not feasible at all.
T	F	8. A nondiscretionary project is one that management has no choice in implementing.
T	F	9. A fish diagram is an analysis tool that represents the possible causes of a problem as a graphical outline.
T	F	10. The Project Creep is a process that defines when a project has a very general scope, and is at risk of gradually expanding.

C

hart Type