cmpsc exam 2

subtotal

a summary calculation of values for a category

subtotal row

a row that contains one or more aggregate calculations for each category within a dataset

outline

a hierarchical structure of data that you can group related data to summarize

grouping

a process of joining related rows or columns of related data into a single entity so that groups can be collapsed or expanded

data mining

the process of analyzing large volumes of data to identify trends and patterns in the data

PivotTable

An interactive table that uses calculations to consolidate and summarize data from a data source to enable a person to analyze the data in a dataset without altering the actual data

PivotTable Fields task pane

A window that displays the fields in a dataset that enables a user to specify what fields are used to create a layout to organize the data in columns, rows, values, and filters in a PivotTable

Filters area

A section within the PivotTable Fields task pane used to place a field so that the user can then filter the data by that field

Columns area

A section within the PivotTable Fields task pane used to display summarized data in vertical columns for the selected field(s) in a PivotTable

Rows area

A section within the PivotTable Fields task pane used to group data into categories in the first column based on selected field(s) in a PivotTable

Values area

A section within the PivotTable Fields task pane used to place a field to display summary statistics, such as totals or averages in a PivotTable

GETPIVOTDATA function

A function that returns a summary value from a PivotTable

Slicer

A window listing all unique items in a field so that the user can click a button to filter data by that item or value

Slicer caption

The text or field name that appears as a header or title at the top of a slicer to identify the data in that field

PivotTable timeline

A small window that starts with the first date and ends with the last date in the data source. It contains horizontal titles that you can click to filter data by day, month, quarter, or year

Calculated field

A user-defined field that performs a calculation based on other fields in a Pivot Table

PivotTable style

A set of formatting that controls bold, font colors, shading colors, and border lines within a PivotTable

Data model

A collection of related tables that contain structured data used to create a database

Relationship

An association created between two tables where both tables contain a common field of data

PivotChart

A graphical representation of aggregated data derived from a PivotTable

Binding constraint

A constraint that Solver must enforce to reach the target value

Changing variable cell

A cell containing a variable whose value changes until Solver optimizes the values in the objective cell

Solver

An add-in application that manipulates variables based on constraints to find the optimal solution to a problem

One-variable data table

A data analysis tool that provides various results based on changing a single variable

Scenario

A set of values that represent a possible situation

Objective cell

the cell that contains the formula-based value that you want to maximize, minimize, or set to a value in Solver

Optimization model

this data analysis technique finds the highest, lowest, or exact value for one particular result by adjusting values for selected variables

Nonbinding constraint

A limitation that does not restrict the target value that Solver finds

What-if analysis

The process of changing variables to observe how changes affect calculated results

Variable

An input value that you can change to see how that change affects other values

Substitution value

A value that replaces the original value of a variable in a data table

constraint

a limitation that imposes restrictions on solver

add-in

a program that can be added to excel to provide enhanced functionality

Scenario Summary report

A worksheet that contains scenario results

Two-variable data table

A data analysis tool that provides results based on changing two variables

Goal seek

A tool that identifies the necessary input value to obtain a desired goal

Scenario Manager

A what-if analysis tool that enables to to define and manage scenarios to compare how they affect results

Range name

A word or string of characters that represents one or more cells