Answers
Using a spreadsheet to answer business questions, such as which products sell best.
A test that checks whether a cell contains exact words, such as White or Paris.
A function that shows one result when a test is true and another result when it is false.
The result shown by a function when its test is not met.
A character that shows how two values relate, for example equal to or greater than.
The part of a function that is checked to see if it is true or false.
The result shown by a function when its test is met.