Deck 19: Spreadsheets with Data Capture - Movie Ticket Purchase

Question 1

Why are recording macros by keystrokes important to the manager?

Answer 1

In order to achieve the efficiency of processing, avoid mistakes, and enable subordinates with little training to accomplish the same results, you can record the sequence of steps in a macro that can be run later with the click of a mouse.

Question 2

A combo box is another name for a:

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

Answer 2

A

Question 3

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

Answer 3

False

Question 4

A drop- down menu, radio buttons, and a check box are used to _ the user's choices.

Question 5

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

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.

Question 6

Why wouldn't you want to execute a macro using a sequence of commands?

Question 7

The general format of the function is to specify an index and then specify the choices based on the index.

Question 8

It is important to know how to capture data in spreadsheets with _.

Question 9

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

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.

Question 10

The toolbar displays the form choice icons.

Question 11

Radio buttons can be created in any order.

Question 12

What do you do if your school has set macro security such that Excel does not want to run a spreadsheet with macros?

Question 13

How can macros be generated in Excel?

Question 14

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

Question 15

Mouse clicks offer a way to easily capture complicated or extended amounts of .

Question 16

The following are data- capture techniques except for:

A)radio buttons.
B)drop- down menu.
C)check box.
D)talk box.

Question 17

What are the commands to stop recording a macro?

Question 18

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

Question 19

What is the command to begin a Macro?

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.

Question 20

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