Show:
Functions
Formats
Misc
Format 2
Formulas
100
sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
What is the Average Function
100
inserts a fixed dollars sign in the far left of the cell, comma, and two decimal places.
What is the Accounting Format
100
finding and correcting errors in the worksheet.
What is debugging
100
if the condition is true, then Excel applies the formatting, if the condition is false, then Excel suppresses the formatting
What is Conditional Formatting
100
this automatically happens to all cells with formulas every time you enter a value into a cell in the worksheet
What is recalculates
200
displays the highest value in a range
What is Max Function
200
inserts a floating dollar sign immediately to the left of the first number, comma, and two decimal places.
What is Currency Format
200
a prewritten formula to help with formulas
What is a function
200
Click this in the Conditional Formatting gallery to display the New Formatting Rule dialog box
What is New Rule
200
+ - / * % ^
What are operators
300
displays the lowest value in a range
What is the Min Function
300
inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
What is the Comma Format
300
a dot on the screen that contains a color and its size is based on the screen’s resolution.
What is a Pixel
300
If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of
What is 1932
300
8 * (3 + 2)
What is 40
400
diagram of a function
What is =Function Name(Arguments)
400
predetermined set of colors, fonts, chart styles, cell styles, and fill effects
What is a Theme
400
values inside parenthesis used in a function
What is arguments
400
This button on the Ribbon instructs Excel to display additional decimal places in a cell.
What is Increase/Decrease Decimal
400
A blank cell in Excel has this numerical value
What is Zero
500
Used to toggle between the values version and the formulas version of a worksheet
What is CTRL Accent Mark `
500
The default width of a cell
What is 8.43
500
This keyboard short cut wraps text in a cell
What is Alt Enter
500
If true, then Excel applies the formatting. If false, then Excel suppresses the formatting.
What is a Condition
500
This is followed from left to right when more than one arithmetic operator is involved in a formula
What is Order of Operation