Excel Features and Functions

Front

AutoFilter

Back

A feature that allows you to filter records in a worksheet by specifying filter criteria.

Front

AutoSave

Back

A feature that creates versions of your workbook to recover it in case of power failure or accidental deletion.

Front

Calculated Fields

Back

Simple formulas using math operators to create new data based on existing data in a pivot table.

Front

Comment

Back

Similar to a post-it note, used to annotate a worksheet with information for yourself or others.

Front

Conditional Summary

Back

A summary function applied only to a given range of cells that meet specific criteria.

Front

Consolidating Data

Back

The process of summarizing multiple ranges of data into a single range, from various sources.

Front

Data Series

Back

Each set of data used in a graphical chart.

Front

Data Slicers

Back

Buttons you can click to filter data in a table or pivot table.

Front

Global Options

Back

Options and settings you can specify in Excel that affect all workbooks.

Front

Insert Function

Back

Helps you select the desired function to perform calculations in Excel.