Spreadsheet Basics
What do all spreadsheet formulas start with?
An equals sign (=)
What is a cell range?
A group of cells
What does the SUM function do?
Adds numbers together
What does an IF statement do?
Makes a decision based on a condition
=IF(B2<13,"Red",IF(B2<15,"Blue","Green"))
If the age in B2 is 12, which team will be shown?
Red
What is the name of a single box in a spreadsheet?
A cell
How do you write the range from B2 to B6?
B2:B6
Write the formula to add values in B2 to B6.
=SUM(B2:B6)
How many possible outcomes does one IF statement have?
Two (TRUE or FALSE)
=IF(B2<13,"Red",IF(B2<15,"Blue","Green"))
If the age in B2 is 14, which team will be shown?
Blue
What letter identifies columns in a spreadsheet?
Letters (A, B, C…)
Which symbol is used to show a range of cells?
Colon (:)
Which formula is better for many cells:
=B2+B3+B4+B5+B6 or =SUM(B2:B6)?
=SUM(B2:B6)
What is a nested IF?
An IF inside another IF
=IF(B2<13,"Red",IF(B2<15,"Blue","Green"))
If the age in B2 is 15, which team will be shown?
Green
What number identifies rows in a spreadsheet?
Numbers (1, 2, 3…)
In the range B2:B6, what is B2?
The first cell in the range
Can SUM work on non-adjacent cells?
Yes
Why do we use nested IF statements?
To handle more than two conditions
=IF(B2<13,"Red",IF(B2<15,"Blue","Green"))
Why does age 15 go to Green and not Blue?
Because 15 is not less than 15, so the final option is used
What does cell B2 mean?
Column B, Row 2
In the range B2:B6, what is B6?
The last cell in the range
Write a SUM formula for B2, B3, B4, B5, and B6 separately.
=SUM(B2,B3,B4,B5,B6)
In this formula, what is the final option if conditions are false?
=IF(Age<13,"Red",IF(Age<15,"Blue","Green"))
Green
=IF(B2<13,"Red",IF(B2<15,"Blue","Green"))
What happens if B2 is left blank when this formula runs?
The conditions cannot be tested correctly, so the result may be incorrect or default