Question 1

Using only a validation rule without ____ can frustrate users of the worksheet.

Accepted Answer

A)  an input message 
B)  an error alert message 
C)  either a or b 
D)  neither a nor b 
A)  an input message 
B)  an error alert message 
C)  either a or b 
D)  neither a nor b C

Question 2

The data validation rule called ____ value is the default setting for cells.

Accepted Answer

A)  Any 
B)  Whole number 
C)  Decimal 
D)  List 
A)  Any 
B)  Whole number 
C)  Decimal 
D)  List A

Question 3

VBA calls macros sub procedures, and starts each sub procedure name with Sub, followed by its descriptive name and a pair of ____________________.

Accepted Answer

parentheses
parens

Question 4

After you record a macro, you can run it in two ways: press the shortcut key assigned to the macro, or use the ____.

Accepted Answer

A)  Macro dialog box 
B)  Macro Wizard 
C)  Macro recent file pane 
D)  Macro status bar 
A)  Macro dialog box 
B)  Macro Wizard 
C)  Macro recent file pane 
D)  Macro status bar

Question 5

When you protect a workbook, you can secure the ____.

Accepted Answer

A)  workbook structure 
B)  workbook windows 
C)  both a and b 
D)  neither a nor b 
A)  workbook structure 
B)  workbook windows 
C)  both a and b 
D)  neither a nor b

Question 6

The formula auditing tool called Internal References allows you to step through a set of cells that directly or indirectly refer to themselves. _________________________

Accepted Answer

A) True 
 B)False

Question 7

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.

Accepted Answer

A)  Data Validation 
B)  Formulas 
C)  Data 
D)  View 
A)  Data Validation 
B)  Formulas 
C)  Data 
D)  View

Question 8

You can create an Excel macro by ____.

Accepted Answer

A)  using the macro recorder to record your keystrokes and mouse actions as you perform them 
B)  writing macros from scratch by entering VBA commands in the Visual Basic Editor 
C)  either a or b 
D)  neither a nor b 
A)  using the macro recorder to record your keystrokes and mouse actions as you perform them 
B)  writing macros from scratch by entering VBA commands in the Visual Basic Editor 
C)  either a or b 
D)  neither a nor b

Question 9

By default, input messages appear as comments ____ when the cell is selected.

Accepted Answer

A)  next to the cell 
B)  under the cell 
C)  on top of the cell 
D)  within the cell 
A)  next to the cell 
B)  under the cell 
C)  on top of the cell 
D)  within the cell

Question 10

False positives are items that are incorrect but are not flagged as such. _________________________

Accepted Answer

A) True 
 B)False

Question 11

You can protect a workbook by ____.

Accepted Answer

A)  locking cells so that users cannot change their contents 
B)  hiding cells so that users cannot see them 
C)  preventing a worksheet from being deleted from a workbook 
D)  all of the above 
A)  locking cells so that users cannot change their contents 
B)  hiding cells so that users cannot see them 
C)  preventing a worksheet from being deleted from a workbook 
D)  all of the above

Question 12

The Data Validation Rule called Text length restricts formulas to a specified length.

Accepted Answer

A) True 
 B)False

Question 13

When Excel runs a macro, it performs the actions specified by the macro's ____.

Accepted Answer

A)  VBA code 
B)  HTML code 
C)  Java code 
D)  FTP code 
A)  VBA code 
B)  HTML code 
C)  Java code 
D)  FTP code

Question 14

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

Accepted Answer

A) True 
 B)False

Question 15

The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.

Accepted Answer

•Fix obvious errors-If an error message

Question 16

Documentation can be descriptions of the system, checklists, flowcharts, and other hard-copy documents, as well as notations built into the system itself.

Accepted Answer

A) True 
 B)False

Question 17

To achieve a gross profit, an item's COGS should always be less than the sales price.

Accepted Answer

A) True 
 B)False

Question 18

Most of Excel's error-checking rules are disabled by default.

Accepted Answer

A) True 
 B)False

Question 19

One way to correct a macro is to run the macro one step at a time by opening the Macro dialog box, clicking the macro you want to delete, and then clicking the ____ button. After you identify the step causing the problems, record the macro again.

Accepted Answer

A)  Step Into 
B)  Step Out 
C)  Step Through 
D)  Step by Step 
A)  Step Into 
B)  Step Out 
C)  Step Through 
D)  Step by Step

Question 20

By default, every cell in a worksheet is unlocked.

Accepted Answer

A) True 
 B)False

Using only a validation rule without ____ can frustrate users of the worksheet.

The data validation rule called ____ value is the default setting for cells.

VBA calls macros sub procedures, and starts each sub procedure name with Sub, followed by its descriptive name and a pair of ____________________.

After you record a macro, you can run it in two ways: press the shortcut key assigned to the macro, or use the ____.

When you protect a workbook, you can secure the ____.

The formula auditing tool called Internal References allows you to step through a set of cells that directly or indirectly refer to themselves. _________________________

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.

You can create an Excel macro by ____.

By default, input messages appear as comments ____ when the cell is selected.

False positives are items that are incorrect but are not flagged as such. _________________________

You can protect a workbook by ____.

The Data Validation Rule called Text length restricts formulas to a specified length.

When Excel runs a macro, it performs the actions specified by the macro's ____.

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.

Documentation can be descriptions of the system, checklists, flowcharts, and other hard-copy documents, as well as notations built into the system itself.

To achieve a gross profit, an item's COGS should always be less than the sales price.

Most of Excel's error-checking rules are disabled by default.

One way to correct a macro is to run the macro one step at a time by opening the Macro dialog box, clicking the macro you want to delete, and then clicking the ____ button. After you identify the step causing the problems, record the macro again.

By default, every cell in a worksheet is unlocked.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Filters

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

Using only a validation rule without ____ can frustrate users of the worksheet.

The data validation rule called ____ value is the default setting for cells.

VBA calls macros sub procedures, and starts each sub procedure name with Sub, followed by its descriptive name and a pair of ____________________.

After you record a macro, you can run it in two ways: press the shortcut key assigned to the macro, or use the ____.

When you protect a workbook, you can secure the ____.

The formula auditing tool called Internal References allows you to step through a set of cells that directly or indirectly refer to themselves. _________________________

You use the Error Alert tab in the ____ dialog box to specify error alert styles and messages.

You can create an Excel macro by ____.

By default, input messages appear as comments ____ when the cell is selected.

False positives are items that are incorrect but are not flagged as such. _________________________

You can protect a workbook by ____.

The Data Validation Rule called Text length restricts formulas to a specified length.

When Excel runs a macro, it performs the actions specified by the macro's ____.

A(n) scenario support system is a type of information system that helps managers model business situations, especially through what-if analysis. _________________________

The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button; and examine the formula. Please briefly describe each of these steps.

Documentation can be descriptions of the system, checklists, flowcharts, and other hard-copy documents, as well as notations built into the system itself.

To achieve a gross profit, an item's COGS should always be less than the sales price.

Most of Excel's error-checking rules are disabled by default.

One way to correct a macro is to run the macro one step at a time by opening the Macro dialog box, clicking the macro you want to delete, and then clicking the ____ button. After you identify the step causing the problems, record the macro again.

By default, every cell in a worksheet is unlocked.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What-If Analysis

Enhancing Decision Making with Solver

Filters