How to Create a Pivot Table from an External Data Source
Über den Vortrag
Der Vortrag „How to Create a Pivot Table from an External Data Source“ von Sonic Performance ist Bestandteil des Kurses „Preparing Data and Creating Pivot Tables in Excel 2016 (EN)“.
Quiz zum Vortrag
In the top half of the PivotTable Fields task pane, where do the fields come from?
- Column headings in the source data.
- Row headings in the PivotTable.
- Row headings in the source data.
- Unique entries in the source data.
When creating a PivotTable from multiple local data sources, how does Excel know how the data among the sources is related?
- You must set up relationships among the data sources.
- Excel automatically creates relationships among the data sources.
- You must create a PivotChart from the data sources.
- You must put the data into the Data Model.
Which of the following are examples of external data sources for PivotTables?
- Other Excel workbooks
- Relational databases
- Text files
- Other worksheets within an Excel workbook
Which of the following are characteristics of clean data?
- Headings in the first row clearly describe the data in each column.
- There are no duplicate data entries.
- There are no blank rows, columns, or cells.
- Each row represents a unique data category.
- Each column has mixed data types.
Diese Kurse könnten Sie interessieren
Dozent des Vortrages How to Create a Pivot Table from an External Data Source
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 |
