5.6 Chapter Assessment

The following are sample questions to test whether you know, understand, and are able to apply concepts from this chapter.

1. You can insert a _____ row at the end of your table to quickly add functions via a dropdown.
a) Function
b) Pivot
c) Sum
d) Total
2. __________ is an easy way to see a subset of your data.
a) Deleting
b) Filtering
c) Resizing
d) Sorting
3. When you filter your data, data is:
a) Frozen
b) Deleted
c) Hidden
d) Resorted
4. An object you insert next to your table to filter it using buttons is called a:
a) Filter
b) Developer
c) Slicer
d) Sorter
5. How many of the guests are from Canada?
a) 9
b) 13
c) 22
d) 31
6. What is the subtotal for Guests to Black Canyon of the Gunnison National Park?
a) 12
b) 15
c) 17
d) 22
7. What is the total for Guests after Step 9 in US Guests?
a) 9
b) 13
c) 26
d) 37
8. What is the average age of Guests for all tours after Step 9 in US Guests?
a) 52.44
b) 57.25
c) 60.1
d) 62


Solutions: 1d, 2b, 3c, 4c, 5c, 6a, 7d, 8a




Practice problems by Emese Felvégi based on chapter content and chapter practice.  CC BY-NC-SA 3.0.


Icon for the Creative Commons Attribution 4.0 International License

5.6 Chapter Assessment Copyright © 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.