What does =SUMIF do?
Gives the sum of a range with one matching criteria
What does the =CONCAT function do?
Links together the content of multiple cells
What does the =COUNT function do?
Counts cells with numbers in a range
What does =XOR do?
Returns false if only one condition is true.
What does the =COUNTA function do?
Counts all cells in a range that has values, both numbers and letters
What does the =AND function do?
Returns TRUE or FALSE based on two or more conditions
What kind of graph is this?
Bar graph
What does =SUM do?
Gives the sum of a range.
What does the =IF function do?
Returns values based on a TRUE or FALSE condition
What does the =MAX function do?
Returns the highest value in a range
What does =RAND do?
Generate a random number.
What does =MIN do?
Find the lowest number in a range.
What kind of graph is this?
Pie graph
What does the =COUNTIF function do?
Counts cells as specified
What kind of chart is this?
Line chart
What does the =AVERAGE function do?
Calculates the average (arithmetic mean)
What does =OR do?
Checks a range to see if EITHER condition is true or false
What does =SUMIFS do?
Gives the sum of a range with multiple matching criteria
What kind of chart is this?
Scatterplot
What does the =COUNTIFS function do?
Counts cells in a range based on one or more TRUE or FALSE condition
What does =MODE do?
Find the mode of a range (the number that appears the most.)
What does =MEDIAN do?
Find the median (middle) number.
What does =NPV do?
Uses a percentage reference to return a net total.