Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

Choose the "Tools" command followed by "Macro" and "Security" to set the security level to medium.

Question 3

The___________ toolbar displays the form choice icons.

Accepted Answer

Forms

Question 4

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

Accepted Answer

The answer of A drop- down menu, radio buttons, and...

Question 5

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

Accepted Answer

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. 
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

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

Accepted Answer

A) True 
 B)False

Question 7

Why are recording macros by keystrokes important to the manager?

Accepted Answer

In order to achieve the efficiency of pr

Question 8

What is the command to begin a Macro?

Accepted Answer

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. 
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 9

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

Accepted Answer

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. 
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 following are data- capture techniques except for:

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of Mouse clicks offer a way to easily...

Question 12

Radio buttons can be created in any order.

Accepted Answer

A) True 
 B)False

Question 13

What are the commands to stop recording a macro?

Accepted Answer

Choose the "Tools" c

Question 14

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

Accepted Answer

The answer of The general format of the___________ function is...

Question 15

How can macros be generated in Excel?

Accepted Answer

Macros can be generated in Exc

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A combo box is another name for a:

Accepted Answer

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

Question 18

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

Accepted Answer

The answer of It is important to know how to...

Question 19

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

Accepted Answer

That would defy the

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 19: Spreadsheets with Data Capture - Movie Ticket Purchase

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

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

The___________ toolbar displays the form choice icons.

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

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

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

Why are recording macros by keystrokes important to the manager?

What is the command to begin a Macro?

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

The following are data- capture techniques except for:

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

Radio buttons can be created in any order.

What are the commands to stop recording a macro?

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

How can macros be generated in Excel?

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

A combo box is another name for a:

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

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

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

Introduction to Information Systems

Information Systems for Competitive Advantage

Using Information Technology to Engage in Electronic Commerce

System Users and Developers

Computing and Communications Resources

Database Management Systems

Systems Development

Information in Action

Information Security

Ethical Implications of Information Technology

Decision Support Systems

Everyday Technology Skills

Web/HTML Project Using Microsoft FrontPage

Web/HTML Project Using Notepad

Web/HTML Student Survey

Web/HTML Book Purchase

Spreadsheet Basics

Spreadsheets with Data Capture - Vacation Choice

Database Forms and Reports

Database Queries - Customer Database

Database Queries - Inventory Database

Reports Based on Queries

Filters