chapter 9 Flashcards
Grouping
process of joining rows or columns of related data into a single entity
Ungrouping
Deselecting worksheets that are grouped together
Splitting
The process of dividing a worksheet window into resizable panes to enable viewing separate parts of a worksheet at the same time
Split bar
A vertical or horizontal line that frames pane in a worksheet that enables the user to resize the pane
Hyperlink
An electronic market to another location in a worksheet, workbook, file or web
3-D formula
A formula that refers to the same range in multiple worksheets
Linking
process of connecting between worksheets
Source file
file that contains original data
Syntax error
error that occurs when formula construction rules are violated
Logic error
error that occurs when formula adheres to syntax rules but produced inaccurate results
Precedent cells
A cell that is referenced be a formula in another cell
Tracer arrow
A coloured line that indicated relationship between precedent and dependent cells
Watch window
A window that enables you to view formula calculations
Data validation
A setting that requires that rules be followed in order to allow data to be entered in a cell
