Question 5Which of the following is NOT part of a Pivot Tables?(Multiple answers possible. Partial credit awarded).1 pointSlicersCalculated FieldSparklinesCalculated item

The option that is NOT part of a Pivot Table is Sparklines.

Here's why:

1. Slicers: These are part of Pivot Tables. They are used to filter the data in a Pivot Table report, in an interactive way.

2. Calculated Field: This is also part of Pivot Tables. A calculated field in a Pivot Table is a custom field that performs calculations using the values of other fields in the Pivot Table.

3. Sparklines: These are NOT part of Pivot Tables. Sparklines are tiny charts placed in single cells, each representing a row of data in your selection. They provide a visual representation of your data, making it easier to understand trends and patterns. They are not a feature of Pivot Tables, but rather a separate feature in Excel.

4. Calculated Item: This is part of Pivot Tables. A calculated item will appear in the Pivot Table as an option, but it's a calculation within one specific Pivot Table field, using the existing items within that field.