Title: Learning Objectives
Course: Introduction to Spreadsheets (TEMPLATE) > Section: Competency Modules

Upon completion of this competency, the students should be able to:

- Use the IF function
- Use the AND function
- Use the OR function
- Use structured references in formulas
- Nest the IF function
- Use the VLOOKUP function
- Review the HLOOKUP function
- Use the IFERROR function
- Use conditional formatting to highlight duplicate values
- Summarize data using the COUNTIF, SUMIF, and AVERAGEIF functions