Question 1

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

Question 2

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

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

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

Accepted Answer

A)  error alert 
B)  alarm 
C)  caution 
D)  stop and look

Question 4

To allow users to edit some cells while preventing them from changing others, you ____ the cells you want users to access and then protect the worksheet.

Accepted Answer

A)  unlock 
B)  lock 
C)  protect 
D)  unprotect

Question 5

Macro ____ consist(s) of viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document.

Accepted Answer

A)  viruses 
B)  spyware 
C)  adware 
D)  shareware

Question 6

MATCHING
  
Identify the letter of the choice that best matches the tools listed above.
-formula auditing tools

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 7

Case 10-1
  
Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below.
-Under Assumptions, Elianna accidentally clears the entry for COGS, 300%, and she wants to recreate it. She only wants data entered as a percentage between 0 and 1. She also knows that several top managers throughout the company will be entering the data. What could Elianna do to guide them?

Accepted Answer

A)  Set up a new macro. 
B)  Display formulas. 
C)  Set COGS to 50. 
D)  Set up a validation rule.

Question 8

A trusted location is usually any computer that is used only by one person.

Accepted Answer

A) True 
 B)False

Question 9

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

Accepted Answer

A) True 
 B)False

Question 10

You can press the ____ keyboard combination to display the formula in the cell.

Accepted Answer

A)  Ctrl+` 
B)  Ctrl+F8 
C)  Ctrl+Tab 
D)  Ctrl+&

Question 11

If a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display the ____ button.

Accepted Answer

A)  Error Alert 
B)  Error Help 
C)  Error Wizard 
D)  Error Warning

Question 12

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

Accepted Answer

A) True 
 B)False

Question 13

The default setting for error alert messages is ____________________, which tells the user the entry is incorrect and must be canceled or corrected before continuing.

Accepted Answer

The answer of The default setting for error alert messages...

Question 14

When you trace dependent cells, you trace the components of a formula that references other cells.

Accepted Answer

A) True 
 B)False

Question 15

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

Accepted Answer

A)  workbook 
B)  worksheet 
C)  data table 
D)  user data

Question 16

____ data is input data for which you already know the results.

Accepted Answer

A)  Test 
B)  Complex 
C)  Scenario 
D)  Break-even

Question 17

A(n) ____________________ can specify the type of data that is appropriate to be entered into a cell, such as whole numbers, decimal numbers, dates, time, or text.

Accepted Answer

The answer of A(n) ____________________ can specify the type of...

Question 18

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

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 19

Hiding a row or column affects the data and any formulas that reference a hidden cell.

Accepted Answer

A) True 
 B)False

Question 20

____________________ are items that are flagged as incorrect but are, in fact, correct.

Accepted Answer

A) True 
 B)False

Exam 10: Troubleshooting Workbooks and Automating Excel Applications

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

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

In addition to a helpful message that appears before users enter data, you can also display a(n) ____ message in a message box if users enter data that violates the cell's validation rule.

To allow users to edit some cells while preventing them from changing others, you ____ the cells you want users to access and then protect the worksheet.

Macro ____ consist(s) of viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document.

MATCHING Identify the letter of the choice that best matches the tools listed above. -formula auditing tools

A trusted location is usually any computer that is used only by one person.

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open an infected document. _________________________

You can press the ____ keyboard combination to display the formula in the cell.

If a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display the ____ button.

An Excel application can be a DSS, a tool that helps managers or other users make decisions or solve problems.

The default setting for error alert messages is ____________________, which tells the user the entry is incorrect and must be canceled or corrected before continuing.

When you trace dependent cells, you trace the components of a formula that references other cells.

If you want to prohibit workbook users from adding, renaming, or deleting worksheets in a workbook, you can enable ____ protection.

____ data is input data for which you already know the results.

A(n) ____________________ can specify the type of data that is appropriate to be entered into a cell, such as whole numbers, decimal numbers, dates, time, or text.

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

Hiding a row or column affects the data and any formulas that reference a hidden cell.

____________________ are items that are flagged as incorrect but are, in fact, correct.