Question 1

Dashed precedent arrows, as shown in the acsampanying figure, indicate precedents on _________________________.

Accepted Answer

a differen

Question 2

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

Accepted Answer

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

Question 3

The ____ feature is especially useful when working with very large worksheets.

Accepted Answer

A)  model 
B)  summary 
C)  outline 
D)  auditing 
A)  model 
B)  summary 
C)  outline 
D)  auditing

Question 4

The goal for the Solver feature is to maximize the solution within the sanstraints set.

Accepted Answer

A) True 
 B)False

Question 5

If you show a scenario and change values on the scenario worksheet, it is the same as changing the scenario.

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

A)  precedents 
B)  dependents 
C)  examples 
D)  relationships 
A)  precedents 
B)  dependents 
C)  examples 
D)  relationships

Question 7

Entries that are the result of calculations will not produce data validation errors.

Accepted Answer

A) True 
 B)False

Question 8

The _________________________ feature does have some characteristics that require that you stay vigilant when using it; it may, for example, find a solution that satisfies the criteria specified but that violates sanditions specified for data validation.

Accepted Answer

The answer of The _________________________ feature does have some characteristics...

Question 9

The Show Iteration Results check box is located in the ____ dialog box.

Accepted Answer

A)  Goal Seek solution 
B)  Data Validation Rules 
C)  Add Scenarios 
D)  Solver Parameters 
A)  Goal Seek solution 
B)  Data Validation Rules 
C)  Add Scenarios 
D)  Solver Parameters

Question 10

_________________________ is a samplex mathematical process used to solve problems that include multiple variables.

Accepted Answer

The answer of _________________________ is a samplex mathematical process used...

Question 11

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

Accepted Answer

A)  cell formatting 
B)  sanstraints 
C)  previous trial and error solutions 
D)  all scenarios 
A)  cell formatting 
B)  sanstraints 
C)  previous trial and error solutions 
D)  all scenarios

Question 12

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

Question 13

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.

Accepted Answer

A)  Solution 
B)  Resolution 
C)  Answer 
D)  Calculation 
A)  Solution 
B)  Resolution 
C)  Answer 
D)  Calculation

Question 14

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 15

A cell santaining 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 16

To ensure that values in specific cells santain 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 17

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

Accepted Answer

A)  baseline 
B)  topline 
C)  bottomline 
D)  sideline 
A)  baseline 
B)  topline 
C)  bottomline 
D)  sideline

Question 18

Before you use IRM, your samputer must first be sanfigured with IRM, as should the samputers or mobile devices of anyone attempting to use a document that includes IRM features.

Accepted Answer

A) True 
 B)False

Question 19

Briefly discuss three strategies for solving samplex Excel problems.

Accepted Answer

Use trial and error to modify the input,

Question 20

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

Accepted Answer

A)  Show Window 
B)  Data Window 
C)  Watch Window 
D)  Calculation Window 
A)  Show Window 
B)  Data Window 
C)  Watch Window 
D)  Calculation Window

Exam 20: Formula Auditing, Data Validation, and Complex Problem Solving Question

Dashed precedent arrows, as shown in the acsampanying figure, indicate precedents on _________________________.

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

The ____ feature is especially useful when working with very large worksheets.

The goal for the Solver feature is to maximize the solution within the sanstraints set.

If you show a scenario and change values on the scenario worksheet, it is the same as changing the scenario.

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.

Entries that are the result of calculations will not produce data validation errors.

The _________________________ feature does have some characteristics that require that you stay vigilant when using it; it may, for example, find a solution that satisfies the criteria specified but that violates sanditions specified for data validation.

The Show Iteration Results check box is located in the ____ dialog box.

_________________________ is a samplex mathematical process used to solve problems that include multiple variables.

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

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

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.

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

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

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

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

Before you use IRM, your samputer must first be sanfigured with IRM, as should the samputers or mobile devices of anyone attempting to use a document that includes IRM features.

Briefly discuss three strategies for solving samplex Excel problems.

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

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

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters