Chapters 7 & 8 Excel Vocabulary

VALUES area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

Layout section

The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable

Interval

The number of cells to include in the average.

Slicer Header

The top of a slicer that indicates the category of the slicer items

Field Section

The upper portion of the PivotTable fields pane containing the fields-column titles-from your source data; use this area to add fields to and remove fields from the Pivot Table

Filter

To limit the display of data to only specific info

Transpose

To switch the data in rows and columns.

Business Intelligence tools

Tools that can be used to perform data analysis and create sophisticated charts and reports

AND function

a logical function that can be used to develop compound logical tests using up to 255 arguments

Break-even point

the point at which a company starts to make

Filtering button

A button on a slicer which you use to select the item by which to filter

Clear Filter

A button that removes a filter

Dual-axis chart

A chart that has one series plotted on a secondary axis.

Nested function

A function that is contained inside another function

Logical function

A function that tests for specific conditions.

PivotChart report

A graphical representation of the data in a PivotTable report

OR function

A logical function that can be used to develop compound logical tests using up to 255 arguments. The function returns a value of TRUE if ANY of the conditions are met.

SUMIF function

A logical function that contains one logic

COUNTIF function

A logical function that counts the cells that meet specific criteria in a specified range.

Data Model

A method of incorporating data from multiple, related tables into an Excel worksheet

Forecast

A prediction of the future, often based on past performances.

Moving average

A sequence of averages computed from parts of a data series.

Scenario

A set of values that Excel saves and can substitute automatically in your worksheet.

Quick Explore

A tool that allows you to drill down through PivotTable data with a single click

Scenario Manager

A what-if analysis tool that compares alternatives.

Solver

A what-if analysis tool with which you can find an

Integer

A whole number.

PivotTable Fields pane

A window that lists, at the top, all of the fields-column titles-from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable

FILTER area

An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report

Fixed expense

Expense that remains the same each month regardless of the amount of activity.

Variable expense

Expense that varies depending on the amount of sales.

Field button

A button on a Pivot Chart with an arrow to choose a filter , and thus change the data that is displayed in the chart

Source data

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source

COLUMNS area

An area to position fields that you want to display as columns in the PivotTable report. Field names places here becomes column titles, and the data is grouped in columns by these titles

ROWS area

An area to position fields that you want to display as rows in the PivotTable report. Field names places here become row titles, and the data is grouped by these row titles

Relationship

An association between tables that share a common field

PowerPivot

An excel Bl tool that allows to to analyze data from multiple sources, work with multiple data tables, and create relationships between tables

Power View

An exel Bl tool that allows you to create and interact with multiple charts, slicers, and other data visualizations in a single sheet

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data

Add-in

An optional command or feature that is not immediately available ; you must first install and/or activate an add-in to use it.

Slicer

Easy-To-Use filtering control with buttons that enable you to drill down through large amounts of data

NOT function

If the condition is false, true is returned.

Decision variable

In Solver, a cell in which the value will change to achieve the desired results.

Variable cell

In Solver, a cell in which the value will change to achieve the desired results.

Objective cell

In Solver, a cell that contains a formula for the results you are trying to determine.

Constraint cell

In Solver, a cell that contains a value that limits or restricts the outcome.

Constraint

In Solver, a condition or restriction that must be met.

Associated PivotTable report

The PivotTable report in a workbook that is graphically represented in a PivotChart

Canvas

The area of a Power View worksheet that contains data visualizations

Syntax

The arrangement of the arguments in a function.

Field names

The column titles from source data that form the categories of data for a Pivot Table

Refresh

The command to update a worksheet to reflect the new data