Deck 8: Refine an Excel Application

Question 1

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

A)authentication
B)validation
C)certification
D)verification

Answer 1

B

Question 2

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

A)criteria
B)conditions
C)settings
D)controls

Answer 2

A

Question 3

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

A)restrictive
B)conditional
C)codified data value
D)logical

Answer 3

C

Question 4

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

A)Alt + Ctrl + Enter
B)Ctrl and type F
C)Alt + Ctrl + Shift
D)Ctrl and type G

Question 5

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

A)decimal
B)numeric
C)fractional
D)percentage

Question 6

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

A)Input Message
B)Error Message
C)list validation
D)cell validation

Question 7

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

A)Logical
B)Decimal
C)Conditional
D)Numeric

Question 8

Which of the following is NOT a formula auditing tool?

A)Trace Precedents
B)Trace Dependents
C)Evaluate Relationships
D)Evaluate Formula

Question 9

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

A)Directory
B)Registry
C)Index
D)List

Question 10

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

A)must be in the same workbook where the validation is applied
B)must be in the same worksheet where the validation is applied
C)must be in a different workbook than where the validation is applied
D)must be in a different worksheet than 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.

A)Evaluate
B)Analyze
C)Review
D)Interpret

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.

A)data
B)input
C)text
D)value

Question 13

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

A)An Error Message appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.
B)Each of the validation criteria can be specified with an Input Message and/or an Error Alert.
C)Data validation restricts a single validation criteria per cell.
D)Custom validation can be used to apply multiple validation criteria to a cell, but the formulas required tend to be much more complex.

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.

A)Trace
B)Audit
C)Watch
D)Evaluate

Question 15

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

A)As soon as the workbook is closed, any cells in that workbook that are being watched are removed from the Watch Window.
B)The Watch Window is an Excel feature that makes it possible to monitor cells the user considers important in a separate window.
C)The Watch Window is particularly useful when you are making changes in one worksheet or workbook and you want to monitor the effect of your changes to values in several other worksheets or workbooks.
D)To include a cell in the Watch Window, the workbook that contains the cell must be closed and must remain closed.

Question 16

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

A)Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula.
B)Formula-auditing tools show you which cells are used in a formula and how they are used.
C)When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell.
D)Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

Question 17

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

A)Complex
B)Detailed
C)Custom
D)Compound

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.

A)list validation
B)Error Message
C)Input Message
D)cell validation

Question 19

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

A)Trace Precedents
B)Evaluate Formula
C)Trace Dependents
D)Calculation Options

Question 20

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

A)self
B)circular
C)duplicate
D)matching

Question 21

By default,only the ________ options are allowed when the worksheet is protected.

A)Delete rows and Delete columns
B)Format rows and Format columns
C)Select locked cells and Select unlocked cells
D)Edit objects and Format cells

Question 22

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

A)Hiding row and column headings is an all or nothing option.
B)Some navigation options are for the whole workbook while some are for individual worksheets.
C)When you are thinking about changing navigation options, you should carefully consider what each worksheet looks like and how the option will affect each worksheet.
D)Hiding the scroll bars for one worksheet might be fine, but if another worksheet needs them to navigate, then you should probably not hide them.

Question 23

Excel protection features can be found in the Changes group on the ________ tab.

A)Insert
B)Data
C)Review
D)View

Question 24

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

A)To unhide a worksheet, right-click any worksheet tab, select Unhide, select the name of the hidden worksheet, and click OK.
B)When you hide a worksheet, hyperlinks to that worksheet will still work.
C)Hiding worksheet tabs will affect the whole workbook and hide either all the worksheet tabs or none of the worksheet tabs.
D)Once you hide the tabs, you have to show them again to continue navigating to individual worksheets, especially if you do not have hyperlinks set up to each worksheet.

Question 25

The ________ feature of Excel can be used to manually validate data.

A)value-to-speech
B)text-to-speech
C)input-to-speech
D)item-to-speech

Question 26

________ 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.

A)Encryption
B)A macro
C)Cyphering
D)A translator

Question 27

A ________ Location is a folder that has been identified in the Microsoft Office Trust Center as a safe location from which to open files that contain active code.

A)Protected
B)Secured
C)Locked
D)Trusted

Question 28

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

A)Excel allows the protection of applications in two layers.
B)Worksheet-level protection allows very fine control of how protection will affect the usability of a worksheet.
C)Workbook-level protection controls who has access to the workbook.
D)Worksheet protection can be applied to groups of worksheets.

Question 29

________ schemes consist of rules that combine data values in specific formats and locations to generate a new data value.

A)Codification
B)Identification
C)Merged
D)Linked

Question 30

Actual cells that ________ macro references will affect are not determined until the macro is run.

A)linked
B)joined
C)relative
D)merged

Question 31

If the location where a file is stored is not known to the Excel Trust Center as a trusted location,the Trust Center will block all of the following that could contain malicious code EXCEPT ________.

