Why is what we\'re doing called a \"pivot table\" Because you can: All of the ab

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

Explanation / 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

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.