Chapter 9 - Multiple-Sheet Workbook Management Flashcards
Occurs when a** formula or function violates construction rules**
Syntax Error
Electronc link that, when click, goes to another location in the same or diffrerent worksheet, opens another file, web page in a web browser, or email client and inserts an email add. into the To box.
Hyperlink
Condition that dictate the type of data that can be entered in a cell.
Validation Criteria
Condition that dictate the type of data can be entered in a cell.
Validation Criteria
Area that displays the workbook name, worksheet name, cell addresses, values and formulas so you can monitor and examine formula calculations involving cellls not immidiately visible on the screen.
Watch Window
A file that contains link to retrieve data from a source file.
Destination File
Rules that must be followed to allow to be entered in a cell.
Data Validation Rules
Tools that enables you to detect and correct errors in formulas by indentifying the relationship of the cells.
Formula Auditing
A colored line that shows relationship between precedent and dependent cells
Tracer Arrow
Process of creating external references from worksheets in one workbook to cells on a worksheet in another workbook.
Linking
Process of selecting 2 or more worksheet so that you can perform the same action at the same time on all selected worksheets.
Grouping
A cell in a worksheet prevents a user from entering dat aif the worksheet is protected.
Locked cell
Happens when formula contains a direct or indirect cell reference to the cell containing the formula
Circular reference
Vertical or horizontal lines that frames panes in a worksheet and enables the user to resize panes.
Split bar
A cell containing a formula that relies on other cells to obtain its value.
Dependent cell