Create a Sales spreadsheet ()pen a new worksheet and rename it Bonus Add the fol
ID: 3694925 • Letter: C
Question
Create a Sales spreadsheet ()pen a new worksheet and rename it Bonus Add the following labels across Row 1: Add the names of the sales reps in Column A: Alex. Connie. Elizabeth. and Niki Add the following sales data in Column B. format Column D for currency and Column E for percent Add the following data: Name the Range: Select cell D1 through E5 and use the Name Box to name the range: Sales Calculate the Bonus Percent with the Sales lookup table Select cell C2 and go to Formulas Rightarrow Insert Function From the category list, choose Look.up and Reference, find VLookup The first argument asks: 'Where is the data? The sales data for Alex is Cell B2. The second argument asks: "Where is the look up table?" For the range, type the name "Sales" (or use the red. white and blue Find button to go to the spreadsheet to select the cells D1 through E5) The third argument asks: "Where are the answers?" In our two column Sales table, the correct percents are located in Column 2. Calculate the Bonus Check Now all of the pieces are in place to figure out how much bonus the sales reps receive. Select Cell F2 and enter the following equation = B2*C2Explanation / Answer
Reps Sales Bonus percent Goal percent Bonus check Alex 3,500 0.05 2,500 5% 175 Connie 8,310.00 0.15 5,000 10% 1246.5 Elizabeth 8,170.00 0.15 7,500 15% 1225.5 Niki 13,560.00 0.2 10,000 20% 2712 Deeler 3,500.00 0.05 175