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 amount 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 is absolute
500
returns a logical answer
What is IF
500
keeps the cell referenced in the same place
What is the absolute cell reference - - - Bonus Points what is $A1, A$1, $A$1
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 ()brackets first, then /,*,+,_ BODMAS
M
e
n
u