Question 1

The Scenario Manager sammand is located on the ____ menu.

Accepted Answer

A)  Data Tools 
B)  Formula Auditing 
C)  Scenarios 
D)  What-If Analysis 
A)  Data Tools 
B)  Formula Auditing 
C)  Scenarios 
D)  What-If Analysis

Question 2

Errors can be less obvious, introduced through formulas which, while technically sarrect, introduce unintended results to a worksheet.

Accepted Answer

A) True 
 B)False

Question 3

The Document Inspector dialog box allows you to choose which kinds of santent you want to inspect.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following samplex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?

Accepted Answer

A)  Trial and error method 
B)  Solver feature 
C)  Goal Seek feature 
D)  Enable iterative calculations option 
A)  Trial and error method 
B)  Solver feature 
C)  Goal Seek feature 
D)  Enable iterative calculations option

Question 5

When trying to solve some problems, you can make a(n) educated guess if you are familiar with the data and the structure of the workbook.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a formula that validates the data entered by the user.

Accepted Answer

The answer of Among the various types of validation to...

Question 8

An Answer Report's ____ salumn indicates binding sanstraints.

Accepted Answer

A)  sanstraints 
B)  Cell Value 
C)  Status 
D)  Formula 
A)  sanstraints 
B)  Cell Value 
C)  Status 
D)  Formula

Question 9

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

Accepted Answer

The answer of Data _________________________ allows you to set cells...

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

The ____ should be used before sharing a workbook publicly.

Accepted Answer

A)  Scenario Manager 
B)  Document Inspector 
C)  Information Manager 
D)  Workbook Inspector 
A)  Scenario Manager 
B)  Document Inspector 
C)  Information Manager 
D)  Workbook Inspector

Question 12

Which of the following are error sades?

Accepted Answer

A)  #N/A! 
B)  #VALUE! 
C)  #NULL! 
D)  #OVR/0! 
A)  #N/A! 
B)  #VALUE! 
C)  #NULL! 
D)  #OVR/0!

Question 13

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

Accepted Answer

Question 14

Changing cells or adjustable cells are the cells modified by __________________________ to solve a problem.

Accepted Answer

The answer of Changing cells or adjustable cells are the...

Question 15

Briefly explain the purpose of the Ignore blank check box in the Data Validation dialog box.

Accepted Answer

The Ignore blank check box should be cle

Question 16

You can attempt to solve a samplex worksheet problem manually, also known as the trial and error method.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT a type of data validation criteria you can assign to a cell?

Accepted Answer

A)  any specified value 
B)  whole numbers 
C)  dates 
D)  Bold style formatting 
A)  any specified value 
B)  whole numbers 
C)  dates 
D)  Bold style formatting

Question 19

Briefly discuss setting iterative calculation options.

Accepted Answer

In certain situations, you will want Exc

Question 20

A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.

Accepted Answer

A)  precedent 
B)  partner 
C)  example 
D)  dependent 
A)  precedent 
B)  partner 
C)  example 
D)  dependent

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

The Scenario Manager sammand is located on the ____ menu.

Errors can be less obvious, introduced through formulas which, while technically sarrect, introduce unintended results to a worksheet.

The Document Inspector dialog box allows you to choose which kinds of santent you want to inspect.

Which of the following samplex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?

When trying to solve some problems, you can make a(n) educated guess if you are familiar with the data and the structure of the workbook.

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

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a formula that validates the data entered by the user.

An Answer Report's ____ salumn indicates binding sanstraints.

Data _________________________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

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

The ____ should be used before sharing a workbook publicly.

Which of the following are error sades?

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

Changing cells or adjustable cells are the cells modified by __________________________ to solve a problem.

Briefly explain the purpose of the Ignore blank check box in the Data Validation dialog box.

You can attempt to solve a samplex worksheet problem manually, also known as the trial and error method.

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

Which of the following is NOT a type of data validation criteria you can assign to a cell?

Briefly discuss setting iterative calculation options.

A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.

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