Name _________________________ Date ___________

System Analysis & DesignExcel 2002 Project Chapter 653 – - 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 contains data about people, places, things, or events that interact with a systemuses a set fee based on a specific level of service and user support.

a. tableusageDeductions
b. systemfixed feeNo deductions
c. structurestandard#REF!
d. DBAsubscriptionF5

2. A software package that can be used by many different types of organizations is called aUse the ____________ system consists of linked tables that form one overall data structure functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. databasestandard applicationASSIGNssign
b. file-orientedvertical applicationIFf_THENhen_ELSElse
c. file processinghorizontal applicationWHAT IFhat_If
d. structureVAR applicationIFIf

3. A ____________ stores relatively permanent data about an entity. Which of the following is not a reason for purchasing a Software PackageA cell reference of $B17 is a(n) ____________ cell reference?.

a. table fileMeet constraints of existing technologyabsolute
b. master fileLower costsrelative
c. work fileRequire less time to implementmixed
d. transaction fileFuture upgrades provided by the vendorinvalid

4. Which of the following is not an advantage of a DBMS?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. Scalabilityhiddentwo horizontal panes
b. Controlled redundancyread-writetwo vertical panes
c. Data independencewrite-onlyfour panes
d. less expensive hardware and softwareread-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 is responsible for DBMS management and support. benefits.

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

1. 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

6. The complete definition of a database, including descriptions of all fields, tables and relationships 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. super structureROI systemSplit, Format
b. structure diagramprototype Split, Window

c. DMLRFQFreeze Panes, Window
d. schema4GLFreeze Panes, Tools

7. A ____________ is a single characteristic or fact about an entity.

a. primary key
b. secondary key
c. field
d. record

8. A ____________ is a set of related fields that describe one instance.

a. combination-field
b. record
c. multi-valued key
d. primary key

9. A table design that contains a repeating group is called 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. 4GunnormalizedL######
b. ANSnormalizedI******
c. repeating key formA Case tool#REF!
d. functionally dependent A systems flowcharterror

10. A You can use the Shadow button on the ____________ toolbar to add a drop shadow to are is a set of field values that describes a single person, place, thing or eventnumbers or letters that are assigned in a specific order cell.

a. pOrder codeshysical recordStandard
b. logical recordBlock codesDrawing
c. primary key recordSequence codesFormatting
d. data itemAction codesChart

Systems Analysis & Design Chapter 6 – True/False

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

T	F	1. Compared to a file processing system, a database system offers greater flexibility and efficiency.
T	F	2. One feature of a database system is that is has a very rigid data structure.
T	F	3. In a file processing system, a history file is created for historical or archiving purposes.
T	F	4. A DBMS is less complex then a file processing system, and the learning curve is usually shorter.
T	F	5. An Extranet is a private company owned network used to provide Web-based access to internal users only.
T	F	6. Middleware is software that integrates different applications and allows them to exchange data.
T	F	7. There are five types of key fields used to organize and maintain data structures; primary keys, secondary keys, foreign keys, regular keys, and match keys.
T	F	8. A foreign key is a field in one table that must match a primary key value in another table in order to establish a relationship between two tables.
T	F	9. A secondary key is a field that can be used to access or retrieve records and must be a unique value.
T	F	10. A single bit can have one of three possible values: 0, 1, or 2.

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. Keep codes conciseFormat Data Series
b. Make codes cryptic3-D View
c. Use sortable codesFormat 3-D Pie Group
d. Make codes uniqueChart Type