5.5 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

 


 

ATTRIBUTION

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

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Business Computer Information Systems Copyright © 2020 by Emese Felvegi; Barbara Lave; Diane Shingledecker; Julie Romey; Noreen Brown; Mary Schatz; OpenStax; Saylor Academy; University of Minnesota Libraries; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.