Excel Review

SmartArt Graphic

An Excel feature that provides a visual representation of your information and ideas.

PivotTable

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

Numbers sorted from highest to lowest are sorted in:

Descending order

To import data from Access into an Excel Data Model, use the __________ command.

Get External Data

Refresh

The command to update a worksheet to reflect new data.

When you create a template, Excel adds the file extension:

.xltx

Record

All of the categories of data pertaining to one person, place, thing, event, or idea

Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the ___________.

Data Model

A language web browsers can interpret

HTML

A ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart.

PivotChart

The Excel feature that suggests charts based upon your data.

Recommended Charts

To organize data in a particular order is to:

Sort

Slicer Header

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

A predesigned set of colors, fonts, lines, and fill effects that look good together is a:

Theme

The area in the layout section of the PivotTable Fields pane where data is summarized is the:

VALUES area

Ascending

Values sorted from A to Z

The numbers along the left side of a chart display on the:

Vertical value axis

The default file format for Excel 2016:

.xlsx

Template

A workbook used as a pattern for creating other workbooks.

Database

An organized collection of facts related to a specific topic

The ____________ button removes a filter from a slicer.

Clear Filter

Command used to move to a specific cell or range of cells in a large worksheet:

Go To

Comparison Operators

The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values

Extract

To pull out multiple sets of data for comparison

Trendline

A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.

Data Point

A value that originates in a worksheet cell and that is represented by a data marker in a chart.

The operator that requires each and every one of the comparison criteria that you specify must be true is the:

And comparison operator

The ____________ is a report in a workbook that is graphically represented in a PivotChart.

Associated PivotTable

Chart Elements

Objects that make up a chart.

The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is:

Scaling

Source Data

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

Primary Key

The field used to uniquely identify a record in an Access table.

Layout Section

The lower portion of the PivotTable Fields pane where you build the PivotTable report by rearranging and repositioning fields.

Query

The term that refers to asking a question of the data in a database

Wildcard

A character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records

Embedded Chart

A chart that is inserted into the same worksheet that contains the data used to create the chart.

PivotChart

A graphical representation of the data in a PivotTable.

Data Series

A group of related data points that are plotted in a chart.

Axis

A line that borders the chart plot area and serves as a frame of reference for measurement.

AutoFilter Menu

A menu of filtering commands that displays when you click one of the filter arrows in an Excel table

Data Model

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

PivotTable Fields Pane

A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.

One possible source of data for a PivotTable is a(n):

Access Database File

VALUES Area

An area to position fields that contain data that is summarized in a PivotTable or PivotChart report.

A visual representation of numeric data in a worksheet is a:

Chart

PivotTable field names are formed from the source data's:

Column Titles

A sort order that you can define is a:

Custom list

A diagram that shows a continual process.

Cycle

Slicer

Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.

The area where you place the results when copying the results of a filter to another location in the worksheet:

Extract area

The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the:

FILTERS area

A single piece of information that is stored in every record:

Field

Slicers are used to:

Filter Data

The command that locates and selects specific text, formatting, or type of information within a workbook quickly is:

Find

A diagram used to create an organization chart is a:

Hierarchy

Objective Cell

In Solver, a cell that contains a formula for the results you are trying to determine, usually defined as a minimum, a maximum, or a specified value.

Decision variables

In Solver, cells that will change to achieve a desired result.

Interval

In a moving average, the number of cells to include in the average.

Gridlines

Lines in the plot area of a chart that aid the eye in determining plotted values.

A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a:

Pane

The area of a chart bounded by the axes.

Plot area

The process of locking cells in a workbook so that users cannot make any changes is:

Protection

Freeze Panes

The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet

Sparklines

Tiny charts that fit within a cell and give a visual trend summary alongside your data.

A feature with which you can insert decorative text into your worksheet is:

WordArt

To work with multiple tables in Excel, a __________ must be created between the tables.

relationship

Legend

A chart element that identifies the patterns or colors that are assigned to the categories in the chart.

Add-ins

Optional commands and features that are not immediately available and must be installed or activated to use.

An optional element added to a template to prevent someone from disabling a worksheet's protection is a:

Password

A(n) __________ chart illustrates the relationship of each part to a whole.

Pie

The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row:

Tab deliminated text file

PDF (Portable Document Format)

The file type developed by Adobe Systems that is a visual representation of a document

To prevent a user from making changes to an Excel worksheet, use the ___________ command so that the worksheet is not visible.

Hide

Cells in a worksheet that cannot be edited are:

Locked cells

A term sometimes used to refer to the first sort level in the Sort dialog box is:

Major sort

Rotation Handle

A circle that displays on the top side of a selected object used to rotate the object up to 360 degrees.

CSV file (Comma Separated Values File)

The file type that saves an Excel file so that there is a comma between each cell and a paragraph return at the end of each row

Criteria

The term used for conditions that you specify that must be matched for the record to be included in the search results

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 PivotTable.

The graphic element that represents a single data point is a:

Data Marker

The column and row headings selected that describe the values in a chart.

Labels

A type of chart that shows trends over time.

Line

Field Names

The column titles from source data that form the categories of data for a PivotTable.

Scale

The range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.

Cell Styles

A set of formatting characteristics that you can apply to a cell

Field

A single piece of information for every record.

Column Chart

A type of chart that shows comparisons among related data.

Solver

A what-if analysis tool that can help you find an optimal value for a formula in one cell—subject to constraints on the values of other formula cells on a worksheet.

Scenario Manager

A what-if analysis tool that compares alternatives.

The value that determines the spacing between the gridlines in the plot area of a chart.

Major Unit Value

Arrange All

The command that tiles all open program windows on the screen

The data for a PivotTable should be in the format of a:

List

Break even

A point at which an entity covers its costs and starts to make a profit.

Filter

A process by which you can limit the display of data to only specific information.

Chart Sheet

A separate worksheet used to display an entire chart.

Moving Average

A sequence of averages computed from parts of a data series that smoothes fluctuations in data to show a trend more clearly.

Hyperlink

Colored and underlined text that, when clicked, takes you to another location in the worksheet, to another file, to a Web page on the Internet, or on your organization's intranet

Fixed Expenses

Expenses that remain the same each month.

Variable expenses

Expenses that vary depending upon the amount of sales.

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:

Field Buttons