A special worksheet that contains a chart with data from another worksheet but no data of its own.

A chart that compares data values across categories.

A chart type where data points are connected by lines to show changes in values over time.

A chart type that displays data values as parts of a whole by dividing a circle into proportional sections.

A feature in Excel that recommends an appropriate chart type based on the data selected.

Formatting that is applied to cells that meet certain criteria.

A restriction that excludes certain values from being computed or displayed.

Arranging data based on its alphabetical or numerical order.

Formatting option that lets you easily sort, filter, and total your data.

Let you customize a table’s look, style, and features.

A grouping feature in Excel that makes it easy to collapse and expand data.

A function that looks up a value from a vertical list.

A fluid report that can summarize and answer questions about a complex data set

An easy-to-use filter that can be added to a PivotTable report.

A chart based on the values in a PivotTable.