Question 1

A(n) ____________________ is a series of commands that you store and then run when you need to perform a task.

Accepted Answer

The answer of A(n) ____________________ is a series of commands...

Question 2

A(n) ____________________ cell contains a value that is used in a formula in the active cell.

Accepted Answer

The answer of A(n) ____________________ cell contains a value that...

Question 3

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

Accepted Answer

A) True 
 B)False

Question 4

You should protect your entire workbook file with a(n) passkey for optimal security. _________________________

Accepted Answer

A) True 
 B)False

Question 5

To work with advanced macro features, the ____ tab must be displayed on the ribbon.

Accepted Answer

A)  DEVELOPER 
B)  FORMULAS 
C)  VBA 
D)  PROGRAMMING 
A)  DEVELOPER 
B)  FORMULAS 
C)  VBA 
D)  PROGRAMMING

Question 6

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

To unprotect a workbook, on the REVIEW tab on the ribbon, click the Protect Workbook button in the ____ group, and then deselect the necessary check boxes.

Accepted Answer

A)  Changes 
B)  Format 
C)  What-if 
D)  Data 
A)  Changes 
B)  Format 
C)  What-if 
D)  Data

Question 8

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. 
A)  Set up a new macro. 
B)  Display formulas. 
C)  Set COGS to 50. 
D)  Set up a validation rule.

Question 9

Cell formula printouts also serve as a backup for workbooks.

Accepted Answer

A) True 
 B)False

Question 10

MATCHING
   
Identify the letter of the choice that best matches the tools listed above.
-Watch Window

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

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

Accepted Answer

A) True 
 B)False

Question 12

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 
A)  Error Alert 
B)  Error Help 
C)  Error Wizard 
D)  Error Warning

Question 13

MATCHING
   
Identify the letter of the choice that best matches the tools listed above.
-Circular References

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

The following types of documentation are helpful in an Excel application: ____.

Accepted Answer

A)  step-by-step instructions for entering data and performing calculations 
B)  notes or comments that define terms, explain calculations, and describe assumptions 
C)  notes or comments that identify the source of data, such as another workbook, a database, or a Web page 
D)  all of the above 
A)  step-by-step instructions for entering data and performing calculations 
B)  notes or comments that define terms, explain calculations, and describe assumptions 
C)  notes or comments that identify the source of data, such as another workbook, a database, or a Web page 
D)  all of the above

Question 15

When text is included inside quotation marks, it is treated as a ____.

Accepted Answer

A)  text string 
B)  formula 
C)  value 
D)  function 
A)  text string 
B)  formula 
C)  value 
D)  function

Question 16

When #DIV/0! appears in a cell, you know that a formula is trying to divide by the value 10, which cannot be done. _________________________

Accepted Answer

A) True 
 B)False

Question 17

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 
A)  Data Tools 
B)  Data 
C)  View 
D)  Formulas

Question 18

You can create a macro that can ____.

Accepted Answer

A)  display the formulas in a workbook 
B)  print the workbook in landscape orientation 
C)  show row and column headings on the printout 
D)  all of the above 
A)  display the formulas in a workbook 
B)  print the workbook in landscape orientation 
C)  show row and column headings on the printout 
D)  all of the above

Question 19

You control how Excel handles macros that are not stored in trusted locations by choosing Macro Settings in the ____.

Accepted Answer

A)  Trust Center 
B)  Security Center 
C)  Control Panel 
D)  Help Center 
A)  Trust Center 
B)  Security Center 
C)  Control Panel 
D)  Help Center

Question 20

All Excel ____________________, including the ones you record, consist of VBA code.

Accepted Answer

The answer of All Excel ____________________, including the ones you...

A(n) ____________________ is a series of commands that you store and then run when you need to perform a task.

A(n) ____________________ cell contains a value that is used in a formula in the active cell.

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

You should protect your entire workbook file with a(n) passkey for optimal security. _________________________

To work with advanced macro features, the ____ tab must be displayed on the ribbon.

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

To unprotect a workbook, on the REVIEW tab on the ribbon, click the Protect Workbook button in the ____ group, and then deselect the necessary check boxes.

Cell formula printouts also serve as a backup for workbooks.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Watch Window

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

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

MATCHING Identify the letter of the choice that best matches the tools listed above. -Circular References

The following types of documentation are helpful in an Excel application: ____.

When text is included inside quotation marks, it is treated as a ____.

When #DIV/0! appears in a cell, you know that a formula is trying to divide by the value 10, which cannot be done. _________________________

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.

You can create a macro that can ____.

You control how Excel handles macros that are not stored in trusted locations by choosing Macro Settings in the ____.

All Excel ____________________, including the ones you record, consist of VBA code.

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

A(n) ____________________ is a series of commands that you store and then run when you need to perform a task.

A(n) ____________________ cell contains a value that is used in a formula in the active cell.

An Error Alert button names the type of error, and lets you access the Excel Help tool or edit the formula in the Format Bar. _________________________

You should protect your entire workbook file with a(n) passkey for optimal security. _________________________

To work with advanced macro features, the ____ tab must be displayed on the ribbon.

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

To unprotect a workbook, on the REVIEW tab on the ribbon, click the Protect Workbook button in the ____ group, and then deselect the necessary check boxes.

Cell formula printouts also serve as a backup for workbooks.

MATCHING Identify the letter of the choice that best matches the tools listed above. -Watch Window

Cells with comments have blue indicator triangles in the upper-right corner. _________________________

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

MATCHING Identify the letter of the choice that best matches the tools listed above. -Circular References

The following types of documentation are helpful in an Excel application: ____.

When text is included inside quotation marks, it is treated as a ____.

When #DIV/0! appears in a cell, you know that a formula is trying to divide by the value 10, which cannot be done. _________________________

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.

You can create a macro that can ____.

You control how Excel handles macros that are not stored in trusted locations by choosing Macro Settings in the ____.

All Excel ____________________, including the ones you record, consist of VBA code.

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