Deck 18: Spreadsheets with Data Capture - Vacation Choice

Question 1

Drop- down menus, radio buttons, and check boxes are used to capture a user's choices.

Answer 1

True

Question 2

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?

A)=PMT(F1/12,F2,A8)
B)=PMT((F1/12),F2,A8)
C)=PMT(F1,F2,A8)
D)=PAYMENT(F1/12,F2,A8)

Answer 2

B

Question 3

The datasheet that will supply the _ values must be completed first.

Answer 3

data- capture

Question 4

A drop- down menu is also called a .

Question 5

The Control Toolbox is used for adding the data capture controls to the spreadsheet.

Question 6

The use of to capture data improves the quality and speed of data capture from the user.

Question 7

What are two reasons it is important to know how to capture data in spreadsheets with mouse clicks?

Question 8

What is the command to begin a Macro?

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.

Question 9

What are the advantages to recording the sequence of keystrokes performed by a user to create a macro?

Question 10

When saving a file, Excel will automatically add the _ extension to the file name.

Question 11

After drawing a control such as the drop- down menu, which command do you choose?

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.

Question 12

Making the same cell link for a group of radio buttons is what makes their choice mutually exclusive.

Question 13

What is the general expression for payments?

Question 14

The control for the data capture techniques is created before values are specified.

Question 15

Why does the use of mouse clicks to capture data require more effort when designing the spreadsheet?

Question 16

can be generated in Excel either by writing programming code or by recording the sequence of keystrokes performed by the user.

Question 17

A combo box is another name for a:

A)drop- down menu.
B)radio button.
C)list box.
D)check box.

Question 18

Why are recording macros by keystrokes important to the manager?

Question 19

Radio buttons can be created in any order.

Question 20

The first step in creating a data capture control is to:

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.