36 7.6 Chapter Assessment
Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn
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?
a) =ADD(C5:C13)
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.
Attribution
Questions by Emese Felvégi based on the chapter practice problems. Edited by Lilliana E. Olmos & Marcella Olmos. CC BY-NC-SA 3.0.