Match between columns Premises: Grouping Ungrouping 3-d reference External reference Split bar

The Answer of Divides a worksheet into panes and The is...

Match between columns Premises: Data Validation Stop style Warning style Information style Circle text

The Answer of Prevents the user from entering invalid data is...

Exam 9: What If Analysis: Hands On Exercise Videos

When entering text to be displayed in the column headings of a data table,the text must be enclosed in quotation marks.

(True/False)

4.8/5

(34)

Question 21

Match the following terms with the corresponding description:

=SUM(''Qtr1:Qtr4''!E3)

IFERROR function

[Indianapolis.xlsx]Qtr3!A1

Cells that are referenced in a formula

=IFERROR(D2/E2, "Error in data")

Enables you to create a small window so you can conveniently inspect, audit, or confirm formula calculations involving cells not immediately visible on the screen

Correct Answer:

Verified

=SUM(''Qtr1:Qtr4''!E3)

[Indianapolis.xlsx]Qtr3!A1

=IFERROR(D2/E2, "Error in data")

Watch Window

Precedent

(Matching)

4.9/5

(39)

Question 22

To compare monthly mortgage payments based on varying the interest rate and the cost of the house,you would use ________.

(Multiple Choice)

4.7/5

(32)

Question 23

You can have multiple scenarios in a workbook,but you can have only one scenario on each worksheet.

(True/False)

4.8/5

(26)

Question 24

Match the following terms with their meanings:

Database Splitter

analyzes the tables in a database and normalizes them for you

functional dependency

evaluates a database and then makes recommendations for optimizing the database

Table Analyzer

occurs when the value of one non-key field is functionally dependent on the value of another non-key field

Correct Answer:

Verified

Database Splitter

functional dependency

Table Analyzer

transitive dependencies

Performance Analyzer

(Matching)

4.7/5

(40)

Question 25

Match the following terms with the corresponding description:

Grouping

Divides a worksheet into panes

Ungrouping

The process of selecting two or more worksheets so that you can perform the same action at the same time on all selected worksheets

3-d reference

The process of deselecting grouped worksheets so that actions performed on one sheet do not affect other worksheets

Correct Answer:

Verified

Grouping

Ungrouping

3-d reference

External reference

Split bar

(Matching)

4.9/5

(36)

Question 26

In the Goal Seek dialog box,the cell reference of the desired value is entered in the ________ box.

(Multiple Choice)

4.9/5

(30)

Question 27

Solver is an add-in What-If Analysis tool.

(True/False)

4.8/5

(44)

Question 28

A series of ________ indicates that the width of a column is too narrow to display the complete number.

(Multiple Choice)

4.7/5

(31)

Question 29

Match the following terms with the corresponding description:

Data Validation

Prevents the user from entering invalid data

Stop style

Accepts invalid data but warns user that data are invalid

Warning style

Accepts invalid data but provides information to user

Correct Answer:

Verified

Data Validation

Stop style

Warning style

Information style

Circle text

(Matching)

4.8/5

(31)

Question 30

A scenario ________ is used to compare multiple scenarios.

(Multiple Choice)

4.8/5

(28)

Question 31

Exam 9: What If Analysis: Hands On Exercise Videos

When entering text to be displayed in the column headings of a data table,the text must be enclosed in quotation marks.

To compare monthly mortgage payments based on varying the interest rate and the cost of the house,you would use ________.

You can have multiple scenarios in a workbook,but you can have only one scenario on each worksheet.

In the Goal Seek dialog box,the cell reference of the desired value is entered in the ________ box.

Solver is an add-in What-If Analysis tool.

A series of ________ indicates that the width of a column is too narrow to display the complete number.

A scenario ________ is used to compare multiple scenarios.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters