BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
1. 3-D reference
2. Broken link A reference to the same cell or range in multiple worksheets in
the
same workbook.
3. Custom template A workbook template you create that is ready to run with the
formulas
for all calculations included as well as all formatting and labels.
4. Destination file The workbook that receives data from another workbook when
two
workbooks are linked; sometimes referred to as the dependent file.
5. External reference A reference to cells or ranges in a worksheet from another
workbook.
6. Hyperlink A link in a file, such as a workbook, to information within that
file or another file.
7. Link A connection between files that allows data to be transferred
from one file to another.
8. Source link A workbook that contains data to be used in the destination file
when
two or more workbooks are linked.
9. Screen Tip A tool that provides more information about commands.
10. Worksheet group A collection of two or more selected worksheets.
11. 2-D Reference Formulas with reference to cells on the same sheet can be
thought of
as 2-B (or 2-dimensional) references because they involve only
the row address and the column address.
1/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
12. Named In which range references are replaced with descriptive
Range/Defined names. A named range can refer to any cell or cell range
Names within the workbook.
13. Grouped worksheets allows the same action to be done at the same time to all
grouped
worksheets
2/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
14. How do you create a Press and hold CTRL as you click each sheet tab that you want
worksheet group con- to add to the worksheet group
sisting of sheets that
are not adjacent in a
work- book?
15. Can a worksheet No; a single workbook can have multiple workbook windows.
have only one
window?
Click the sheet tab of any worksheet in the group.
16. How do you un group
a worksheet group
that consists of all the
sheets in the
workbook? Monday!C20
17. What is 3-D cell
refer- ence to cel
C20 in the Monday
worksheet?
18. What is the absolute 3-D Monday!$C$20
cell reference to cell
C20 in the Monday
work- sheet?
19. What is the 3-D cell 20. Write formula that uses the MAX
ref- erence to cell function to cal- culate the maximum
C20 in the Monday val- ue of cel C20 of the
through Friday
worksheet group?
3/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
Monday:Friday!C20
=MAX(Monday:Friday!C20)
4/
44
WITH CORRECT RATIONALES
1. 3-D reference
2. Broken link A reference to the same cell or range in multiple worksheets in
the
same workbook.
3. Custom template A workbook template you create that is ready to run with the
formulas
for all calculations included as well as all formatting and labels.
4. Destination file The workbook that receives data from another workbook when
two
workbooks are linked; sometimes referred to as the dependent file.
5. External reference A reference to cells or ranges in a worksheet from another
workbook.
6. Hyperlink A link in a file, such as a workbook, to information within that
file or another file.
7. Link A connection between files that allows data to be transferred
from one file to another.
8. Source link A workbook that contains data to be used in the destination file
when
two or more workbooks are linked.
9. Screen Tip A tool that provides more information about commands.
10. Worksheet group A collection of two or more selected worksheets.
11. 2-D Reference Formulas with reference to cells on the same sheet can be
thought of
as 2-B (or 2-dimensional) references because they involve only
the row address and the column address.
1/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
12. Named In which range references are replaced with descriptive
Range/Defined names. A named range can refer to any cell or cell range
Names within the workbook.
13. Grouped worksheets allows the same action to be done at the same time to all
grouped
worksheets
2/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
14. How do you create a Press and hold CTRL as you click each sheet tab that you want
worksheet group con- to add to the worksheet group
sisting of sheets that
are not adjacent in a
work- book?
15. Can a worksheet No; a single workbook can have multiple workbook windows.
have only one
window?
Click the sheet tab of any worksheet in the group.
16. How do you un group
a worksheet group
that consists of all the
sheets in the
workbook? Monday!C20
17. What is 3-D cell
refer- ence to cel
C20 in the Monday
worksheet?
18. What is the absolute 3-D Monday!$C$20
cell reference to cell
C20 in the Monday
work- sheet?
19. What is the 3-D cell 20. Write formula that uses the MAX
ref- erence to cell function to cal- culate the maximum
C20 in the Monday val- ue of cel C20 of the
through Friday
worksheet group?
3/
44
,BUS 1350 FINAL EXAM – RISINGER QUESTIONS
WITH CORRECT RATIONALES
Monday:Friday!C20
=MAX(Monday:Friday!C20)
4/
44
