Excel Chapter 9 (2022/2023) Graded A

Document Content and Description Below

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 pro... cess 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]

Last updated: 2 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: