USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
There can only be one active slicer at a time.
|
|
They cannot be moved
|
|
They cannot be resized
|
|
A user can select multiple buttons within a slicer.
|
Detailed explanation-1: -You can also insert multiple slicers by selecting more than one dimension in the Insert Slicers dialog box. To insert multiple slicers: Select any cell in the Pivot Table. Go to Insert –> Filter –> Slicer.
Detailed explanation-2: -Slicers are a visual way to filter data in a pivot table. With the Report Connections icon, you can have a slicer control multiple pivot tables on a dashboard-but only if all the pivot tables are from the same data set.
Detailed explanation-3: -On the Insert tab, select Slicer. In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.