Level 246 Level 248
Level 247

Using Data Tables & Pivot Tables


50 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
Data Table
An arrangement of data in which each row represents a case and each column represents a variable.
One-variable
data table shows results for formulas in which only one argument is changed.
What does a one-variable table do?
allows you to view several possible results for a problem at once in one table.
fill, borders, and conditional formatting
You can use what to enhance the readability of a data table?
En dash
a typographical symbol used to mark ranges of labels or values. It is slightly longer than a hyphen.
pointer
highlight cells rules conditional formatting to format cells in the data table that match the current fee and profit.
TABLE function, an array formula.
The Data Table command inserts the...
array
a picture that uses rows (---) and columns (I) to show a multiplication problem
Array formulas may be called
CSE formulas, because you must press [Ctrl]+[Shift]+[Enter] to complete them
True
You cannot delete or edit an individual cell in the array. True or False
True
You can delete the entire table or edit input values. True or False.
only the results-not the array formula
When you copy the table and paste it to another location the copy shows
Two-variable has how many sets of input values
two: one in a row and one in a column. The data table has one formula, placed above the column values and left of the row values.
PivotTable
a summary report that can be sorted and filtered
A PivotTable is a
worksheet in which you can sort, filter, and calculate large amounts of data. You can reposition row and column data to create different summaries of the data.
list range
A PivotTable is created from a
A PivotTable enables you to
slice and dice large amounts of data
drill-down
You can______________ into the data to review small pieces of data.
options and design
PivotTable Tools command tabs
Column label
area in the PivotTable that shows labels for the values in a row above the values.
Values
fields from the list that are summarized. They are usually numeric.
Row label
Area in the PivotTable that shows labels for the values in a column to the left of the values.
Report filter
Fields shown in row 1 by which the entire PivotTable can be filtered.
Field
Data category from the original list range. There can be row, column, page, and/or data fields.
Item
A subcategory of a PivotTable field.
True
Fields can be moved to other locations in the PivotTable. True or False.
True
Repositioning the data creates different summaries of data. True or False
True
The Date field is set as a report filter. True or False.
Each field has
settings. They include the name and the type of calculation.
totals and data.
Field settings include the placement of
default
Calculated fields in PivotTables are summed by
place the field twice as a Values field.
In order to include a sum and an average for a field you should
Slice
a small section or piece of data in a PivotTable.
What does a slice enable you to do?
to focus on a data of particular interest in a large PivotTable. Tool is new in Excel 2010 and enables you to segment the PivotTable to see only what you need at any given moment.
A slice initially includes
all items from the field
drilled down
When you select one or more items in the Slice shape the data is
Although a PivotTable is associated with a list range is does not..
automatically update if changes are made to the source list. (use the refresh button on the PivotTable Tools Options tab)
A PivotChart is a graph that
illustrates data from its associated PivotTable in the same workbook.
A PivotChart is also
interactive because you can reposition series and categories from the same PivotTable Field List Pane.
True
You can pivot and filter data in the PivotChart. True or false.
Legend Fields
Area in the PivotChart that shows labels for the legend items.
Axis fields
Area in the PivotChart that displays the chart categories.
Field Filter button
Filter button for the values and axis fields, shown at the left side of the PivotChart
False
A data table and a PivotTable use the same data source.
True
The Slicer tool is an on-screen filter for a PivotTable.
True
Custom calculations in a PivotTable include percentages and rankings.
False
Each PivotTable in a workbook must have a separate list as its data source.
True
In a one-variable data table, the input values can be in a row or a column.
True
The PivotChart Tools command tabs include the same Design, Layout, and Format tabs as a regular chart.
False
To delete a field from a PivotTable, click its name in the PivotTable Field List and press Delete.