Excel Skills Jeopardy

This basic function adds up a range of numeric cells, and is one of the most commonly used formulas in Excel.

What is SUM?

This function calculates the arithmetic mean of a range of numbers.

What is AVERAGE?

This function counts how many cells in a range contain numbers.

What is COUNT?

This function evaluates a condition and returns one value if it is true and a different value if it is false.

What is IF?

This lookup function works like its more common cousin, but searches the first row of a range horizontally, its initial letter standing for that direction.

What is HLOOKUP?

This two-key shortcut instantly saves the current workbook without opening a menu.

What is Ctrl+S?

This two-key shortcut copies the currently selected cells to the clipboard.

What is Ctrl+C?

This two-key shortcut undoes the most recent action taken in a workbook.

What is Ctrl+Z?

This single key, found at the top of the keyboard, recalculates every open workbook and refreshes formula results.

What is F9?

This two-key shortcut opens the Format Cells dialog box, giving access to number formats, borders, and alignment options all in one place.

What is Ctrl+1?

This type of chart uses vertical rectangles of varying height to compare values across categories.

What is a column chart?

This type of chart displays data as slices of a circle, showing each category's share of a whole.

What is a pie chart?

This type of chart connects data points with a continuous line, commonly used to show a trend over time.

What is a line chart?

This type of chart plots two numeric variables against each other as individual points, useful for spotting a correlation.

What is a scatter plot?

This compact, cell-sized chart fits inside a single cell and shows a data trend without taking up its own dedicated chart space.

What is a sparkline?

This feature lets a user summarize, group, and reorganize a large dataset into a compact interactive table without writing formulas.

What is a PivotTable?

This area of the PivotTable field list determines which field's unique values become the summarized rows down the left side of the table.

What is the Rows area?

This area of the PivotTable field list determines which numeric field gets summed, averaged, or otherwise aggregated in the table's body.

What is the Values area?

This companion chart type automatically visualizes the data summarized in a PivotTable and updates when the table's filters change.

What is a PivotChart?

This interactive on-sheet button lets a user filter one or more connected PivotTables by clicking a value, rather than opening a dropdown menu.

What is a slicer?

This formatting feature automatically changes a cell's appearance, such as its color, based on a rule applied to the cell's value.

What is conditional formatting?

This formatting tool copies just the appearance, such as font and color, from one cell or range to another without copying the underlying content.

What is Format Painter?

This feature locks specified rows or columns in place so they stay visible on screen while the rest of a large worksheet scrolls.

What is Freeze Panes?

This built-in number format displays a value as a share of one hundred by multiplying it and appending a percent sign.

What is Percentage format?

This formatting feature applies a coordinated set of fonts, colors, and borders to a range all at once, and lets the whole range be filtered and sorted as a single unit.

What is Format as Table?

This function removes leading, trailing, and repeated extra spaces from a text string, leaving single spaces between words.

What is TRIM?

This feature scans a selected range and removes any rows that are exact duplicates of another row.

What is Remove Duplicates?

This tool splits the contents of a single column into multiple columns based on a delimiter such as a comma or a space.

What is Text to Columns?

This feature restricts what can be typed into a cell, such as allowing only whole numbers within a set range, to prevent bad entries.

What is Data Validation?

This function converts text that represents a number, often pulled in from another system, into an actual numeric value Excel can calculate with.

What is VALUE?