## Module 4

4.1 Functions and the Formulas Tab in Excel 2016

4.2 Insert Function Tool

4.3 The AND Function; Practice Exercise 5 Concerning the AND function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.

4.4 The OR Function; Practice Exercise 6: Concerning the OR function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.

4.5 The IF Function; Practice Exercise 7: Concerning the IF function, we will use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument; Practice Exercise 8: Create an IF formula using the IF function in a table

4.6 Nested IF Function; Practice Exercise 9: Create an IF formula using nested IF functions to create additional conditions

4.7 VLOOKUP and HLOOKUP Functions; Practice Exercise 10: Use a VLOOKUP table for applying approximate matching data

4.8 Using VLOOKUP Function for Finding an Exact Match; Practice Exercise 11: Use a VLOOKUP table for applying exact matching data

4.2 Insert Function Tool

4.3 The AND Function; Practice Exercise 5 Concerning the AND function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.

4.4 The OR Function; Practice Exercise 6: Concerning the OR function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.

4.5 The IF Function; Practice Exercise 7: Concerning the IF function, we will use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument; Practice Exercise 8: Create an IF formula using the IF function in a table

4.6 Nested IF Function; Practice Exercise 9: Create an IF formula using nested IF functions to create additional conditions

4.7 VLOOKUP and HLOOKUP Functions; Practice Exercise 10: Use a VLOOKUP table for applying approximate matching data

4.8 Using VLOOKUP Function for Finding an Exact Match; Practice Exercise 11: Use a VLOOKUP table for applying exact matching data

Module 4 Learning Objectives:

Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:

Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:

- Imitate the instructor’s actions for creating VLOOKUP AND HLOOKUP FORMULAS
- Describe how VLOOKUP and HLOOKUP functions operate
- Describe how the Insert Function is used to create correct syntax construction for Excel functions
- Imitate the instructor’s action in appropriate use of the Insert Function feature for constructing formulas and functions
- Describe what functions and formulas are used for data analysis
- Describe how formulas are nested to create additional functionality in a formula