Question 1According to the video checklist, what should you remove before making a Pivot Table?1 pointValue fields Date fields Blank rows, columns, and cells Row labels

Question 1A pivot table will remove duplicates from a field when presenting the values in a pivot table view.1 pointTrueFalse

For the next two questions, consider the following pivot table, made for a mobile game to manage player statistics:How would I create the pivot table in this layout?1 pointMonsters then Rooms as Columns; Players as Rows; Kills as Values.Rooms then Monsters as Columns; Players then Kills as Rows.Rooms as Columns; Monsters as Rows; Kills as Values.Rooms as Columns; Monsters as Rows; Players as Values.

Question 1When you create a Pivot Table, your data must be in a Table beforehand.

Which of the following statements are true for Pivot Tables?(Multiple answers possible. Partial credit awarded)1 pointYou can use a text field in the Values areaYou can apply different functions - average, count, etc - to numeric fieldsNumeric values can only be summedCount can only be applied to text field

Question 3What combination of settings was used to create this Pivot Table?