Vocabulary
Formulas
Functions
Concepts Review
Miscellaneous
100
These are predefined worksheet formulas.
What are functions?
100
This is the symbol on the keyboard (that can be typed in)used to make a cell reference change from relative to absolute.
What is $ (the dollar sign)?
100
You would use this button to quickly insert the SUM function.
What is the AutoSum button?
100
This type of cell reference changes when it is copied.
What is relative?
100
SUM and AVERAGE are examples of these.
What are functions?
200
This type of cell reference is when Excel is recording the input cells in relation to the formula cell.
What is relative?
200
This key changes a relative formula to an absolute formula.
What is F4?
200
This function can be used to obtain fewer decimals in the cells.
What is round?
200
This item on the Ribbon opens a dialog box or task pane.
What is the launcher?
200
True or False: To enter a function into a cell, you can manual type the function, including its arguments, into the cell.
What is True?
300
This type of cell reference is when the reference does not change when you copy the formula.
What is absolute?
300
To change the order of precedence in a formula, you use these. (Hint: Keyboard)
What are parentheses?
300
This feature makes it easier to enter function names because it suggests functions depending on the first letters you type.
What is the AutoComplete feature?
300
This lets you copy cell contents or continue a series of data into a range of selected cells. (HINT: Two words)
What is the fill handle?
300
All functions in Excel begin with this?
What is = (Equals sign)?
400
This is a feature that lets you fill cells with specific elements of the copied cells.
What is Auto Fill?
400
In a complex formula, multiplication is performed before this.
What is addition?
400
This function finds the highest number in the range you selected.
What is MAX?
400
You can use any of the following features to enter a function except: Insert Function Button Formula AutoComplete AutoSum button list arrow Clipboard
What is the Clipboard?
400
True or False: When you cut cells, the original data remains in the original location.
What is False?
500
This type of formula uses more than one arithmetic operator.
What is complex?
500
In complex formulas, funcations should be performed in which order: (Choose one) Left to Right Right to Left
What is Left to Right?
500
Clicking the _______ button on the Function Arguments dialog box minimizes the dialog box so you can select cells in the worksheet.
What is collapse?
500
This is the key you press to copy while dragging-and-dropping selected cells.
What is Control?
500
This is the file extension for Excel 2007 templates?
What is .xltx?
M
e
n
u