Show:
What Function
What Function
Write a Formula
Write a Formula
Operators
100
adds a range of cells together
What is SUM
100
returns the largest amount in a series
What is MAX
100
a formula that adds 2 cells A1 and A22
What is =A1+A22
100
a formula that will times A6 by B8
What is =A6*B8
100
Common Operators
What is +, -, /, *
200
returns the smallest amount in a series
What is MIN
200
gives you the average of a range of cells
What is AVERAGE
200
that will return the largest number between A1 and A22
What is =MAX(A1:A22)
200
that will return the smallest number in the selection of cells B1 to B22
What is =MIN(B1:B22)
200

> and >=

What is greater than and greather than and equal to

300

returns the number of cells with numerical data in them

What is COUNT

300
Returns the number of cells with data in them
What is COUNTA
300
that gives you the amount of cells with numbers in from A1 to A22
What is =COUNT(A1:A22)
300
that gives you the amount of cells with data in from B1 to B22
What is =COUNTA(B1:B22)
300
< and <=
What is less than and less than or equal to
400

reduces the amount of decimal places a number has

What is ROUND

400

returns the amount of blank cells in a range

What is COUNTBLANK

400

that will give you the number of cells that contain the word Exam between B1 and B22

What is =COUNTIF(B1:B22, "Exam")

400

that gives you the amount of blank cells from B1 to B22

What is =COUNTBLANK(B1:B22)

400

$C$4

What is C4 has an absolute reference?

500

returns a logical answer

What is IF

500

keeps the cell referenced in the same place

What is the absolute cell reference?

500

that will say High if the data in A22 is 15 or greater and Low if it isn't

What is =IF(A22>=15, "High", "Low")

500

that will say order more if the stock in B33 is less than 6 or Stock Ok if not less than 6

What is =IF(B33<6, "Order More", "Stock Ok")

500

the order that excel will look at a formula

What is parenthesis, exponents, division and/or multiplication, addition and/or subtraction?