BITM 215 Final Test CORRECT 100%
Grouping - ANSWER-Process of selecting two or more worksheets to perform the same
action at the same time
Ungrouping - ANSWER-Process od deselecting worksheets that were grouped
Hyperlink - ANSWER-Electronic marker to another location in a worksheet, workbook,
file, web page or email
Precedent Cell - ANSWER-Cell referenced by a formula in another cell
Dependent Cell - ANSWER-Cell containing a formula that is dependent on other cells to
obtain its value
IFERROR - ANSWER-Checks a value and returns the result if possible or an error
message
3-D Formula - ANSWER-Formula that refers to the same cell or range in multiple
worksheets
Linking - ANSWER-Process of connecting cells between worksheets or workbooks
Source File - ANSWER-File containing original data
Destination File - ANSWER-File that contains a pointer to the source file
Formula Auditing - ANSWER-Tools to enable you to detect and correct errors in
formulas by identifying relationships among cells
Data Validation - ANSWER-Rules that dictate the data that can be entered in a cell
Validation Criteria - ANSWER-Rules that dictate the data that can be entered in a cell
Error Alert - ANSWER-Message that appears when the user enters invalid data in a cell
containing a validation rule
Delimiters - ANSWER-Characters used to separate data in a text file
CSV - ANSWER-Comma separated values
UPPER - ANSWER-Converts text strings to uppercase letters
Grouping - ANSWER-Process of selecting two or more worksheets to perform the same
action at the same time
Ungrouping - ANSWER-Process od deselecting worksheets that were grouped
Hyperlink - ANSWER-Electronic marker to another location in a worksheet, workbook,
file, web page or email
Precedent Cell - ANSWER-Cell referenced by a formula in another cell
Dependent Cell - ANSWER-Cell containing a formula that is dependent on other cells to
obtain its value
IFERROR - ANSWER-Checks a value and returns the result if possible or an error
message
3-D Formula - ANSWER-Formula that refers to the same cell or range in multiple
worksheets
Linking - ANSWER-Process of connecting cells between worksheets or workbooks
Source File - ANSWER-File containing original data
Destination File - ANSWER-File that contains a pointer to the source file
Formula Auditing - ANSWER-Tools to enable you to detect and correct errors in
formulas by identifying relationships among cells
Data Validation - ANSWER-Rules that dictate the data that can be entered in a cell
Validation Criteria - ANSWER-Rules that dictate the data that can be entered in a cell
Error Alert - ANSWER-Message that appears when the user enters invalid data in a cell
containing a validation rule
Delimiters - ANSWER-Characters used to separate data in a text file
CSV - ANSWER-Comma separated values
UPPER - ANSWER-Converts text strings to uppercase letters
