Test yourself
Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.
The logical_test argument can only return either True or False.
True.
False.
In the value_if_true and value_if_false arguments, use quotation marks around numbers.
True.
False.
How many possible outcomes are there with a single IF statement?
One.
Two.
Three.
If you copy a formula down a column, and need a cell reference to stay the same (for example, you don’t want B2 to change to B3, what type of cell reference do you need?
Relative.
Absolute.
