Name _________________________ Date ___________

System Analysis & DesignExcel 2002 Project Chapter 53 – - Multiple Choice

Instructions: Circle the correct response.

1. AIf 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, ____________ model uses a set fee based on a specific level of service and user support.

a. usageDeductions
b. fixed feeNo deductions
c. standard#REF!
d. subscriptionF5

2. A software package that can be used by many different types of organizations is called aUse the ____________ functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. standard applicationASSIGNssign
b. vertical applicationIFf_THENhen_ELSElse
c. horizontal applicationWHAT IFhat_If
d. VAR applicationIFIf

3. Which of the following is not a reason for purchasing a Software PackageA cell reference of $B17 is a(n) ____________ cell reference?.

a. Meet constraints of existing technologyabsolute
b. Lower costsrelative
c. Require less time to implementmixed
d. Future upgrades provided by the vendorinvalid

4. A file that can be viewed, but not changed is said to have You can use the Split command to split a window into ____________ properties.

a. hiddentwo horizontal panes
b. read-writetwo vertical panes
c. write-onlyfour panes
d. read-onlyall of the above

5. A 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 ____________ determines how long it takes an information system to pay for itself through reduced costs and increased benefits.

a. net present valueQtr 5, Qtr 6, Qtr 7
b. return on investmentQtr 1, Qtr 2, Qtr 3
c. payback analysisQtr 3, Qtr 3, Qtr 1
d. Information Systems analysis#REF!

6. A logical design 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) ____________defines the functions and features of the system, relationships among components, and ____________ .

a. what must take placecross hair
b. how it is to be accomplishedarrow
c. when it is to be finishedblock plus sign
d. all of the abovesplit double arrow

7. An early, rapidly constructed working version of a proposed information system is called To freeze a(n) worksheet titles use the ___________ command on the ___________ menu.

a. ROI systemSplit, Format
b. prototype Split, Window

c. RFQFreeze Panes, Window
d. 4GLFreeze Panes, Tools

8. Excel displays the error message ____________ to is a modeling tool that uses various symbols to identify input and output operations, represent data, and show mediaindicate when there is a cell reference error.

a. 4GL######
b. ANSI******
c. A CaseCASE tool#REF!
d. A systems flowcharterror

9. You can use the Shadow button on the ____________ toolbar to add a drop shadow to are numbers or letters that are assigned in a specific order cell.

a. Order codesStandard
b. Block codesDrawing
c. Sequence codesFormatting
d. Action codesChart

10. Which of the following is not a rule to be used when developing a codeTo change the elevation of a selected pie chart, click ____________ on the Chart menu?.

a. a. Keep codes conciseFormat Data Series
b. Make codes cryptic3-D View
c. Use sortable codesFormat 3-D Pie Group
d. Make codes unique

System Analysis & Design Chapter 5 – True/False

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

T	F	1. A Web-based application builds the application code into the Web.
T	F	2. In a Web-based systems development environment, system design is influenced by compatibility issues, including existing hardware and software platforms.
T	F	3. A fixed fee model for outsourcing uses a set fee based on a specified level of service and user support.
T	F	4. A key reason for In-House system development is that it requires less technical development staff.
T	F	5. The net present value (NPV) of a project is the total value of benefits minus the total value of costs, both adjusted to reflect the point in time at which they occur.
T	F	6. The goal of systems design is to build a system that is effective, reliable, and maintainable.
T	F	7. In a parameter query, a parameter is a hard-coded value that the user cannot modify.
T	F	8. A default value is a value that is automatically displayed by the system, and can be accepted or modified by the user.
T	F	9. In Modular Design, you create individual processing components, called modules, which connect to a higher-level program or process.
T	F	10. Self-checking codes distinguish items by using a series of subgroups of digits.

Chart Type