Question 1

Data ________ is a means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications.

Accepted Answer

Validation involves checking data for accuracy and completeness, ensuring that it meets certain criteria or constraints. This can be done through programmatic tools such as automated checks or data validation rules, as well as through behavioral modifications like training data entry personnel. Authentication refers to confirming the identity of a user or system, certification involves issuing a formal statement of competence or compliance, and verification involves confirming the accuracy or truth of data or a system through various means.

Question 2

Validation ________ limit what worksheet users are allowed to enter into a particular cell.

Accepted Answer

Validation criteria limit what worksheet users are allowed to enter into a particular cell, ensuring data integrity and accuracy.

Question 3

A ________ is formed following a system of rules where the position of information is tied to its context.

Accepted Answer

A codified data value is created based on a system of rules where the position of the information is crucial to understanding its context, making it a structured form of data representation.

Question 4

To select all cells that contain a formula,press ________.

Accepted Answer

To select all cells that contain a formula, we can use the Go To Special function by pressing Ctrl and typing G, then selecting the radio button for "Formulas" and clicking "OK".

Question 5

Whole number validation is functionally identical to ________ validation with the exception that only integer values are valid.

Accepted Answer

The answer of Whole number validation is functionally identical to...

Question 6

A(n)________ informs a user when entered data violates validation constraints.

Accepted Answer

An error message is used to inform a user when entered data violates validation constraints. It typically appears when the user tries to submit or save the input and alerts them to the specific issue they need to correct. Option A, Input message, is used to provide guidance and instructions to users for entering data correctly. Option C, list validation, is a type of data validation where the entered value must match a list of acceptable values. Option D, cell validation, is a type of data validation that allows you to set requirements or constraints for what can be entered into a specific cell.

Question 7

________ validation requires the specification of upper and/or lower boundary values.

Accepted Answer

The answer of ________ validation requires the specification of upper...

Question 8

Which of the following is NOT a formula auditing tool?

Accepted Answer

Trace Precedents, Trace Dependents, and Evaluate Formula are all formula auditing tools in Microsoft Excel. Evaluate Relationships is not a tool in Excel.

Question 9

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

Accepted Answer

List validation presents the user with a list of predefined data values, allowing them to choose from these options. This type of validation is commonly used in form fields where there are specific options available for the user to select from, such as dropdown menus or multiple choice selections. Directory, registry, and index validation are not typically associated with presenting users with a list of choices.

Question 10

Named ranges that are to be used as lists of values for data validation ________.

Accepted Answer

Named ranges used as lists of values for data validation must be within the same workbook where the validation is applied.

Question 11

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

Accepted Answer

The Evaluate Formula tool is used to see how a formula is executed step-by-step. It helps compare the actual execution to the expected execution of the formula.

Question 12

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.

Accepted Answer

The answer of Any ________ validation is a means of...

Question 13

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

Accepted Answer

The answer of All of the following statements are TRUE...

Question 14

The Excel ________ Window feature is particularly useful when you are making changes in one worksheet or workbook and you want to monitor the effect of those changes to values in several other worksheets or workbooks.

Accepted Answer

The Excel Watch Window feature allows users to monitor specific cells or ranges of cells across multiple worksheets or workbooks. It is particularly useful for tracking the effects of changes made in one worksheet or workbook on other related worksheets or workbooks. The Trace function helps users to identify and follow precedents and dependents within a worksheet or workbook. The Audit function helps users to track changes made to formulas or data over time, and the Evaluate function helps users to analyze complex formulas or functions.

Question 15

All of the following statements are TRUE about the Watch Window EXCEPT:

Accepted Answer

Statement D is not true. In order to include a cell in the Watch Window, the workbook that contains the cell does not need to be closed, but the cell must be selected before adding it to the Watch Window.

Question 16

All of the following statements are TRUE about auditing formulas EXCEPT:

Accepted Answer

Explanation: The statement in C is incorrect because it describes the action of tracing precedents, not dependents. Tracing precedents shows cells that supply values to the active cell, while tracing dependents finds cells that depend on the value of the active cell.

Question 17

________ validation can be used to apply multiple validation criteria to a cell.

Accepted Answer

Custom validation in spreadsheet programs like Microsoft Excel allows users to define specific criteria that a cell's value must meet. This can include a range of values, a specific format, or a formula that the entered data must satisfy, enabling the application of multiple validation rules to a single cell.

Question 18

A(n)________ appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.

Accepted Answer

An Input Message appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints. It is used to provide guidance to the user when entering data in a cell.

Question 19

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

Accepted Answer

Calculation Options is not an option in the Formula Auditing group on the Formula tab. The other three options (Trace Precedents, Evaluate Formula, and Trace Dependents) are available in the Formula Auditing group.

Question 20

A ________ reference is used to describe a single formula that references itself or multiple formulas that reference each other.

Accepted Answer

A circular reference occurs when a formula refers to its own cell or refers to another cell which in turn refers back to the original cell, creating a loop. This can cause errors in the spreadsheet and should be avoided.

Quiz 8: Refine an Excel Application