Show:
Formatting
Surprise
Formulas
Functions
General
100
The blinking vertical line that indicates where the next typed character will appear.
What is insertion point (or cursor)?
100
Key that you must hit in order to display the result (or calculation) of a formula
What is the ENTER key?
100
The small green square located in the lower-right corner of the heavy border around the active cell
What is Auto Fill handle?
100
A function that displays the lowest value in a range.
What is MIN (or minimum) function?
100
The default view in Excel.
What is Normal View?
200
The feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
What is AutoCorrect?
200
Symbol that separates the beginning and ending cell references in a range.
What is the colon symbol?
200
A selection of two or more adjacent cells in a column or row or a rectangular group of cells
What is a Range?
200
Function that adds all of the numbers in a range of cells to calculate a total
What is SUM function?
200
The view that allows you to modify a worksheet while viewing how it will look in printed format?
What is Page Layout View?
300
Symbol that displays when the text is longer than the width of a column?
What is the "pound sign" or "hashtag symbol"?
300
Function that allows you to display the highest value in a selected range.
What is MAXIMUM?
300
This must be typed before entering a formula so that Excel knows that you are entering a formula or function and not text
What is the equal (=) symbol?
300
Function sums the numbers in the specified range and then divides the sum by the number of numeric values in the range
What is the AVERAGE function?
300
combining two or more cells into one cell
What is Merging?
400
Formatting option that allows you to create Rules that will determine and automatically apply the desired formatting
What is Conditional Formatting?
400
Symbol used to indicate multiplication in an Excel formula.
What is the asterisk (or star) symbol?
400
A prewritten formula that is built into Excel
What is a Function?
400
You can see this if you double-click a cell with a formula built into it.
What is the Formula?
400
Identifies the area where one page ends and the next page begins.
What are Page Breaks?
500
Key combination that will allow you to see all formulas entered into a spreadsheet rather than the resulting values.
What is CTRL + ACCENT MARK (`)?
500
You can apply this type of formatting to a spreadsheet with financial data in order to display the $ sign.
What is Currency (or Accounting) formatting?
500
Can be used to check which cells are referenced in a the formula assigned to the active cell.
What is the Range Finder?
500
How cells are named in an Excel spreadsheet.
What is Letter + Number?
500
Button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting
What is Formatting Options?