A formula that uses more than on arithmetic operator.
What is a Complex Formula
100
The function that find the biggest number in the range of selected cells.
What is MAX
100
The button that you press to add all the numbers in a range.
What is the SUM Button
100
A temporary storage area that holds the selections you copy or cut
What is the Clipboard
200
A special, predefined formula that provides a shortcut for a commonly used or complex calculation.
What is a Function
200
The function that adds all the number and divides it by the number of cells in a range
What is AVERAGE
200
A cell address that refers to a cell's location in relation to the cell containing the formula and that automatically changes to reflect the new location when the formula is coped or moved.
What is Relative Cell Reference
200
This button clears the contents of the selected cells
What is Delete
200
Lets you move or copy data from one cell to another without using the Clipboard
What is the Fill handle
300
A set of instructions used to perform one or more numeric calculations.
What is a Formula
300
The function that finds the smallest number in a selected range.
What is MIN
300
The location of a cell, expressed by cell coordinates
What is Cell address
300
This button joins selected cells into a larger cell
What is Merge & Center
300
The key you press to copy while dragging and dropping selected cells.
What is Ctrl
400
The function that returns the number of cells in a range that contain numeric data.
What is COUNT
400
List five functions used in Excel
What is MAX, MIN, AVERAGE, SUM, and COUNT
400
A cell reference that combine both absolute and relative cell addressing.
What is Mixed Cell Reference
400
This button allows you to insert rows or columns in a worksheet.
What is the Insert Button
400
Two features you use to enter a function.
What is Insert Function Button and Sum list arrow
500
A function that adds a range of cells.
What is SUM
500
=MAX(B4:B9)
What is MAX
500
A cell address that refers to a specific cell and does not change when you copy a formula.
What is an Absolute Cell Reference
500
The button on the formula bar that lets you add formulas
What is formula button
500
The cell reference that changes when it is copied.