Excel Skills: VLookUp, Validation Controls 1. Download the article "Make Excel a Little Smarter from EMU Online 2. Read the section titled "Data in Different Places" a. Create the Bonus Table below on one worksheet and name this worksheet Salary Table". File Home Insert Page Layout Formulas Data Review Xcut Calibri -11AA 1 Copy Paste Format Painter BIU...A .. Clipboard Font 19 B B D E 1 Bonus wN $ 4 5 6 7 8 9 10 11 12 13 14 15 Salesperson Autumn McKenzie Skylar Caitlin Kimberly Thomas LT Lois Jill Nicole Jenna $ $ $ $ $ Sales 2,200 6,300 1,110 9,900 1,110 4,200 2,121 8,900 6,890 6,850 8,000 $ Salary Table Bonus Table Sheet3 Sheet2 She b. Create the Table below on another worksheet and name this worksheet "Bonus Table". Data Review Vio Home Insert Page Layout Formula Xan Calibri Copy Paste BIU. DOA Format Pamer Clipboard Font L7 - X f A B 1 2 3 4 5 $ $ $ $ 6 7 8 9 Sales Amount of Bonus $ 2,000 $ 50.00 5,000 $ 100.00 6,000 $ 500.00 7,000 $ 700.00 8,000 $ 1,000.00 9,000 $ 1,400.00 10,000 $ 1,900.00 $ $ 10 11 12 13 Salary Table Bonus Table Sheet3 Sheet2 Sheet c. In the column "Bonus" on the Salary Table tab-use the VLookUp function to calculate the amount of bonus each employee should receive. i. -vlookup(lookup_value, table_array,col_index_num,range_lookup) Download the article Block that Spreadsheet Error Read the article, especially the section "Raising the Flag" Add the following data validation controls to your spreadsheets, including explanatory input and error messages. 2. Sales on the Salary Table tab must be positive and cannot excel $10,000 b. Amount of bonus on the Bonus Table tab must be nonnegative and cannot exceed 20% of the sales on that same table