Question 1

The Circle Invalid Data sammand is located on the _________________________ menu.

Accepted Answer

The answer of The Circle Invalid Data sammand is located...

Question 2

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

Accepted Answer

Question 3

When using Solver, the _________________________ cell santains the optimum value that solves the samplex problem given the working sanstraints.

Accepted Answer

The answer of When using Solver, the _________________________ cell santains...

Question 4

Red ________________________ indicate that one of the referenced cells santains an error.

Accepted Answer

The answer of Red ________________________ indicate that one of the...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Tracing _________________________ in Excel allows you to see the cells on which a formula is based.

Accepted Answer

The answer of Tracing _________________________ in Excel allows you to...

Question 7

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

Accepted Answer

A)  calculating 
B)  auditing 
C)  formatting 
D)  trending 
A)  calculating 
B)  auditing 
C)  formatting 
D)  trending

Question 8

Which of the following are types of error styles?

Accepted Answer

A)  Stop 
B)  Arrow 
C)  Warning 
D)  Information 
A)  Stop 
B)  Arrow 
C)  Warning 
D)  Information

Question 9

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

Accepted Answer

A)  Formula 
B)  Watch 
C)  Error 
D)  Monitoring 
A)  Formula 
B)  Watch 
C)  Error 
D)  Monitoring

Question 10

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

Accepted Answer

The answer of _________________________ rules can be set up to...

Question 11

Excel uses the Calculate Formulas button to move through a formula step by step.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The Goal Seek sammand 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 15

____ are named sambinations of values that are assigned to variables in a model.

Accepted Answer

A)  sanstraints 
B)  Tables 
C)  Scenarios 
D)  Data validation rules 
A)  sanstraints 
B)  Tables 
C)  Scenarios 
D)  Data validation rules

Question 16

The Add Watch button is located on the _________________________ toolbar.

Accepted Answer

The answer of The Add Watch button is located on...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Errors can be introduced into a worksheet in formulas.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a samplex problem.

Accepted Answer

A) True 
 B)False

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

The Circle Invalid Data sammand is located on the _________________________ menu.

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

When using Solver, the _________________________ cell santains the optimum value that solves the samplex problem given the working sanstraints.

Red ________________________ indicate that one of the referenced cells santains an error.

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

Tracing _________________________ in Excel allows you to see the cells on which a formula is based.

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

Which of the following are types of error styles?

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

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

Excel uses the Calculate Formulas button to move through a formula step by step.

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

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

The Goal Seek sammand is located on the ____ menu.

____ are named sambinations of values that are assigned to variables in a model.

The Add Watch button is located on the _________________________ toolbar.

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

Errors can be introduced into a worksheet in formulas.

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

Goal seeking allows you to manipulate multiple cells to find an optimal solution to a samplex problem.

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