Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
Which is the correct PMT function given that cell F1 contains the interest rate, cell F2 contains the #
of periods, cell A8 contains the present value, and monthly payments are to be made?
1)
A)
=PMT(F1/12,F2,A8)
B)
=PMT((F1/12),F2,A8)
C)
=PMT(F1,F2,A8)
D)
=PAYMENT(F1/12,F2,A8)
2)
After drawing a control such as the drop–down menu, which command do you choose?
2)
A)
Format, Control, then choose the Control tab.
B)
Format, then Control.
C)
Right–click on the control, then choose Format.
D)
Format, Cells, then choose the Control tab.
3)
The first step in creating a data capture control is to:
3)
A)
choose View, Tools, then Control Toolbox.
B)
choose Tools, View, then Control Toolbox.
C)
choose Tools, Toolbox, then Forms.
D)
choose View, Tools, then Forms.
4)
A combo box is another name for a:
4)
A)
drop–down menu.
B)
radio button.
C)
list box.
D)
check box.
Explanation:
5)
What is the command to begin a Macro?
5)
A)
Choose Tools, Macro, Record Macro.
B)
Choose Tools, Macro, Record.
C)
Choose Tools, Macro, Record New Macro.
D)
Right–click on the cell, then choose Record.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
The use of ________ to capture data improves the quality and speed of data capture from
the user.
6)
7)
________ can be generated in Excel either by writing programming code or by recording
the sequence of keystrokes performed by the user.
7)
8)
When saving a file, Excel will automatically add the ________ extension to the file name.
8)
9)
The datasheet that will supply the ________ values must be completed first.
9)
10)
A drop–down menu is also called a ________.
10)
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
11)
Radio buttons can be created in any order.
11)
12)
Drop–down menus, radio buttons, and check boxes are used to capture a user’s choices.
12)
13)
Making the same cell link for a group of radio buttons is what makes their choice mutually
exclusive.
13)
Explanation:
14)
The Control Toolbox is used for adding the data capture controls to the spreadsheet.
14)
15)
The control for the data capture techniques is created before values are specified.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
What are two reasons it is important to know how to capture data in spreadsheets with mouse clicks?
17)
Why does the use of mouse clicks to capture data require more effort when designing the spreadsheet?
18)
What are the advantages to recording the sequence of keystrokes performed by a user to create a macro?
19)
What is the general expression for payments?
20)
Why are recording macros by keystrokes important to the manager?
3