Question 1

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

Accepted Answer

A)  input 
B)  error 
C)  data 
D)  data table

Question 2

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Show Formulas

Accepted Answer

A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5
F)(#6)
G)(#7)
H)(#8)
I)(#9)
J)(#10)
K)(#11)
L)(#12)

Question 3

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

Accepted Answer

A)  worksheet protection 
B)  workbook protection 
C)  file protection 
D)  data table protection

Question 4

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

The answer of The textbook suggested that before using the...

Question 5

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Trace Dependents

Accepted Answer

A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5
F)(#6)
G)(#7)
H)(#8)
I)(#9)
J)(#10)
K)(#11)
L)(#12)

Question 6

To reinforce the ____ rule, you can set up an error alert message for a cell.

Accepted Answer

A)  validation 
B)  step-through 
C)  data 
D)  input

Question 7

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 8

The formula auditing tool called ____ toggles between displaying formulas or results of formulas in the worksheet.

Accepted Answer

A)  Show Formulas 
B)  View Formulas 
C)  Trace Dependents 
D)  Watch Window

Question 9

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

Accepted Answer

A)  documentation 
B)  detailed 
C)  data table 
D)  protected

Question 10

A virus can harm your computer by changing your program settings, for example, or deleting files on your hard disk.

Accepted Answer

A) True 
 B)False

Question 11

____ tracer arrows indicate that a precedent cell contains an error.

Accepted Answer

A)  Blue 
B)  Red 
C)  Green 
D)  Orange

Question 12

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

Accepted Answer

A)  you have specified 
B)  Excel enters as a default 
C)  new users enter 
D)  none of the above

Question 13

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

Accepted Answer

A)  apostrophes 
B)  question marks 
C)  exclamation points 
D)  forward slashes

Question 14

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-Remove Arrows menu

Accepted Answer

A) (#1) 
B) (#2) 
C) (#3) 
D) (#4) 
E) (#5
F)(#6)
G)(#7)
H)(#8)
I)(#9)
J)(#10)
K)(#11)
L)(#12)

Question 15

You access the data validation tool by clicking the DATA tab on the ribbon, and then clicking Data Validation in the ____ group to open the Data Validation dialog box.

Accepted Answer

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

Question 16

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

Accepted Answer

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

Question 17

An error alarm is a message box that displays a message of varying severity. _________________________

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____ rule can specify a range of acceptable values, such as those between 1 and 100 or those in a particular list of values.

Accepted Answer

A)  validation 
B)  error 
C)  data 
D)  input

Question 19

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The ____ on the blue tracer arrow indicate that certain cells are precedent cells for other cells.

Accepted Answer

A)  solid circles 
B)  open circles 
C)  solid triangles 
D)  open triangles

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Show Formulas

You can use up to three levels of security and protection to control who can access and change your Excel data. These levels do NOT include ____.

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.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Trace Dependents

To reinforce the ____ rule, you can set up an error alert message for a cell.

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

The formula auditing tool called ____ toggles between displaying formulas or results of formulas in the worksheet.

A ____ worksheet usually contains the workbook title, creation date, name of the person who created the workbook, and any other information that describes the purpose and content of the workbook.

A virus can harm your computer by changing your program settings, for example, or deleting files on your hard disk.

____ tracer arrows indicate that a precedent cell contains an error.

If you set up the validation rule only, all future data entry in that cell is restricted to the values ____.

VBA interprets ____ as "ignore these lines of text" because these lines do not contain commands that Excel should perform.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Remove Arrows menu

You access the data validation tool by clicking the DATA tab on the ribbon, and then clicking Data Validation in the ____ group to open the Data Validation dialog box.

The Excel formula auditing tools help you troubleshoot formula problems by letting you review the ____ of a formula.

An error alarm is a message box that displays a message of varying severity. _________________________

A(n) ____ rule can specify a range of acceptable values, such as those between 1 and 100 or those in a particular list of values.

By default, input messages appear as comments next to the cell when the cell is selected. _________________________

The ____ on the blue tracer arrow indicate that certain cells are precedent cells for other cells.