Show:
Features
Formulas
Functions
Formatting
Misc.
100
This is used to find and correct errors in a worksheet.
What is debugging?
100
This is used to indicate the start of a formula.
What is an equal sign?
100
This function displays the highest value in a range.
What is the max function?
100
This is a predetermined set of colors, fonts, chart styles, cell styles, and fill effects.
What is theme?
200
This is a symbol in the far left of a cell with spaces between it and the first digit.
What is a fixed dollar sign?
200
This function is one that adds all the values in a range and divides by the number of values.
What is average?
200
This function allows one to apply formatting to a cell that meets only specified conditions.
What is conditional formatting?
200
This is used to import data into a worksheet that is stored on a Web site.
What is a web query?
300
This is located on the Ribbon and used to display the color palette.
What is the fill color button?
300
This is displayed next to a cell when a formula error occurs.
What is the trace error button?
300
This displays the lowest value in a range of values.
What is the Min Function?
300
This button is located on the Ribbon and displays the borders gallery.
What is the borders button?
300
This is a true or false statement that is composed of two values and a relation operator.
What is a condition?
400
This adjusts the width of the column to fit the widest entry.
What is best fit?
400
This symbol stands for multiplication.
What is an asterisk?
400
This symbol is used to override order of operations.
What is parentheses?
400
This format inserts a comma every three positions to the left of the decimal point/
What is comma style format?
400
This is a dot on the screen that contains a color.
What is a pixel?
500
This checks a worksheet for spelling errors.
What is spell checker?
500
This symbol makes a fixed cell in a formula.
What is a dollar sign?
500
This function adds all the values in a range together.
What is a sum?
500
This button on the Ribbon is used to center text in the cell.
What is the center button?
500
This cell has a numerical value of zero.
What is a blank cell?