Module 1
Module 2/3
Module 3
Module 4a
Moduel 4b
100

An animation effect that moves an object along a predefined path that you create for it

Change History

100

Arrange in a line or bring into alignment.

Align

100

Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.

Table Array

100

A line bordering the chart plot area used as a frame of reference for measurement.

Axis

100

 A row or column of data represented by a line, set of columns, bars, or other chart type.

Data Series

200

Text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.

Password

200

 An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

Conditional Formatting

200

A range of cells in a worksheet that contains related data and can be used by a lookup function.

Table

200

A graphical representation of numeric data in a worksheet.

Chart

200

 A chart that uses the left side (or top) of the chart as one value axis (y-axis) and the right side (or bottom) of the chart as a second value axis (y-axis)

Dual Axis Chart

300

A workbook set up to allow multiple networked users to view and make changes simultaneously.

Shared Workbook

300

Two or more cells combined into a single cell.

Merged Cells

300

 A condition you specify to limit which records are returned when filtering data.

Criteria


300

The entire chart and all its elements.

Chart Area

300

A chart placed on a worksheet rather than on a separate chart sheet.

Embedded Chart

400

A password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.

Strong Password

400

An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.

Lookup Functions

400

The parameters of a function.

Arguments

400

A sheet that contains only a chart.

Chart Sheet

400

A graphical representation of the data in a PivotTable.

Pivot Chart

500

 A feature that marks and records changes made to a workbook.

Track Changes

500

A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.

Rules Manager

500

A formula in which the result is determined by the presence or absence of a particular condition.

Conditional Formula

500

Text that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell.

Data Label

500

A highly configurable table that condenses large amounts of data. is used to analyze and display numerical data in detail and to answer unforeseen questions about data

Pivot table

M
e
n
u