Chapter 5 Flashcards
Whole sale in a business context means selling a product in small quantities to end users.
-true or false
false
Which of the following tools is best suited for data mining and summarizing data?
PivotTable
Which of the following is not true about PivotTables?
PivotTables automatically refresh data
What does the Values Area of a PivotTable do?
Displays summary statistics, such as totals or averages
Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?
Filtering
Which of the following is not true regarding data mining?
Exports data
Which of the following is the best tool for analyzing employee performance over a period of time?
PivotTable
Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force?
% of Grand Total
A row within the dataset containing at least one aggregated value
Subtotal
The process of joining rows or columns of related data together into a single
entity
Grouping
Displaying all information in a grouped data set
Expand
Restricting the view of a grouped data set
Collapse
A hierarchical structure of data
Outline
contains two sections that allow for the editing of a PivotTable
PivotTable Fields task pane
Organizes and groups data into categories on the left side. Each group name occupies a single row.
Rows Area
Displays summary statistics, such as totals or averages
Values Area
filters the data to display results based on particular conditions you set
Filters Area
subdivides data into one or more additional categories
Columns area
