Question 1

The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

Accepted Answer

A) True 
 B)False

Question 2

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Accepted Answer

A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions 
A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions

Question 3

_________________________ will try many possible solutions to find one that solves the problem subject to the constraints placed on the data.

Accepted Answer

The answer of _________________________ will try many possible solutions to...

Question 4

Which of the following is the path to the 'Remove All Arrows' arrow?

Accepted Answer

Question 5

The Goal Seek command is located on the ____ menu.

Accepted Answer

A)  What-If Analysis 
B)  Problem Solving Tools 
C)  Calculation Settings 
D)  none of the above 
A)  What-If Analysis 
B)  Problem Solving Tools 
C)  Calculation Settings 
D)  none of the above

Question 6

Case 9-1
You are presenting a two-hour seminar on using Excel features to professionals at an annual convention of accounting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break.
-On her way to the break room, one of the participants stops to ask you how she can improve her efficiency when working with unfamiliar workbooks sent to her from accounting personnel located in different branch offices. You suggest that ____.

Accepted Answer

A)  she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured 
B)  she ask each branch office accountant to also send an outline document describing all the formulas and other features included in each workbook 
C)  unfortunately, Excel does not have any built-in tools she can use to become more familiar with the workbooks she receives 
D)  she ask the branch office accountants to send her all the necessary information so that she can create her own workbooks 
A)  she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured 
B)  she ask each branch office accountant to also send an outline document describing all the formulas and other features included in each workbook 
C)  unfortunately, Excel does not have any built-in tools she can use to become more familiar with the workbooks she receives 
D)  she ask the branch office accountants to send her all the necessary information so that she can create her own workbooks

Question 7

Which of the following is NOT an issue that must be kept in mind when using Solver?

Accepted Answer

A)  The constraints may be constructed so that an answer that satisfies all of them cannot be found 
B)  Multiple answers might solve the problem 
C)  Some problems do not have solutions 
D)  Constraint precision is incompatible with most forms of automatic scaling 
A)  The constraints may be constructed so that an answer that satisfies all of them cannot be found 
B)  Multiple answers might solve the problem 
C)  Some problems do not have solutions 
D)  Constraint precision is incompatible with most forms of automatic scaling

Question 8

Obvious formula errors in a worksheet are indicated by a(n) ____ in the cell that contains the formula.

Accepted Answer

A)  error code, such as #/DIV0! 
B)  series of pound signs (#####) 
C)  green triangle 
D)  blue square 
A)  error code, such as #/DIV0! 
B)  series of pound signs (#####) 
C)  green triangle 
D)  blue square

Question 9

Which of the following are methods or tools you can use to solve complex worksheet problems?

Accepted Answer

A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation 
A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation

Question 10

You can use _________________________ to manage two sets of Solver data.

Accepted Answer

The answer of You can use _________________________ to manage two...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

You should name ranges for all input variables before creating your first scenario.

Accepted Answer

A) True 
 B)False

The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

_________________________ will try many possible solutions to find one that solves the problem subject to the constraints placed on the data.

Which of the following is the path to the 'Remove All Arrows' arrow?

The Goal Seek command is located on the ____ menu.

Which of the following is NOT an issue that must be kept in mind when using Solver?

Obvious formula errors in a worksheet are indicated by a(n) ____ in the cell that contains the formula.

Which of the following are methods or tools you can use to solve complex worksheet problems?

You can use _________________________ to manage two sets of Solver data.

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

You should name ranges for all input variables before creating your first scenario.

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

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

The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

_________________________ will try many possible solutions to find one that solves the problem subject to the constraints placed on the data.

Which of the following is the path to the 'Remove All Arrows' arrow?

The Goal Seek command is located on the ____ menu.

Which of the following is NOT an issue that must be kept in mind when using Solver?

Obvious formula errors in a worksheet are indicated by a(n) ____ in the cell that contains the formula.

Which of the following are methods or tools you can use to solve complex worksheet problems?

You can use _________________________ to manage two sets of Solver data.

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

You should name ranges for all input variables before creating your first scenario.

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