Exam 10: Troubleshooting Workbooks and Automating Excel Applications

Explore all topics

Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________

(True/False)

4.7/5

(89)

Question 141

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

(Multiple Choice)

4.8/5

(81)

Question 142

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

(Multiple Choice)

4.9/5

(71)

Question 143

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.

(Multiple Choice)

4.9/5

(90)

Question 144

When you choose ____, Excel allows all macros to run.

(Multiple Choice)

4.9/5

(67)

Question 145

To prevent users from storing inaccurate data in a worksheet, you can include a(n) ____.

(Multiple Choice)

4.9/5

(72)

Question 146

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

(Multiple Choice)

4.9/5

(83)

Question 147

Common formula errors include ____.

(Multiple Choice)

4.9/5

(81)

Question 148

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.

(Short Answer)

4.9/5

(69)

Question 149

An Error Alert button appears on tracer arrows and ____.

(Multiple Choice)

4.8/5

(84)

Question 150

Showing 141 - 150 of 150

Excel applications are workbooks that you design so that others can use them in a relatively error-free manner. _________________________

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

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

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.

When you choose ____, Excel allows all macros to run.

To prevent users from storing inaccurate data in a worksheet, you can include a(n) ____.

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

Common formula errors include ____.

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.

An Error Alert button appears on tracer arrows and ____.

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