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