7.6 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?
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.

License

Icon for the Creative Commons Attribution 4.0 International License

7.6 Chapter Assessment by Emese Felvegi, Noreen Brown, Barbara Lave, Julie Romey, Mary Schatz, Diane Shingledecker, and Robert McCarn is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.