BITM - Chapter 9 questions with
complete solutions
Grouping - correct answer ✔✔the process of selecting two or more worksheets so that you can perform
the same action at the same time on all selected worksheets
Hyperlink - correct answer ✔✔an electronic link that, when clicked, goes to another location in the same
or a different worksheet, opens another file, opens a webpage in a web browser, or open an email client
and inserts an email address into the to box
Splitting/split window - correct answer ✔✔the process of dividing a worksheet window into two or four
resizable panes so you can view separate parts of a worksheet at the same time
Split Bars - correct answer ✔✔vertical and horizontal lines that frame the panes - above and to the left
of the active cell
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
Linking - correct answer ✔✔the process of creating external cell references from from worksheets in one
workbook to cells on a worksheet in another workbook
Source File - correct answer ✔✔one that contains original data that you need in another file
Destination File - correct answer ✔✔file containing a link to receive data from the source files
External Refrence - correct answer ✔✔A cell or range in a worksheet in another Excel workbook, or a
defined name in another workbook.
complete solutions
Grouping - correct answer ✔✔the process of selecting two or more worksheets so that you can perform
the same action at the same time on all selected worksheets
Hyperlink - correct answer ✔✔an electronic link that, when clicked, goes to another location in the same
or a different worksheet, opens another file, opens a webpage in a web browser, or open an email client
and inserts an email address into the to box
Splitting/split window - correct answer ✔✔the process of dividing a worksheet window into two or four
resizable panes so you can view separate parts of a worksheet at the same time
Split Bars - correct answer ✔✔vertical and horizontal lines that frame the panes - above and to the left
of the active cell
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
Linking - correct answer ✔✔the process of creating external cell references from from worksheets in one
workbook to cells on a worksheet in another workbook
Source File - correct answer ✔✔one that contains original data that you need in another file
Destination File - correct answer ✔✔file containing a link to receive data from the source files
External Refrence - correct answer ✔✔A cell or range in a worksheet in another Excel workbook, or a
defined name in another workbook.
