Excel Vocabulary 5.6 - 5.10

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

Calculations applied to values in a spreadsheet. Simple mathematical operations to complex statistical calculations

With functions, what are the values inside of the parentheses called?

A workbook tool that displays the contents of the active cell; it can be used to enter new values and formulas.

Arranging data based on its alphabetical or numerical order.

A shortcut to some of Excel’s most common features.

A feature in Excel that automatically performs a calculation (like addition) on a group of numbers.

A function that adds together all of the values in a goup of numbers based on a given criteria

Formatting that is applied to cells that meet certain criteria.

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

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

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

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

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

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

A computational procedure that performs a specific operation.

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

Basic math operations like addition (+), subtraction(-), multiplication (*), and division(/).

Identifying cells in a spreadsheet formula based on the location of the formula, rather than the location of the cells.

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

Which function counts the number of cells within a range that meet the given criteria.

A method of identifying cells in a spreadsheet formula based on their locations, rather than the location of the formula

A column chart that compares data values across categories.

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

A function that evaluates a condition as TRUE or FALSE, then returns a unique result for each outcome.

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

A function that calculates the average value of a group of numbers based on a given criteria.

Chart based on PivotTable data

Chart features such as the title, axis labels, and data labels.