# 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?

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.