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...
Exam 77-882: Microsoft Excel 2010 Core
5. Applying Formulas and Functions
5.1. Create formulas: VLookup
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...