Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
The first step in creating a data capture control is to:
1)
A)
choose Tools, Toolbox, then Forms.
B)
choose View, Tools, then Control Toolbox.
C)
choose View, Tools, then Forms.
D)
choose Tools, View, then Control Toolbox.
2)
After drawing a control such as the drop–down menu, which command do you choose?
2)
A)
Format, Cells, then choose the Control tab.
B)
Format, Control, then choose the Control tab.
C)
Format, then Control.
D)
Right–click on the control, then choose Format.
3)
A combo box is another name for a:
3)
A)
drop–down menu.
B)
check box.
C)
list box.
D)
radio button.
4)
What is the command to begin a Macro?
4)
A)
Right–click on the cell, then choose Record.
B)
Choose Tools, Macro, Record Macro.
C)
Choose Tools, Macro, Record.
D)
Choose Tools, Macro, Record New Macro.
Explanation:
5)
The following are data–capture techniques except for:
5)
A)
radio buttons.
B)
drop–down menu.
C)
check box.
D)
talk box.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
The ________ toolbar displays the form choice icons.
6)
7)
Mouse clicks offer a way to easily capture complicated or extended amounts of ________.
7)
8)
It is important to know how to capture data in spreadsheets with ________.
8)
9)
The general format of the ________ function is to specify an index and then specify the
choices based on the index.
9)
10)
A drop–down menu, radio buttons, and a check box are used to ________ the user’s
choices.
10)
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
11)
The use of mouse clicks to capture data improves the quality and speed of data capture from the
user.
11)
12)
The control for the data capture techniques is created before values are specified.
12)
13)
The Control Toolbox is used for adding the data capture controls to the spreadsheet.
13)
D
14)
Making the same cell link for a group of radio buttons is what makes their choice mutually
exclusive.
14)
15)
Radio buttons can be created in any order.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
Why wouldn’t you want to execute a macro using a sequence of commands?
17)
How can macros be generated in Excel?
18)
What are the commands to stop recording a macro?
19)
Why are recording macros by keystrokes important to the manager?
20)
What do you do if your school has set macro security such that Excel does not want to run a spreadsheet with
macros?
3