Which of the following is not applicable for a slicer?Group of answer choicesSlicer is used to filter data when a pivot table is based on multiple tablesSlicer provides a visual representation for easier manipulationOnly ONE slicer can be created for a pivot tableWe can define how many columns can be displayed in the slicer window PreviousNext

Which of the following Microsoft Excel tool can be used to filter datasets and create more focused reports by putting slicers next to important visuals?Pivot TableMacrosSlicers

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

Grouping related columns(F and G) of data as shown in the above is called?Group of answer choicesCreating an expandCreating an OutlineCreating a pivot tableNone of the answers are correct

What is the primary purpose of a Pivot Table in Excel?Group of answer choicesData sortingData encryptionData analysis and summarizationData validation

Which of the following can be created from a PivotTable? 1. PivotFilters 2. PivotCharts 3. PivotFormats 4. PivotFills