Question 1

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

Accepted Answer

First, all of the possible input choices must be entered in to the spreadsheet. Second, the drop- down menus, radio buttons, and check boxes must then be inserted into the spreadsheet.

Question 2

Radio buttons can be created in any order.

Accepted Answer

A) True 
 B)False  False

Question 3

What is the command to begin a Macro?

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

A combo box is another name for a:

Accepted Answer

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

Question 7

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 9

What is the general expression for payments?

Accepted Answer

=PMT(inter

Question 10

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

Accepted Answer

The answer of  __________can be generated in Excel either...

Question 11

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

Accepted Answer

The answer of The datasheet that will supply the ...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of When saving a file, Excel will automatically...

Question 15

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

Accepted Answer

(1) It offers a way to easily

Question 16

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

Accepted Answer

The answer of The use of __________to capture data improves...

Question 17

A drop- down menu is also called a __________ .

Accepted Answer

The answer of A drop- down menu is also called...

Question 18

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?

Accepted Answer

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

Question 19

Why are recording macros by keystrokes important to the manager?

Accepted Answer

In order to achieve the efficiency of pr

Question 20

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

Accepted Answer

Recording keystrokes is an eff

Exam 18: Spreadsheets with Data Capture - Vacation Choice

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

Radio buttons can be created in any order.

What is the command to begin a Macro?

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

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

A combo box is another name for a:

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

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

What is the general expression for payments?

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

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

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

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

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

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

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

A drop- down menu is also called a __________ .

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?

Why are recording macros by keystrokes important to the manager?

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

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 - Movie Ticket Purchase

Database Forms and Reports

Database Queries - Customer Database

Database Queries - Inventory Database

Reports Based on Queries

Filters