BITM - Chapter 9 Questions with
Accurate Answers
! correct answer Called a Bang
-separates worksheet and cell reference
3-D reference correct answer reference within a formula or function on
one worksheet that includes the name of another worksheet, column
letter, and row number located within the workbook
='worksheet name'!RangeOfCells
-can insert function with this reference and it will do the function across
worksheets
Circular reference correct answer occurs when a formula contains a
direct or an indirect reference to the cell counting the formula
Data Validation correct answer a feature that requires specified rules
be followed in order to allow data to be entered in a cell
-warns and prevents ppl from entering wrong data in a cell
Dependent Cells correct answer contain formulas that depend on other
cells to generate their values
Destination File correct answer file containing a link to receive data
from the source files
Accurate Answers
! correct answer Called a Bang
-separates worksheet and cell reference
3-D reference correct answer reference within a formula or function on
one worksheet that includes the name of another worksheet, column
letter, and row number located within the workbook
='worksheet name'!RangeOfCells
-can insert function with this reference and it will do the function across
worksheets
Circular reference correct answer occurs when a formula contains a
direct or an indirect reference to the cell counting the formula
Data Validation correct answer a feature that requires specified rules
be followed in order to allow data to be entered in a cell
-warns and prevents ppl from entering wrong data in a cell
Dependent Cells correct answer contain formulas that depend on other
cells to generate their values
Destination File correct answer file containing a link to receive data
from the source files
