BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Group and Ungroup Data
Group rows or columns of related data into an outline
Expand or collapse groups depending on your focus
Excel will not create an outline or group data if the dataset does not contain a formula
Subtotaling Data
The Subtotal feature creates an outline, where categories can be collapsed or
expanded. Outline buttons are used to determine which values are displayed.
Outline—hierarchical data structure created by the Subtotal feature
Categories can be collapsed or expanded
Outline buttons control which summary statistics are displayed
Data Mining
Data mining is a process
Analyzes large volumes of data
Uses advanced statistical techniques
Identifies trends and patterns
PivotTable: Excel's interactive data- mining feature
Why use a PivotTable?
PivotTables summarize data using functions: SUM, COUNT, AVERAGE, MIN, MAX,
PRODUCT, 0COUNT NUMBERS, STDEV, STDEVP, VAR & VARP
PivotTables are dynamic
Data can be rearranged
Details can be expanded or collapsed
Data can be organized and grouped differently
Row and column categories can be switched
Analyzing Data with PivotTables
A PivotTable is an interactive table that enables you to group and summarize either a
range of data or an Excel table into a concise, tabular format for easier reporting and
analysis
Filtering PivotTable Fields
Filtering a field lets you focus on a subset of items in that field
You can filter field items in the PivotTable by clicking the field arrow button in the
PivotTable that represents the data you want to hide and then uncheck the check box
for each item you want to hide
What process do PivotTables support?
Data Mining
GRADED
Group and Ungroup Data
Group rows or columns of related data into an outline
Expand or collapse groups depending on your focus
Excel will not create an outline or group data if the dataset does not contain a formula
Subtotaling Data
The Subtotal feature creates an outline, where categories can be collapsed or
expanded. Outline buttons are used to determine which values are displayed.
Outline—hierarchical data structure created by the Subtotal feature
Categories can be collapsed or expanded
Outline buttons control which summary statistics are displayed
Data Mining
Data mining is a process
Analyzes large volumes of data
Uses advanced statistical techniques
Identifies trends and patterns
PivotTable: Excel's interactive data- mining feature
Why use a PivotTable?
PivotTables summarize data using functions: SUM, COUNT, AVERAGE, MIN, MAX,
PRODUCT, 0COUNT NUMBERS, STDEV, STDEVP, VAR & VARP
PivotTables are dynamic
Data can be rearranged
Details can be expanded or collapsed
Data can be organized and grouped differently
Row and column categories can be switched
Analyzing Data with PivotTables
A PivotTable is an interactive table that enables you to group and summarize either a
range of data or an Excel table into a concise, tabular format for easier reporting and
analysis
Filtering PivotTable Fields
Filtering a field lets you focus on a subset of items in that field
You can filter field items in the PivotTable by clicking the field arrow button in the
PivotTable that represents the data you want to hide and then uncheck the check box
for each item you want to hide
What process do PivotTables support?
Data Mining
