How to Refresh and Change a Pivot Table
Über den Vortrag
Der Vortrag „How to Refresh and Change a Pivot Table“ von Sonic Performance ist Bestandteil des Kurses „Analyzing Data by Using Pivot Tables in Excel 2016 (EN)“.
Quiz zum Vortrag
When you add a calculated field to your PivotTable, in which of the following locations does it appear?
- As a column within the PivotTable.
- As a field in the top section of the PivotTable Fields task pane.
- As a row within the PivotTable.
- In the Filters area of the PivotTable Fields task pane.
Applying a style to a PivotTable changes the data that is being summarized.
- False
- True
When you create a slicer for a PivotTable, what do the slicer buttons represent?
- Unique entries in a field.
- Column names from the source data.
- Row names from the source data.
- Time periods from a date field.
In what situation would the Expand and Collapse buttons appear in a PivotTable?
- You drag two fields to the COLUMNS area of the PivotTable Fields task pane.
- You group a time field into months.
- You filter a text field using a slicer.
- You insert a timeline.
When you add data to a table in Excel, its associated PivotTable is automatically refreshed.
- False
- True
Diese Kurse könnten Sie interessieren
Dozent des Vortrages How to Refresh and Change a Pivot Table
Sonic Performance
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Kundenrezensionen
5,0 von 5 Sternen
| 5 Sterne |
|
5 |
| 4 Sterne |
|
0 |
| 3 Sterne |
|
0 |
| 2 Sterne |
|
0 |
| 1 Stern |
|
0 |
