Exam 10: Formula Auditing, Data Validation, and Complex Problem Solving

Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.

(Multiple Choice)

4.9/5

(38)

Question 61

Errors can be introduced into a worksheet in formulas.

(True/False)

4.9/5

(28)

Question 62

Tracing precedents in Excel is accomplished by tapping or clicking the Trace Precedents button in the _________________________ group on the FORMULAS tab.

(Short Answer)

4.8/5

(29)

Question 63

Which of the following actions can you perform using data validation rules?

(Multiple Choice)

4.8/5

(37)

Question 64

The _________________________ should be used before sharing a workbook publicly or when you suspect extraneous information remains in the workbook.

(Short Answer)

4.9/5

(38)

Question 65

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

(Multiple Choice)

4.8/5

(25)

Question 66

The Simplex LP solving method uses geometric progression to solve problems.

(True/False)

4.9/5

(37)

Question 67

Which of the following is not a primary use of the Scenario Manager?

(Multiple Choice)

4.9/5

(34)

Question 68

-As shown in the accompanying figure, Solver allows you to set a constraint that includes a cell reference followed by a(n) ____.

(Multiple Choice)

4.8/5

(33)

Question 69

The ____ error code indicates that a cell reference in a formula is not valid.

(Multiple Choice)

4.9/5

(34)

Question 70

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' command.

(Multiple Choice)

4.9/5

(42)

Question 71

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A cell that references another cell.

(Multiple Choice)

4.9/5

(36)

Question 72

After you display precedent arrows, you must remove them level by level.

(True/False)

4.7/5

(27)

Question 73

PivotTables summarize large amounts of data, and can be rearranged and regrouped to show the data in various forms.

(True/False)

4.7/5

(34)

Question 74

_________________________ rules can be set up to display prompts and error messages when users select a cell or enter invalid data.

(Short Answer)

4.8/5

(29)

Question 75

An Answer Report shows original and final values of the target cell and changing cells plus ____.

(Multiple Choice)

4.7/5

(33)

Question 76

When a cell contains a(n) ____ reference, it means that one of its defining values is itself.

(Multiple Choice)

4.7/5

(36)

Question 77

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

(True/False)

4.9/5

(32)

Question 78

A Solver constraint that is binding is one that limits the final solution in some way.

(True/False)

4.8/5

(32)

Question 79

Which of the following is the path to the Trace Precedents button?

(Multiple Choice)

4.7/5

(34)

Question 80

Showing 61 - 80 of 112

Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.

Errors can be introduced into a worksheet in formulas.

Tracing precedents in Excel is accomplished by tapping or clicking the Trace Precedents button in the _________________________ group on the FORMULAS tab.

Which of the following actions can you perform using data validation rules?

The _________________________ should be used before sharing a workbook publicly or when you suspect extraneous information remains in the workbook.

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

The Simplex LP solving method uses geometric progression to solve problems.

Which of the following is not a primary use of the Scenario Manager?

-As shown in the accompanying figure, Solver allows you to set a constraint that includes a cell reference followed by a(n) ____.

The ____ error code indicates that a cell reference in a formula is not valid.

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' command.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A cell that references another cell.

After you display precedent arrows, you must remove them level by level.

PivotTables summarize large amounts of data, and can be rearranged and regrouped to show the data in various forms.

_________________________ rules can be set up to display prompts and error messages when users select a cell or enter invalid data.

An Answer Report shows original and final values of the target cell and changing cells plus ____.

When a cell contains a(n) ____ reference, it means that one of its defining values is itself.

Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution.

A Solver constraint that is binding is one that limits the final solution in some way.

Which of the following is the path to the Trace Precedents button?

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters