Exam 8: Refine an Excel Application

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

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.

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.

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

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

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

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

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

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

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

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

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.

Which of the following is NOT a formula auditing tool?

Protecting the workbook ________ stops users from inserting,deleting,hiding,unhiding,and moving worksheets in a workbook.

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

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

All of the following statements are TRUE regarding macros EXCEPT:

Match the following terms to their description. I.Formula auditing II.Circular reference III.Watch Window IV.Hyperlink V.Macro A.Describes a single formula that references itself or multiple formulas that reference each other B.Object that,when clicked with the mouse,navigates to a predefined location C.Shows which cells are in a formula and how they are used D.A form of computer program that automates activities such as mouse movements and clicks E.Excel feature that makes it possible to monitor cells the user considers important but that are not necessarily given the size and/or structure of a worksheet or workbook

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

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