An interactive excel report that summarizes and analyzes large amounts of data.


Home
Chapters
Excel Chapter 7: Creating PivotTable and PivotChart Reports and Business Intelligence
End of Chapter Matching and Multiple Choice Questions

This activity contains 16 questions.


Match each term with its correction definition.

A matching question presents 15 answer choices and 15 items. The answer choices are lettered A through O. The items are numbered 1.1 through 1.15. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
refresh
PivotChart report
PowerPivot
Quick Explore Layout section Filter Business Intelligence tools PivotTable Slicer Field section Data Model Source data PivotTable Fields Pane Field names Power View
1.1 An interactive, Excel report that summarizes and analyzes large amounts of data.1.2 Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.1.3 The column titles from source data that form categories of data for a PivotTable.1.4 A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.1.5 The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.1.6 The upper portion of the PivotTable Fields pane containing the fields-column titles-from your source data; use this area to add fields to and remove fields from the PivotTable.1.7 A process by which you can limit the display of data to only specific information.1.8 Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.1.9 The command to update a worksheet to reflect new data.1.10 A graphical representation of the data in a PivotTable.1.11 Tools that can be used to perform data analysis and create sophisticated charts and reports.1.12 A method of incorporating data from multiple, related tables into an Excel worksheet.1.13 An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.1.14 An Excel BI tool that allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.1.15 A tool that allows you to drill down through PivotTable data with a single click.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Answer choices in this exercise appear in a different order each time the page is loaded.

Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data quizlet?

A PivotTable is an interactive Excel report that summarizes large amounts of data, allowing you to more easily analyze it.

Is a report in a workbook that is graphically represented in a pivot chart?

The PivotTable report in a workbook that is graphically represented in a PivotChart. An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed.

What method is used to incorporate multiple related tables into an Excel worksheet?

Chapter 7.

Is a graphical data representation of data displayed in a PivotTable?

A pivot chart is a graphical representation of a data summary, displayed in a pivot table.

Toplist

Neuester Beitrag

Stichworte