A)formulas
B)macros
C)controls
D)scripts

Question 32

All of the following statements are TRUE regarding macros EXCEPT:

A)Recording macros is generally considered an activity for worksheet developers.
B)As with cell references in formulas, cell references in macros can be absolute or relative.
C)The effects of a macro can be reversed using the Undo feature.
D)Macros are recorded with absolute references by default.

Question 33

________ macro references affect exactly the same cell address every time the referencing macro is run.

A)Specific
B)Absolute
C)Fixed
D)Secured

Question 34

To hide the horizontal scroll bar on a workbook,click the ________ tab,click Options,click Advanced,and uncheck Show horizontal scroll bar.

A)File
B)Page Layout
C)Review
D)View

Question 35

The inclusion of ________ in a workbook can make navigation in a workbook much more intuitive and self-explanatory.

A)hyperlinks
B)groupings
C)joins
D)networks

Question 36

________ length validation can be very important to prevent truncation when data entered into a worksheet will be imported into a database.

A)Data
B)Input
C)Text
D)Value

Question 37

All of the following statements are TRUE regarding custom data validation EXCEPT:

A)Custom validation allows you to specify more complex criteria than allowed with the other validation types.
B)Data validation is an excellent tool to use in workbooks where you want to restrict data entry to certain values or ranges of values.
C)There may be times when data validation rules can hinder data entry rather than enhance it.
D)Using custom validation, you can apply multiple criteria one at a time.

Question 38

________ validation allows users to apply multiple criteria simultaneously.

A)Defined
B)Personalized
C)Custom
D)Individualized

Question 39

All of the following statements are TRUE about gridlines EXCEPT:

A)Gridlines are used to demark one worksheet cell from another.
B)Gridlines should remain visible except in very rare instances.
C)Gridlines are very helpful during the development of a worksheet.
D)Gridlines lend visual structure to a worksheet.

Question 40

At its most basic,a ________ in Excel is a recording of keystrokes and mouse clicks performed to complete a task.

A)sparkline
B)callout
C)macro
D)hyperlink

Question 41

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

Question 42

Running a macro in Excel deletes the entire Undo history.

Question 43

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

Question 44

The Input Message and Error Message for a data validation rule are helpful but not required when creating the rule.

Question 45

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

Question 46

Macros can be run from the Developer tab.

Question 47

To include a cell in the Watch Window,the workbook that contains the cell must be open and must remain open.

Question 48

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.

Question 49

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

Question 50

A dependent cell is a cell that supplies a value to the formula in the active cell,and a precedent cell is a cell whose value depends on the value in the active cell for its result.

Question 51

When you choose to trace dependents and trace precedents,Excel puts arrows on the workbook to show you how the formula in the cell is constructed.

Question 52

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.

Question 53

Using named ranges to identify source data for list validation is self-documenting,makes worksheets easier to interpret and understand,and is less error-prone for data entry than is entering a range address.

Question 54

In a well-designed worksheet,row and column headings may not be necessary.

Question 55

Excel provides data validation tools that can help ensure data entry errors are eliminated.

Question 56

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.

Question 57

Data schemes consist of rules that combine data values in specific formats and locations to generate a new data values.

Question 58

Excel includes a text-to-speech feature that can assist you in manually validating data.

Question 59

Macros are recorded with relative references by default.

Question 60

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

Question 61

________ validation is similar to date validation with the only difference that data entered must be a time value.

Question 62

________ validation works very similar to decimal validation except the value entered must be a date that satisfies the specified criteria.

Question 63

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

Question 64

By default,all cells in a worksheet are unlocked.

Question 65

The ________ is an Excel feature that makes it possible to monitor cells the user considers important.

Question 66

A(n)________ cell is a cell that supplies a value to the formula in the active cell.

Question 67

If you are concerned about security,you can always save the backup with a different name so that someone else might not be able to determine it is the same workbook as the one with the password.

Question 68

An Excel ________ reference describes a single formula that references itself or multiple formulas that reference each other.

Question 69

________ are constraints that limit what users are allowed to enter into a particular cell.

Question 70

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

Question 71

________ validation is similar to decimal validation with the exception that only integer values are valid and no decimals.

Question 72

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

Question 73

________ validation is generally used to limit the number of characters that can be entered into a cell.

Question 74

Protection at the worksheet-level is not nearly as flexible as protection at the workbook-level.

Question 75

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.

Question 76

It is considered wise to protect your workbooks with both workbook-level and worksheet-level protection.

Question 77

The Excel Mark as Complete feature is a workbook developer's way of notifying anyone who opens a workbook that development and testing are complete,and the workbook is ready for use.

Question 78

Tracing formulas draws ________ from a formula to cells that supply source data and to formulas that use the result of a formula.

Question 79

________ includes rules that determine what can and cannot be entered in specific cells.

Question 80

A(n)________ cell is a cell whose value depends on the value in the active cell for its result.