Name _________________________ Date
___________
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