Why is what we\'re doing called a \"pivot table\" Because you can: All of the ab
ID: 3735790 • Letter: W
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 2Explanation / Answer
Ans:
6.) a)We can interchange rows and columns of a spreadsheet.That is called pivot table
7.) d)All of the above
These are the datasources for pivot tables
a)cloud services like Azure
b)Web
c)RelationalDatabase
d)OPerational Data
8.) d) Both B and C
Slicer 1)Reduce the data to a selected subset
2)It is similar to filter.We can do filtering by slices
9) c) spreadsheet
Golf data is collected in spreadsheet
10) a)Remove irrelevant data