TE An auditor found an expense receipt for $181.34 without a name. Write a left table lookup function that would identify the sales rep in the Travel Expenses data Click the icon to view the Travel Expenses data Write a left table lookup function that would identify the sales rep in the Travel Expenses data. Fil in the missing expense receipt value and find the expression that should be used in cell F3 to identify the sales rep in the Travel Expenses data that coincides with the expense receipt Type an integer or a decimal. Do not round) D 1 Day (March 2014) Sales Rep Expenses 171.28 2 6 Smith Expense Name 3 22 Jones 150.83 Jones 146.34 Simth 130.90 Rogers 232.26 Smith 67.72 Jones 261.79 Smith 112.50 Crawford 139.76 4 S 6 7 . 9 10 12 0 11 16 16 19 20 Travel Expenses Day (March 2014) Sales Rep Smith Jones Jones Smith Rogers Smith Jones Smith Crawford Crawford Jones Crawford Rogers Smith Jones 6229 11 16 16 69928T223 19 20 Expenses 171.28 159.83 148.94 130.90 232.26 87.72 261.79 112.58 139.76 220.20 166.86 237.61 201.27 134.91 93.34 S 11 16 16 19 29 2 28 7 2 20 3 29 14 18 25 28 Rogers Smith Jones Smith Crawford Crawford Jones Crawford Rogers Smith Jones Jones Rogers Crawford Crawford Rogers 232.26 87.72 261.79 112.58 139.76 220.20 166.86 237.61 201.27 134.91 93.34 267.19 234.58 206.13 109.69 181.34 TE An auditor found an expense receipt for $181.34 without a name. Write a left table lookup function that would identify the sales rep in the Travel Expenses data Click the icon to view the Travel Expenses data Write a left table lookup function that would identify the sales rep in the Travel Expenses data. Fil in the missing expense receipt value and find the expression that should be used in cell F3 to identify the sales rep in the Travel Expenses data that coincides with the expense receipt Type an integer or a decimal. Do not round) D 1 Day (March 2014) Sales Rep Expenses 171.28 2 6 Smith Expense Name 3 22 Jones 150.83 Jones 146.34 Simth 130.90 Rogers 232.26 Smith 67.72 Jones 261.79 Smith 112.50 Crawford 139.76 4 S 6 7 . 9 10 12 0 11 16 16 19 20 Travel Expenses Day (March 2014) Sales Rep Smith Jones Jones Smith Rogers Smith Jones Smith Crawford Crawford Jones Crawford Rogers Smith Jones 6229 11 16 16 69928T223 19 20 Expenses 171.28 159.83 148.94 130.90 232.26 87.72 261.79 112.58 139.76 220.20 166.86 237.61 201.27 134.91 93.34 S 11 16 16 19 29 2 28 7 2 20 3 29 14 18 25 28 Rogers Smith Jones Smith Crawford Crawford Jones Crawford Rogers Smith Jones Jones Rogers Crawford Crawford Rogers 232.26 87.72 261.79 112.58 139.76 220.20 166.86 237.61 201.27 134.91 93.34 267.19 234.58 206.13 109.69 181.34