Exam 8: Refine an Excel Application

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.

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

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

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.

Macros can be run from the ________ tab or from a button added to a worksheet.

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.

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

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

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

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

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

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.

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

Match the following terms to their description. I.Data validation II.List validation III.Decimal validation IV.Date validation V.Whole number validation A.Restricts users to entering data in a cell that contain digits and a decimal point B.Any means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications C.Restricts the user to entering integer values in a validated cell D.Presents the user with a list of data values from which the user can choose E.Restricts the user to entering dates that satisfy the specified criteria in a validated cell

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

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

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

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

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

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