Question

Why is what we're doing called a "pivot table" Because you can: All of the above a. Interchange rows and columns d. Pivot on a selected cell b. Pivot rows 6. f None of the above c. Pivot columns In a corporate setting, pivot table spreadsheets are often prepared from what source? a. The cloud b. The web c. A relational database d. Operational data e. All of the above f None of the above 8. What is a "slicer" in a pivot table? a. Use relationships within the b. Reduce the data to a selected c. Does the same thing as a filter What kind of data is the "Golf Data"? d. Both B and C e All of the above f None of the above database subset 9. a Relational database b. SQL database d. Flat file e All of the above f. None of the above 10. What does a filter do in a pivot table? a. Remove irrelevant data d. Use relationships within the database b. Add specific kinds of data c. Nullify the relationship within the f None of the above e All of the above database Excel Quiz 6 Page 2

Answer 1

Solution:

6)

All of the above

7)

A relational database

8)

Both b and c

9)

All of the above

10)

Use relationship within the database.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)