Name _________________________                                                Date ___________

Systems Analysis & DesignExcel 2002 Chapter 73 – Multiple Choice

Instructions: Circle the correct response.

 

1.       Initial screen designs are usually presented to use in the form of 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, ____________ which is a sketch that shows general layout and design..

a. storybookDeductions
b. storyboardNo deductions
c. proto-board#REF!
d. interface boardF5

2.       Use Which of the following is not a guideline for designing a user interface?  the ____________  functioncommand? when the value you want to assign to a cell is dependent on a logical test.

a. Focus on the basic objective.ASSIGNssign
b. Minimize input data problems.IFf_THENhen_ELSElse
c. Use new high tech images and terms. WHAT IFhat_If
d. Create an attractive layout and design.IFIf

3.       When designing a user interface, ____________ focuses on how the interface can be made attractive and easy to use. cell reference of $B17 is a(n) ____________ cell reference.

a. ergonomicsbsolute
b. aestheticsrelative
c. technologymixed
d. efficiencyinvalid

4.       A(n)You can use the Split command to split a window into ____________ are templates or patterns that make it easier for users to enter data.

a. input masktwo horizontal panes
b. custom masktwo vertical panes
c. data set maskfour panes
d. access templateof the above

5.       A(n) ____________ initiates an action such as printing a form or requesting Help..

a. toolbarQtr 5, Qtr 6, Qtr 7
b. menu barQtr 1, Qtr 2, Qtr 3
c. Action BarQtr 3, Qtr 3, Qtr 1
d. Command button#REF!

6.       A main form called a 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) ____________ uses Command buttons that enable users to navigate the system and select from groups of related tasks.

a. Base Menucross hair
b. Storyboardarrow
c. Menuizerblock plus sign
d. Switchboardsplit double arrow

7.       freeze worksheet titles use the ___________ command on the ___________ me is data entry which is performed on a specified time schedule.nu.

a. Online inputSplit, Format
b. Offline inputSplit, Window

c. Batch inputFreeze Panes, Window
d. Data save inputFreeze Panes, Tools

8.       A ____________ improves data input quality by testing the data and rejecting any entry that fails to meet specified conditions.o indicate when there is a cell reference error.

a. data type check######
b. sequence check******
c. reasonability check#REF!
d. errall of the aboveor

9.       AYou can use the Shadow button on the ____________ toolbar to add a drop shadow to a report produces one or more lines of output for each record processed.

a. summaryStandard
b. detailDrawing
c. expandedFormatting
d. productionChart

10.    ATo change the elevation of a selected pie chart, click ____________ usually appears at the beginning of a report and identifies the reporton the Chart menu.

a.       report headerFo rmat Data Series
b. report footer3-D View
c. page headerFormat 3-D Pie Group
d. page footer

 

 

 

 

 

Systems Analysis & Design Chapter 7 – True/False

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

 

T

F

1. A user interface consists entirely of the software and functions used to communicate to users.

T

F

2. Human-computer interaction (HCI) describes the relationship between computers and the people who use them to perform tasks.

T

F

3. To develop a user-centered interface, the designer must learn to think like a user and see the system through a user’s eyes.

T

F

4. A drop-down box is used to select one or more choices from a group.

T

F

5. Data entry is the process of manually entering data into an information system.

T

F

6. Range checking is a test done on input to make sure the data item fits the required data type.

T

F

7. Input control includes the necessary measures to ensure that the input data is correct, complete, and secure.

T

F

8. A recovery trail is used to trace input data back to the source that input it.

T

F

9. An exception report displays only those records that meet a specific condition or conditions.

T

F

10. A mono-based report uses a single monospaced character set and is printed by a dot matrix printer.

 

 

Chart Type