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

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

- Copy formulas
- Build formulas containing relative, absolute, and mixed references
- Review function syntax
- Insert a function with the Insert Function dialog box
- Search for a function
- Type a function directly in a cell
- Use the COUNT and COUNTA functions to tally cells
- Use Auto-fill to ﬁll in a formula and complete a series
- Enter the IF logical function
- Insert the date with the TODAY function
- Create an exact match lookup with VLOOKUP function
- Perform what-if analysis using trial and error and Goal Seek