Excel Chapter 9 (2022/2023) Graded A
grouping ✔✔The process of joining rows or columns of related data into a single entity so that
groups can be collapsed or expanded for data analysis. The process of selecting worksh
...
Excel Chapter 9 (2022/2023) Graded A
grouping ✔✔The process of joining rows or columns of related data into a single entity so that
groups can be collapsed or expanded for data analysis. The process of selecting worksheets to
perform the same action at the same time.
ungrouping ✔✔The process of deselecting worksheets that are grouped
splitting ✔✔the process of dividing a worksheet window into resizable panes to enable viewing
separate parts of a worksheet at the same time
split bars ✔✔A vertical or horizontal line that frames panes in a worksheet and enables the user
to resize the pane
hyperlink ✔✔An electronic marker to another location in a worksheet, workbook, file, web page,
or email
3-D formula ✔✔A formula or function that refers to the same range in multiple worksheets, such
as =SUM(January:December!C5)
linking ✔✔The process of connecting cells between worksheets
source file ✔✔A file that contains original data
destination file ✔✔A file that contains a pointer to the source file
syntax error ✔✔An error that occurs when formula construction rules are violated
logic errors ✔✔An error that occurs when a formula adheres to syntax rules but produces
inaccurate results
formula auditing ✔✔Tools to enable you to detect and correct errors in formulas by identifying
relationships among cells
precedent cells ✔✔A cell that is referenced by a formula in another cell
dependent cells ✔✔A cell containing a formula that is dependent on other cells to obtain its
value
tracer arrows ✔✔A colored line that indicates relationships between precedent and dependent
cells
IFERROR function ✔✔A logical function that checks a value and returns the result it possible or
an error message
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
validation criteria ✔✔Rules that dictate the data to enter in a cell
input messages ✔✔A description or instructions for data entry
error alert ✔✔A message that appears when the user enter invalid data in a cell containing a
validation rule
[Show More]
