Exam 8: Refine an Excel Application

Any ________ validation is a means of using the Input Message available through the data validation tools to communicate data entry rules and/or expectations to the user.

(Multiple Choice)

4.9/5

(26)

Question 81

By default,all cells in a worksheet are unlocked.

(True/False)

4.8/5

(40)

Question 82

When a formula contains an error and the Trace Dependents tool has not helped you correct the problem,using the Review Formula tool is the next step.

(True/False)

4.8/5

(37)

Question 83

Hiding worksheet tabs does not stop navigation to other worksheets in the workbook if hyperlinks have been created that allow the user to move from one sheet to another.

(True/False)

4.8/5

(36)

Question 84

All of the following statements are TRUE about hiding worksheet tabs EXCEPT:

(Multiple Choice)

4.8/5

(41)

Question 85

________ validation presents the user with a list of data values from which the user can choose.

(Multiple Choice)

4.8/5

(42)

Question 86

All of the following statements are TRUE about protecting workbooks and worksheets EXCEPT:

(Multiple Choice)

4.9/5

(31)

Question 87

The ________ Formula tool shows you exactly how a formula executes so that you can compare actual execution to the way you know or think the formula should work.

(Short Answer)

4.8/5

(35)

Question 88

________ are objects that when clicked with the mouse navigate to a predefined location within large worksheets,among worksheets in a workbook,among workbooks,or to web sites.

(Short Answer)

4.8/5

(34)

Question 89

In cases where a codified data value cannot be adequately validated using a single range of values,custom data validation can be used.

(True/False)

4.9/5

(48)

Question 90

Active code such as macros and ActiveX controls should be opened from a Trusted Location.

(True/False)

4.9/5

(27)

Question 91

Which of the following is NOT an option in the Formula Auditing group on the Formula tab?

(Multiple Choice)

4.7/5

(20)

Question 92

The ________ informs a user when entered data violates validation constraints.

(Short Answer)

4.8/5

(30)

Question 93

Generally,circular references are of no concern to the user,but Excel creates warnings just as a precaution.

(True/False)

4.9/5

(44)

Question 94

If you make a mistake when recording a macro,you can delete the macro and record a new one,or if you know VBA you can edit a macro and change the VBA that Excel produced.

(True/False)

4.9/5

(33)

Question 95

Text length validation can be very important when data entered into a worksheet will be imported into a database.

(True/False)

4.9/5

(31)

Question 96

________ validation allows users to apply multiple criteria simultaneously.

(Multiple Choice)

4.8/5

(30)

Question 97

________ uses a password to create a unique algorithm used to translate the saved Excel workbook into a stream of uninterpretable characters that can only be translated back using a password.

(Multiple Choice)

4.9/5

(38)

Question 98

The moment a(n)________ validation cell is made active,the Input Message is displayed as a prompt to the user.

(Short Answer)

4.8/5

(33)

Question 99

All of the following statements are TRUE about data validation EXCEPT:

(Multiple Choice)

4.7/5

(33)

Question 100

Showing 81 - 100 of 100

Any ________ validation is a means of using the Input Message available through the data validation tools to communicate data entry rules and/or expectations to the user.

By default,all cells in a worksheet are unlocked.

When a formula contains an error and the Trace Dependents tool has not helped you correct the problem,using the Review Formula tool is the next step.

Hiding worksheet tabs does not stop navigation to other worksheets in the workbook if hyperlinks have been created that allow the user to move from one sheet to another.

All of the following statements are TRUE about hiding worksheet tabs EXCEPT:

________ validation presents the user with a list of data values from which the user can choose.

All of the following statements are TRUE about protecting workbooks and worksheets EXCEPT:

The ________ Formula tool shows you exactly how a formula executes so that you can compare actual execution to the way you know or think the formula should work.

________ are objects that when clicked with the mouse navigate to a predefined location within large worksheets,among worksheets in a workbook,among workbooks,or to web sites.

In cases where a codified data value cannot be adequately validated using a single range of values,custom data validation can be used.

Active code such as macros and ActiveX controls should be opened from a Trusted Location.

Which of the following is NOT an option in the Formula Auditing group on the Formula tab?

The ________ informs a user when entered data violates validation constraints.

Generally,circular references are of no concern to the user,but Excel creates warnings just as a precaution.

If you make a mistake when recording a macro,you can delete the macro and record a new one,or if you know VBA you can edit a macro and change the VBA that Excel produced.

Text length validation can be very important when data entered into a worksheet will be imported into a database.

________ validation allows users to apply multiple criteria simultaneously.

________ uses a password to create a unique algorithm used to translate the saved Excel workbook into a stream of uninterpretable characters that can only be translated back using a password.

The moment a(n)________ validation cell is made active,the Input Message is displayed as a prompt to the user.

All of the following statements are TRUE about data validation EXCEPT:

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters