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
Occurs when a formula uses incorrect cell references or incorrect operator that produces inaccurate result.
Logic error
A reference within a formula or fuction on 1 worksheet that includes name of another worksheet, column letter, and row number located in a workbook.
3D Reference
A file that contains original data that you want to use in another file.
Source file
Cell that is referenced by a formula in another cell.
Precedent cell
A message that displays when the user enters invalid data in a cell containing validation rule
Error alert
Descriptive text or instruction that inform a user about the restrictions for entering data in a cel..
Input message
