The parameters of a function.

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

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

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.

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

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

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

A graphical representation of numeric data in a worksheet.

The entire chart and all its elements.

A sheet that contains only a chart.

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

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

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)

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

A graphical representation of the data in a PivotTable.

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

A tool that offers Excel users the ability to generate PivotTables very quickly on very large data sets of tens or even hundreds of millions of rows.

A term that describes when two tables have a connection between two fields.

A tool that filters the entire PivotTable, restricting the sums, counts, averages, and so on, to only those fields selected in the slicer or filter field.

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map