Exam 8: Refine an Excel Application

________ 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 with that password.

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

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

The Excel text-to-________ feature enables manual validation of data.

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

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

Match the following terms to their description. I.Boolean operator II.Custom validation III.Any value validation IV.Text length validation V.Codification schemes

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

Running a macro in Excel deletes the entire Undo history.

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

When you record a macro,Excel is actually converting your keystrokes and mouse clicks to ________ commands.

________ validation allows you to specify more complex criteria and permits multiple criteria simultaneously.

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

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

Macros can be run from the Developer tab.

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

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

Macros are recorded with relative references by default.

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

If a workbook in a(n)________ is opened,macros contained in the document will be automatically enabled.