Formulas 101
This function adds up all the numbers in a range.
What is SUM?
In the formula =SUM(A1:A10), the symbol : represents this.
What is a Range (or "Through")?
The IF function has this many parts (arguments) separated by commas.
What is 3? (Logical test, Value if true, Value if false).
If A1=5, A2=10, and A3=15, what is =SUM(A1:A3)?
What is 30?
When creating a chart, the SUM of categories is often visualized as slices in this circular chart type.
What is a Pie Chart?
This function helps you find the single highest grade in a list.
What is MAX?
How would you write a formula to find the average of cells B2, B3, B4, and B5?
What is =AVERAGE(B2:B5)?
In an IF function, text results (like "Pass") must be enclosed in these.
What are Quotation Marks (" ")?
If B1=100 and B2=0, what is =MAX(B1:B2)?
What is 100?
To show the AVERAGE rainfall of 12 different months side-by-side, this chart type is best.
What is a Column (or Bar) Chart?
If you want to find the lowest temperature recorded in a month, you use this function.
What is MIN?
If a range has the numbers 10, 20, and 60, what is the result of =AVERAGE?
What is 30?
What does =IF(10 > 5, "Yes", "No") return?
What is Yes?
Identify the error in this formula: =IF(A1>50, Pass, Fail)
What is Missing Quotation Marks?
This horizontal line on a chart usually represents the categories or time.
What is the X-Axis?
This function calculates the arithmetic mean of a range.
What is AVERAGE?
To find the difference between the highest and lowest numbers in range A1:A10, you would subtract these two functions.
What is =MAX(A1:A10) - MIN(A1:A10)?
Write an IF statement that returns "Pass" if cell A1 is 60 or higher, and "Fail" if it is lower.
What is =IF(A1>=60, "Pass", "Fail")?
What is the result of =MIN(10, 20, 5, 40)?
What is 5?
If you want to show the MIN and MAX stock prices over a year, you would likely use this "point-to-point" chart.
What is a Line Chart?
Every function in Excel must start with this mathematical symbol.
What is the Equal Sign (=)?
This error message appears if you try to use =AVERAGE on a range that contains only text or is empty.
What is #DIV/0!?
This is the term for putting one IF function inside another to check for multiple conditions.
What is a Nested IF?
If =AVERAGE(A1:A4) is 10, what is the value of =SUM(A1:A4)?
What is 40? (4 cells multiplied by an average of 10).
This chart element tells the viewer what each color or bar represents.
What is the Legend?