By default, PivotTables display __________ data for each category. However, you may want to set a filter to exclude particular categories or values.Group of answer choicesAverage value ofMaximum value ofAggregated Minimum value of data

True or false? PivotTable data should contain no blank rows or columns.Group of answer choicesTrueFalse

True or False: A PivotChart can only be created from data located in a PivotTable.Group of answer choicesTrueFalse

Question 5You have created a pivot table from from this Table A:FruitsCategoryAmountBlueberryBerry230CranberryBerry340BlackberryBerry120Green GrapesGrapes400Seedless GrapesGrapes250………You now want to display the number of fruits for each category. How should you configure your pivot table?1 pointDrag Category into Rows, then drag Amount into Values.Drag Amount into Rows, then drag Fruit into Values.Drag Fruit into Rows, then drag Category into Columns.Drag Category into Rows, then drag Amount into Columns.

Pivot tables must have a row and column but don't have to have a filter category True False

What is an Excel feature that displays only the data in column (s) according to specified criteria?Group of answer choicesFormulaPivotFilteringSorting