Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: VLookup

Create the Lookup Table

This Lookup table has two columns: Sales and Percent.

 

2. Try it: Add data to the table

Enter the following values:

Sales

Percent

 $  2,500.00

5%

 $  5,000.00

10%

 $  7,500.00

15%

 $10,000.00

20%

Keep going, please...