Basic Stuff
Formulas
Functions
Formatting
Charts and Visuals
100
The name for each square on a spreadsheet.
What is a cell?
100
All formulas start with this.
What is the equal sign?
100

What is the name of the function you use for addition?

What is SUM?

100

The name of the tool used to copy formulas to multiple cells or continue a series

What is Autofill?

100

Which chart type is best for showing portions of a whole?


Pie Chart


200
Columns (up and down) are "named" by these.
What is a letter?
200

You must hit this button on your keyboard to make the formula calculate

What is the Enter key?

200

This comes after the name of the function

What is a parenthesis?

200

A predefined design for a cell is called a ______

Cell Style

200

Which tab contains chart formatting tools?


Chart Design

300

The cell in the worksheet that is currently selected for data entry

What is an active cell?

300
Formulas must always have these
What are mathematical symbols?
300

These functions are use to find the highest and lowest values in a cell range

What are MIN and MAX?

300

When you want to move a cell in Excel your mouse should look like this.

What is the white hand?

300

What feature allows you to filter chart data visually?

Chart Filters

400

A _________ is made up of multiple worksheets.

What is a workbook?

400
* is the mathematical symbol for _______
What is multiplication?
400

This function returns the number of cells that contain numeric values

What is COUNT?

400

This will clear the contents of a row/column, but will not delete the row/column.

What is clear?

400

A small, in-cell chart showing trends

Sparkline(s)

500
The name of the box in the upper right corner that displays the name of the active cell.

What is the Name Box?

500

All formulas must use cell references? (True or False)

What is the True?

500

What is the name of the function that calculates the mean of a cell range

What is AVERAGE?

500

Numbers that are not used in calculations. When you place an ' in front of the number.

What is a numberic label?

500

What is the term for labeling exact values on a chart?


Data Labels