Question 1

A Scenario Summary worksheet is not a useful decision-making tool.​

Accepted Answer

A) True 
 B)False

Question 2

To ensure that values in specific cells contain only nonnegative whole numbers,Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  place restrictions on values 
B)  provide a message to the user 
A)  place restrictions on values 
B)  provide a message to the user

Question 4

Which of the following is the path to the Error Checking button?

Accepted Answer

Question 5

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

Accepted Answer

A)  Max Time 
B)  Iterations 
C)  Constraint Precision 
D)  Use Automatic Scaling 
A)  Max Time 
B)  Iterations 
C)  Constraint Precision 
D)  Use Automatic Scaling

Question 6

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

Accepted Answer

A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary 
A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary

Question 7

You can use scenario auditing to review the formulas in a worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 8

Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.

Accepted Answer

A) True 
 B)False

Question 9

A cell containing a formula that references other cells is said to have ____.

Accepted Answer

A)  dependents 
B)  calculations 
C)  precedents 
D)  references 
A)  dependents 
B)  calculations 
C)  precedents 
D)  references

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

Accepted Answer

A) True 
 B)False

A Scenario Summary worksheet is not a useful decision-making tool.

To ensure that values in specific cells contain only nonnegative whole numbers,Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data.

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

Which of the following is the path to the Error Checking button?

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

You can use scenario auditing to review the formulas in a worksheet._________________________

Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.

A cell containing a formula that references other cells is said to have ____.

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

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

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

A Scenario Summary worksheet is not a useful decision-making tool.​

To ensure that values in specific cells contain only nonnegative whole numbers,Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data.

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

Which of the following is the path to the Error Checking button?

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

You can use scenario auditing to review the formulas in a worksheet._________________________

Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.

A cell containing a formula that references other cells is said to have ____.

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

Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

A Scenario Summary worksheet is not a useful decision-making tool.