Excel Pivot Table Quiz 6, MGMT 345 First Name: Last Name: Dawg Tag ID:_ Signatur
ID: 3735826 • Letter: E
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 1Explanation / Answer
1. The correct answer is option f. Since to make a field as a data field one has to make the field as numeric input field.
2.The correct answer is f. In order to get a traditional or classic pivot table we need to go to Pivot table options and select the option classic pivot table layout.
4. The correct answer is a. The three types of data used in pivot table are row field,column field and data field which should be numeric.
5.The correct answer is b. The dragging of the fields in the grid is allowed only in traditional pivot table
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.