BITM 215 Final Exam Question and
answers 100% correct 2025/2026
grouping - correct answer ✔-selecting 2 or more worksheets so you can perform the dame action at
the same time, the worksheets will have identical structure and formatting
-can group and ungroup
What does grouping worksheets improve? - correct answer ✔-productivity, can perform data entry,
structural changes (add,deleting,widening rows/columns), formatting page layouts, and printing
-You can copy worksheets from one workbook to another
Worksheet refrences - correct answer ✔Allows you to reference cells in other worksheets in the same
workbook, requires you to use the name of the worksheet before the cell range
Worksheet Reference - correct answer ✔-Allows you to reference cells in other worksheets in the same
workbook -Exclamation points separate worksheets and cell references
-Ex. Atlanta!B3 + Boston!B4
-Is absolute
-Pointer to a cell in another worksheet
When referencing a worksheet.. - correct answer ✔...you can click tab for the worksheet
-if sheet name contains spaces when referencing, enclose name in single quotes=> 'year end sum'!B3
Managing Worksheets - correct answer ✔You can :
-Control worksheet visibility (hiding, displaying)
-Open and arrange windows (can view 2 ws at once)
-Split a window
, -Save an excel worksheet
-to see content of 2 worksheets at the same time use "new window" and 'arrange all"
Synchronized scrolling - correct answer ✔Allows you to scroll in one pane while the other pane(s) move
similarly
Hyperlink - correct answer ✔An electronic Marker that connects to a(n)
-specific cell in the same workbook
-specific cell in a different workbook
-existing file
-web page
-email address
3D Formula - correct answer ✔Formula that refers to the same cell or cell range in multiple worksheets
Linking - correct answer ✔Connecting cells between workbooks
3D Workbook - correct answer ✔Tabs at bottom display worksheet names, scrolling buttons allow easy
movement along worksheets
3D reference - correct answer ✔includes worksheet name, column letter, and row #
-a formula with a 3D reference is useful to obtain the value from a cell range in another worksheet. The
formula would contain worksheet name, exclamation point, and cell reference Ex. 'octobersales'!E5
-A function w/ a 3D reference may contain data from 2 or more worksheets EX. SUM('Qtr1:Qrt4'!E3)
where cell E3 in all sheets from Qtr1 to Qtr4 is included in range
answers 100% correct 2025/2026
grouping - correct answer ✔-selecting 2 or more worksheets so you can perform the dame action at
the same time, the worksheets will have identical structure and formatting
-can group and ungroup
What does grouping worksheets improve? - correct answer ✔-productivity, can perform data entry,
structural changes (add,deleting,widening rows/columns), formatting page layouts, and printing
-You can copy worksheets from one workbook to another
Worksheet refrences - correct answer ✔Allows you to reference cells in other worksheets in the same
workbook, requires you to use the name of the worksheet before the cell range
Worksheet Reference - correct answer ✔-Allows you to reference cells in other worksheets in the same
workbook -Exclamation points separate worksheets and cell references
-Ex. Atlanta!B3 + Boston!B4
-Is absolute
-Pointer to a cell in another worksheet
When referencing a worksheet.. - correct answer ✔...you can click tab for the worksheet
-if sheet name contains spaces when referencing, enclose name in single quotes=> 'year end sum'!B3
Managing Worksheets - correct answer ✔You can :
-Control worksheet visibility (hiding, displaying)
-Open and arrange windows (can view 2 ws at once)
-Split a window
, -Save an excel worksheet
-to see content of 2 worksheets at the same time use "new window" and 'arrange all"
Synchronized scrolling - correct answer ✔Allows you to scroll in one pane while the other pane(s) move
similarly
Hyperlink - correct answer ✔An electronic Marker that connects to a(n)
-specific cell in the same workbook
-specific cell in a different workbook
-existing file
-web page
-email address
3D Formula - correct answer ✔Formula that refers to the same cell or cell range in multiple worksheets
Linking - correct answer ✔Connecting cells between workbooks
3D Workbook - correct answer ✔Tabs at bottom display worksheet names, scrolling buttons allow easy
movement along worksheets
3D reference - correct answer ✔includes worksheet name, column letter, and row #
-a formula with a 3D reference is useful to obtain the value from a cell range in another worksheet. The
formula would contain worksheet name, exclamation point, and cell reference Ex. 'octobersales'!E5
-A function w/ a 3D reference may contain data from 2 or more worksheets EX. SUM('Qtr1:Qrt4'!E3)
where cell E3 in all sheets from Qtr1 to Qtr4 is included in range
