BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Subtotal
Displays summary calculation of values for a category in a column. MUST SORT FIRST
before calculating.
grouping
A process of joining related rows or columns of related data into a single entity so that
groups can be collapsed or expanded by data analysis.
data mining
the process of analyzing large volumes of data to discover patterns and identify trends
in the data.
Data Mining Steps
1. Define the problem 2. Identify required data 3. prepare and pre-process 4. model the
data 5. train and test 6. verify and deploy
Pivot Tables
Dynamic
Pivot tables
A dynamic and interactive table that uses calculations to consolidate and summarize
data from a data source into a separate table. Pivot tables are used to analyze data
without altering the data itself.
Pivot Table Process
1. Create a Pivot Table 2. Adjust Field Settings 3. Format a pivot table 4. refresh a pivot
table 5. Create a pivot chart
FILTERS area
Displays top-level filters above the PivotTable so that you can set filters to display
results based on conditions you select.
COLUMNS area (Pivot Table)
Displays columns of summarized data for the selected field(s). When you drag a field to
the Columns area, the PivotTable displays one column of data for each unique value
contained in the dataset.
ROWS area (Pivot Table)
Groups the data into categories in the first column based on the selected field(s). Each
unique text entry is listed only one time in alphabetical order in the first column
regardless of how many times the text is present in the original dataset. These labels
identify the content on each row.
values area in pivot table
Displays summary statistics, such as totals or averages, for the selected field. The
default function is SUM for quantitative fields. If you select a field containing labels, the
default function is COUNT to count the number of text entries within each category.
GETPIVOTDATA function
A function that extracts data from specified fields in a PivotTable. The GETPIVOTDATA
function is used to obtain the summary data that is visible in a PivotTable. The function
contains two required arguments: data_field and pivot_table. The data_field argument is
the name of the field in the PivotTable that contains the data you want to retrieve. The
GRADED
Subtotal
Displays summary calculation of values for a category in a column. MUST SORT FIRST
before calculating.
grouping
A process of joining related rows or columns of related data into a single entity so that
groups can be collapsed or expanded by data analysis.
data mining
the process of analyzing large volumes of data to discover patterns and identify trends
in the data.
Data Mining Steps
1. Define the problem 2. Identify required data 3. prepare and pre-process 4. model the
data 5. train and test 6. verify and deploy
Pivot Tables
Dynamic
Pivot tables
A dynamic and interactive table that uses calculations to consolidate and summarize
data from a data source into a separate table. Pivot tables are used to analyze data
without altering the data itself.
Pivot Table Process
1. Create a Pivot Table 2. Adjust Field Settings 3. Format a pivot table 4. refresh a pivot
table 5. Create a pivot chart
FILTERS area
Displays top-level filters above the PivotTable so that you can set filters to display
results based on conditions you select.
COLUMNS area (Pivot Table)
Displays columns of summarized data for the selected field(s). When you drag a field to
the Columns area, the PivotTable displays one column of data for each unique value
contained in the dataset.
ROWS area (Pivot Table)
Groups the data into categories in the first column based on the selected field(s). Each
unique text entry is listed only one time in alphabetical order in the first column
regardless of how many times the text is present in the original dataset. These labels
identify the content on each row.
values area in pivot table
Displays summary statistics, such as totals or averages, for the selected field. The
default function is SUM for quantitative fields. If you select a field containing labels, the
default function is COUNT to count the number of text entries within each category.
GETPIVOTDATA function
A function that extracts data from specified fields in a PivotTable. The GETPIVOTDATA
function is used to obtain the summary data that is visible in a PivotTable. The function
contains two required arguments: data_field and pivot_table. The data_field argument is
the name of the field in the PivotTable that contains the data you want to retrieve. The
