Excel Pivot Table Quiz 6, MGMT 345 First Name: Last Name: Dawg Tag ID:_ Signatur

Question

Excel Pivot Table Quiz 6, MGMT 345 First Name: Last Name: Dawg Tag ID:_ Signature Instructions: This part of the assignment is to be done after completing the spreadsheet Credit cannot be given without first completing and submitting the spreadsheet portion of the assignment. There is only one correct answer for cach question. 1. The word is used to differentiate the data fields from the row or column fields in a pivot table a. By b. Classified d. e. Type All of the above c From f. None of the above 2. In order to get a traditional pivot table layout, which of the following screens are used? a. Create Pivot Table b. Pivot Table Design c. Pivot Table Operations d. Drop Page Fields Here c. All of the above . None of the above 3. An example of the type of classes in "Region" in"Golf Data" is which of the following? a North East b. North d. Both B and C e. All of the above f. None of the above South 4. Three types of data are needed for pivot tables: row, column, and a. Numeric b. ID c Data items d. Relational e. All of the above f. None of the above 5. What is the main difference between a traditional or "classic" pivot table and the newer current version? Traditional shows a skelcton b. Only traditional allows dragging d. Only current allows dragging a. All of the above None of the above c Current shows a skelcton for dragging Excel Quiz 6 Page 1

Explanation / Answer

Solution:

1)

All of the abve

2)

b

3)

both b and c

4)

All of the above

5)

d

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

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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