Analyzing Data with PivotTables and PivotCharts

Across

3. A type of conditional formatting which is used to represent data distribution and variation in cells using shades of color. (5,6)

7. A PivotChart creation option that inserts four blank PivotCharts which are independent of each other. (4,6)

9. A drop zone in the PowerPivot field list pane which is used to specify values that are to be displayed in the cells of a PivotTable. (6)

10. _____________ formatting is a technique that applies a specified format to a selected cell or a range of cells in a PivotTable based on a defined criteria. (11)

11. A type of sparkline used to represent data trends in the form of straight or zigzag lines. (4)

13. Components in the PowerPivot Field List pane into which you can drag fields to restructure a PivotTable. (4,5)

14. A type of sparkline used to represent data trends that display the high points, median points, and low points. (3,4)

15. A type of conditional formatting which is used to classify data into three or five categories where each category is represented by an icon. (4,4)

Down

1. A drop zone in the PowerPivot Field list pane which is used to specify fields that you want to use to filter data in a PivotTable or PivotChart report. (6,6)

2. An interactive chart that graphically represents data in a PivotTable report. (10)

4. A type of conditional formatting which is used to represent a value of a cell relative to another cell. (4,4)

5. An interactive table which is used to represent data in a matrix format. (10)

6. A type of sparkline used to represent data trends in the form of vertical bars. (6)

8. A filtering tool that can be used to display the required data in a PivotTable or PivotChart. (6)

12. A tiny chart that can be used to represent the trend for a range of values. (9)