# 7.5 Chapter Assessment

## The following are sample questions based on the chapter walkthrough to test whether you know, understand, and are able to apply your learning from this chapter.

1. A collection of sheets that have the same structure can be ______ for faster and more consistent processing.
a) formulated
b) grouped
c) pivoted
d) tabbed
2. To select adjacent sheets in a workbook, use:
a) ALT
b) CTRL
c) DEL
d) SHIFT
3. If you delete a cell from a sheet that is a part of 12 sheets grouped together, the cell contents from all 11 other sheets will be deleted.
True/False
4. The syntax to add contents from cell B5 from Sheet1 through Sheet12 is:
a) =SUM(Sheet1:Sheet12:B5)
b) =SUM(Sheet1:Sheet12?B5)
c) =SUM(Sheet1:Sheet12!B5)
d) =SUM(Sheet1:B5:Sheet12:B5)
5. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. In the February sheet, what is the best formula to enter into F11 to calculate Income?
a) =F5+F6+F7+F8
b) =SUM(F5,F8)
c) =SUM(F5:F8)
d) =SUM(F:F)
6. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. In the February sheet, what is the best formula to enter into F12 to calculate Expenses?
b) =C5+C6+…+C13
c) =SUM(C5,C13)
d) =SUM(C5:C13)
7. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. The best formula to calculate the Rent you have paid between March and August is:
a) =SUM(March!C5+August!C5)
b) =SUM(March!C5+April!C5+…+August!C5)
c) =SUM(March:August!C5)
d) =SUM(March:August?C5)
8. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. Your monthly Rent payment increases to \$750 for the month of June and on. How much rent will you have paid by the end of the year?
a) \$5,800
b) \$8,750
c) \$8,800
d) \$8,850
9. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. Your monthly Power payment increases to \$148 for the months of June to December. What is the new annual total you pay for Power?
a) \$1,620
b) \$1,687
c) \$1,711
d) \$1,850
10. Answer based on your work with the Personal Budget workbook from the Chapter 7 Data file. Your monthly Cable/Internet payment decreases to \$68 for the month of June and on. What is the new annual total you pay for Cable/Internet?
a) \$860
b) \$882
c) \$926
d) \$1,080

Solutions: 1/b, 2/d, 3/True, 4/c, 5/c, 6/d, 7/c, 8/b, 9/c, 10/c.