Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Ev's Excel PivotT&C
Quiz Q&A on Excel 2013 5.3 PivotCharts & PivotTables
| Question | Answer |
|---|---|
| A PivotTable summarizes data in different categories using functions such as ___. | min. |
| One advantage of PivotTables is that you can easily ___ different categories in the PivotTable to provide alternative views of the data. | rearrange, hide or display |
| The PivotTable button is available in the Tables group on the ___ tab. | insert |
| PivotTable data can be a(n)___. | access database file, Excel table in current workbook, Excel range in current workbook. |
| You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ___ tab. | table tools design |
| In laying out the PivotTable on the worksheet, you can drag the Condition field button from the Row Labels box to the Column Labels box. The PivotTable is rearranged so that the Condition field is a ___ label. | column |
| By default, the PivotTable report uses the ___ function for numbers in the Values area. | sum |
| You can point to any style in a gallery to see a ___ of the PivotTable with that style applied. | live preview |
| You can use the ___tab to change the SUM function to a different summary function, in a PivotTable. | summarize values by |
| The ___ report layout displays one column for each field and leaves space for column headers. | Tabular Form |
| You cannot change data directly in the PivotTable. Instead, you must edit Excel table, and then ___, or update, the PivotTable to reflect the updated data. | Refresh |
| A field that contains summary data in a PivotTable | value field |
| An object used to filter a PivotTable or PivotChart | a slicer |
| An interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis | PivotTable |
| A graphical representation of the data in a PivotTable | Pivot Chart |
| A row at the end of an Excel table that is used to calculate summary statistics (such as sum, average, count, maximum, and minimum) for each column in the Excel table. | Total row |
| Using these instead of regular tables makes is easier to rearrange, hide or display data in alternative views: | PivotTable |
| To collapse items in a PivotTable, press this: | minus key |
| To create two subtotals in an Excel table, use the Insert Subtotal command, but uncheck the option ____ in the dialog box. | "to replace subtotals" |
| PivotTable data can be arranged and the content filtered or ___ to emphasize important parts of this data. | pivoted |
| By using a ___ , you can analyze an Excel table and summarize it into a more meaningful form. | PivotTable |
| How does the PivotTable get its name? | The ability to change Row headings to Column positions and vice versa. |
| Step 1 to creat a PivotTable: | Identify the purpose: What kind of summary information should it contain? Also think about alternate information that could be displayed in other PivotTables. |
| Step 2 to creat a PivotTable: | Plan the results to display? What calculation method to use on the data? COUNT, SUM, AVERAGE, MAX, and MIN? |
| Step 3 to create a PivotTable: | Write down the names of the rows and columns you will need in your PivotTable, and a description of the data you want to summarize. |
| It is important to ___ your PivotTable. This makes it easier to retrieve it when neede | name |
| ___ the field on a PivotTable lets you display only the relevant part(s) of the data. | Filtering |
| What is the difference between Summarizing 'Values By' and Showing 'Values As'? | Values by refers to method of calculation. Values as refers to how data is displayed - as a % for example. |
| A ___ is a graphic representation of a PivotTable. | PivotChart |
| The ___ report layout displays all fields from the ROWS area in a single column and indents the items from each field below the outer fields. It is the default layout. | Compact Form |
| In the ___ layout, each field in the ROWS area takes a column in the PivotTable and the subtotals for each group appears above every group. | Outline Form |
| To select a different report layout, click the Report Layout button in the Layout group on the ____ tab. | PivotTable Tools Design |
| A PivotTable ______ then uses statistical functions such as SUM() and COUNT() to summarize the data. | groups data into categories |
| How are fields such as revenue, costs, and profits most likely to appear in a PivotTable? | Fields with numeric data are placed in the VALUES area |
| How are fields such as region, state, and country most likely to appear in a PivotTable? | Fields with non-numeric data are placed in the ROWS area |
| How to add fields to a PivotTable: | Drag the required field from the upper section to the lower section or click the checkbox next to the desired field |
| Fields in the ___ area of the PivotTable Fields Pane create a filtered view of the PivotTable, showing summarized data in the report. | FILTERS |
| Fields in the ___ area of the PivotTable Fields Pane are displayed as columns at the top of the PivotTable. | COLUMN |
| Fields in the ___ area of the PivotTable Fields Pane are summarized in the PivotTable. | VALUES |
| You create a PivotTable using the ___. | PivotTable Fields pane |
| _____ are the fields that group the values in a PivotTable. ___ appear in PivotTables as row labels, column labels, and report filters. | Category fields |
| Fields in the ____ area are displayed as rows in the PivotTable. | ROWS |
Created by:
WOOLGIRL