Match between columns Premises: Data validation Validation criteria Input message Error alert Error style

The Answer of Descriptive text or instructions for data entry is...

Match between columns Premises: Fill across worksheet Grouping Ungrouping Hide Unhide

The Answer of The process of deselecting grouped worksheets so is...

Match between columns Premises: Source file Syntax error Hyperlink Destination file Logic error

The Answer of An electronic marker that, when clicked, connects is...

Match between columns Premises: #DIV/0! #NAME? #N/A #NULL! #NUM

The Answer of Invalid arguments used in a function and is...

Match between columns Premises: #REF! IFERROR #VALUE! #NUM! #N/A

The Answer of A logical function that checks a cell is...

Match between columns Premises: Watch Window IFERROR Formula auditing Precedents Dependents

The Answer of Cells that are referenced in a formula is...

Match between columns Premises: anomaly composite key encryption non-key field

The Answer of the process of altering digital information using is...

Exam 9: What If Analysis: Hands On Exercise Videos

Which of the following What-If analysis tools is an add-in?

Free

(Multiple Choice)

4.7/5

(30)

Question 1

Correct Answer:

Verified

A

Match the following terms with the corresponding description:

Data validation

Descriptive text or instructions for data entry that can be entered in the Data Validation dialog box

Validation criteria

A message that displays when a user enters invalid data in a cell that has a validation rule applied to it

Input message

Controls the icon that appears with the error message

Correct Answer:

Verified

Data validation

Descriptive text or instructions for data entry that can be entered in the Data Validation dialog box

Validation criteria

A message that displays when a user enters invalid data in a cell that has a validation rule applied to it

Input message

Controls the icon that appears with the error message

Error alert

Enables you to control the data that can be entered into a cell

Error style

Rules that dictate the type of data that can be entered in a cell

Free

(Matching)

4.8/5

(33)

Question 2

Correct Answer:

Verified

A Solver report is displayed on the same worksheet immediately below the data.

Free

(True/False)

4.7/5

(28)

Question 3

Correct Answer:

Verified

False

When using Solver,the ________ cell contains the formula used to optimize the results.

(Multiple Choice)

4.8/5

(41)

Question 4

________ are restrictions or limitations imposed on Solver as it determines the optimum value.

(Multiple Choice)

4.9/5

(41)

Question 5

Given an interest rate,the number of years,and a planned down payment,you would use ________ to find the highest cost of a house you can afford while maintaining the monthly payment.

(Multiple Choice)

4.8/5

(33)

Question 6

A plug-in is a program that has to be added to Excel to extend its functionality.

(True/False)

4.8/5

(33)

Question 7

Match the following terms with the corresponding description:

Fill across worksheet

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

Grouping

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

Ungrouping

Restrict the view of a worksheet making it not visible

Correct Answer:

Verified

Fill across worksheet

Grouping

Ungrouping

Hide

Unhide

(Matching)

4.7/5

(32)

Question 8

Goal Seek is limited to manipulating only one variable and one result.

(True/False)

4.8/5

(32)

Question 9

Match the following terms with the corresponding description:

Source file

An electronic marker that, when clicked, connects to another location in the same or a different worksheet, another file, a Web page, or an e-mail

Syntax error

A file that contains original data

Hyperlink

A file containing a pointer to receive data from the source files

Correct Answer:

Verified

Source file

Syntax error

Hyperlink

Destination file

Logic error

(Matching)

4.7/5

(39)

Question 10

Match the following terms with the corresponding description:

#DIV/0!

Invalid arguments used in a function

#NAME?

Incorrect range separator Formula requires cell ranges to intersect and they do not

#N/A

Misspelled or invalid range name or function name

Correct Answer:

Verified

#DIV/0!

#NAME?

#N/A

#NULL!

#NUM

(Matching)

4.8/5

(32)

Question 11

Match the following terms with the corresponding description:

#REF!

A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error

IFERROR

Incorrect type of data used in an argument, such as referring to a cell that contains text instead of a value

#VALUE!

Function is missing one or more required arguments

Correct Answer:

Verified

#REF!

IFERROR

#VALUE!

#NUM!

#N/A

(Matching)

4.8/5

(43)

Question 12

To compare monthly mortgage payments,total amounts to repay a loan,and total interest based on varying the interest rate,you would use ________.

(Multiple Choice)

4.8/5

(29)

Question 13

Match the following terms with the corresponding description:

Watch Window

Cells that are referenced in a formula

IFERROR

Contain formulas that refer to other cells

Formula auditing

A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error

Correct Answer:

Verified

Watch Window

IFERROR

Formula auditing

Precedents

Dependents

(Matching)

4.9/5

(29)

Question 14

Match the following terms with their meanings:

anomaly

the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key

composite key

an error or inconsistency that occurs when you add, edit, and delete data

encryption

a field that is not part of the primary key

Correct Answer:

Verified

anomaly

composite key

encryption

non-key field

(Matching)

4.7/5

(31)

Question 15

Data tables can be constructed using one,two,or three variables.

(True/False)

4.9/5

(39)

Question 16

To optimize the monthly payments,you would designate the home cost,down payment,APR,and number of years for the loan as the ________ variable cells.

(Multiple Choice)

4.9/5

(46)

Question 17

Match the following terms with the corresponding description:

[Indianapolis.xlsx]Qtr3!A1

External reference in which Worksheet name contains spaces; source and destination files are in the same folder

'[South Bend.xlsx]Qtr3'!A1

Cell reference

'[Bloomington.xlsx]Qtr 3 Sales'!A1

External reference in which Workbook and worksheet names do not contain spaces; source and destination files are in the same folder.

Correct Answer:

Verified

[Indianapolis.xlsx]Qtr3!A1

'[South Bend.xlsx]Qtr3'!A1

'[Bloomington.xlsx]Qtr 3 Sales'!A1

'C:\Data[Indianapolis.xlsx]Sheet1'!A1

B3

(Matching)

4.9/5

(39)

Question 18

The ________ value replaces the original input value of the variable in a data table.

(Multiple Choice)

4.8/5

(44)

Question 19

Best-Case,Worst-Case,and Mostly Likely are descriptive names used to identify ________.

(Multiple Choice)

4.9/5

(32)

Question 20

Exam 9: What If Analysis: Hands On Exercise Videos

Which of the following What-If analysis tools is an add-in?

A Solver report is displayed on the same worksheet immediately below the data.

When using Solver,the ________ cell contains the formula used to optimize the results.

________ are restrictions or limitations imposed on Solver as it determines the optimum value.

Given an interest rate,the number of years,and a planned down payment,you would use ________ to find the highest cost of a house you can afford while maintaining the monthly payment.

A plug-in is a program that has to be added to Excel to extend its functionality.

Goal Seek is limited to manipulating only one variable and one result.

To compare monthly mortgage payments,total amounts to repay a loan,and total interest based on varying the interest rate,you would use ________.

Data tables can be constructed using one,two,or three variables.

To optimize the monthly payments,you would designate the home cost,down payment,APR,and number of years for the loan as the ________ variable cells.

The ________ value replaces the original input value of the variable in a data table.

Best-Case,Worst-Case,and Mostly Likely are descriptive names used to identify ________.

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