1 What is the primary function of a slicer in Excel?
a) To create charts from PivotTable data
b) To filter data in a PivotTable or PivotChart interactively
c) To perform calculations on data
d) To format cells and ranges
Answer: b) To filter data in a PivotTable or PivotChart interactively
2 How do you add a slicer to a PivotTable in Excel?
a) Go to the Insert tab and select “Slicer”
b) Use the “Design” tab under PivotTable Tools
c) Right-click on the PivotTable and choose “Add Slicer”
d) Use the “Data” tab to insert a slicer
Answer: a) Go to the Insert tab and select “Slicer”
3 Which of the following is NOT a default slicer type in Excel?
a) Date Slicer
b) Text Slicer
c) Numeric Slicer
d) Timeline Slicer
Answer: c) Numeric Slicer
4 How can you connect a single slicer to multiple PivotTables?
a) Use the “Report Connections” option in the Slicer Tools
b) Recreate the slicer for each PivotTable
c) Use the “Data Connections” option
d) Manually copy the slicer settings to each PivotTable
Answer: a) Use the “Report Connections” option in the Slicer Tools
5 What is the purpose of a timeline in Excel?
a) To filter PivotTable data by specific time periods
b) To create a visual timeline chart
c) To sort data chronologically
d) To perform trend analysis
Answer: a) To filter PivotTable data by specific time periods
6 How can you add a timeline to a PivotTable?
a) Go to the Insert tab and select “Timeline”
b) Use the “PivotTable Tools” tab
c) Right-click on the PivotTable and choose “Add Timeline”
d) Use the “Data” tab to insert a timeline
Answer: a) Go to the Insert tab and select “Timeline”
7 What type of data is most suitable for use with a timeline?
a) Categorical data
b) Text data
c) Date and time data
d) Numerical data
Answer: c) Date and time data
8 Which option in the Slicer Tools allows you to format and customize the appearance of a slicer?
a) Options tab
b) Design tab
c) Format tab
d) Analyze tab
Answer: b) Design tab
9 To filter a PivotTable using both slicers and timelines simultaneously, what must you ensure?
a) Both the slicers and timelines are connected to the same PivotTable
b) The slicers and timelines are in separate worksheets
c) The PivotTable data source is updated manually
d) The slicers and timelines are based on different data sources
Answer: a) Both the slicers and timelines are connected to the same PivotTable
10 What is the benefit of using slicers and timelines together in a dashboard?
a) They allow for interactive and dynamic filtering of data across different dimensions
b) They increase the complexity of the data model
c) They limit the data analysis capabilities
d) They provide static views of data
Answer: a) They allow for interactive and dynamic filtering of data across different dimensions