Name _________________________ Date ___________

Systems Analysis & DesignExcel 2002 Project Chapter 43 – - Multiple Choice

Instructions: Circle the correct response.

1. 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, ____________ model shows what a system must do..

a. physicalDeductions
b. logicalNo deductions
c. System#REF!
d. EnterpriseF5

2. A(n)Use the ____________ diagram shows how the system transforms input data into useful information functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. entityASSIGNssign
b. relationshipIFf_THENhen_ELSElse
c. data flow WHAT IFhat_If
d. zeroIFIf

3. Which of the following wais not a relation type that can exist between entities?A cell reference of $B17 is a(n) ____________ cell reference.

a. one-to-oneabsolute
b. one-to-manyrelative
c. many-to-manyixed
d. many-to-oneinvalid

4. AYou can use the Split command to split a window into ____________ is a path for data to move from one part of an information system to another.

a. system flowtwo horizontal panes
b. data flowtwo vertical panes
c. system logicfour panes
d. transition pathall of the above

5. A process that has no input is called 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 ____________ process.

a. spontaneous generationQtr 5, Qtr 6, Qtr 7
b. black holeQtr 1, Qtr 2, Qtr 3
c. gray holeQtr 3, Qtr 3, Qtr 1
d. negative data flow#REF!

6. In a DFD, the symbol for an entity is theWhen 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. rectanglecross hair
b. squarearrow
c. diamondblock plus sign
d. ovalsplit double arrow

7. To freeze worksheet titles use the ___________ command on the ___________ memaintains consistency among a set of DVDs by ensuring that input and output data flows align properlynu.

a. LevelingSplit, Format
b. BalancingSplit, Window

c. Fronting eeze Panes, Window
d. IteratingFreeze Panes, Tools

8. AExcel displays the error message ____________ to is the term used to describe a central storehouse of information about a system’s dataindicate when there is a cell reference error.

a. data house######
b. data base******
c. data dictionary#REF!
d. errdata warehouseor

9. AYou can use the Shadow button on the ____________ toolbar to add a drop shadow to a ceis the smallest piece of data that has meaning with an information systemll.

a. recordStandard
b. structureDrawing
c. storeFormatting
d. data elementChart

10. Which of the following is not a logical structure inupon which modular design is based onTo? change the elevation of a selected pie chart, click ____________ on the Chart menu.

a. CalculationFormat Data Series
b. Sequence3-D View
c. SelectionFormat 3-D Pie Group
d. Iteration

Systems Analysis & Design Chapter 4 – True/False

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

T	F	1. Much like data flow diagrams, entity-relationship diagrams depict data and information flows.
T	F	2. A many-to-many relationship is usually abbreviated M:M.
T	F	3. A many-to-many relationship is different from the others because the event that links the two entities is actually a third entity that has its own characteristics.
T	F	4. A set of DFDs provides a logical model of what a system does, not how it does it.
T	F	5. A gray hole is a process that has at least one input and output, but the input is insufficient to produce the desired output.
T	F	6. One important convention for a DFD is to make sure you spread out each drawing on as many pages as you need.
T	F	7. A Diagram 0 doesn’t show any process or data flows, it’s used more as a title or introductory page.
T	F	8. When you explode a DFD, the higher-level diagram is called the parent diagram.
T	F	9. When using a bottom-up strategy for creating DFDs, you first identify all functional primitives, data stores, entities, and data flows.
T	F	10. A decision table shows a logical structure, with all possible combinations of conditions and resulting actions.

Chart Type