Contents

OVERVIEW... 5

IF STATEMENTS. 6

REVIEW EXERCISE.. 11

NESTED IF. 12

REVIEW EXERCISE.. 15

EMBEDDED IFS. 16

REVIEW EXERCISE.. 20

IFERROR and IFNA.. 21

AND, OR and NOT.. 24

REVIEW EXERCISE.. 27

REVIEW QUESTIONS. 28

SUMIF. 29

REVIEW EXERCISE.. 31

AVERAGEIF. 32

COUNTIF. 34

THE PLURALS. 37

REVIEW EXERCISE.. 42

REVIEW QUESTIONS. 43

GLOSSARY.. 44

EXAM... 46

INDEX.. 49

EXPLANATIONS TO REVIEW QUESTIONS. 50