80.2K

Verified Solution

Link Copied!

im so stuck

Mar weving Erough Unit 6.2 in the Trotlosek: \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{8}{|c|}{ The company has the following policy. If a salesperson sells less than $8,000 in } \\ \hline 2 & \multicolumn{8}{|c|}{ a given month, the salesperson is not eligible for a bonus. If a salesperson sells } \\ \hline 3 & \multicolumn{8}{|c|}{$8,000 or more but less than $11,000 in goods, the salesperson is eligible for a $200 bonus. } \\ \hline 4 & \multicolumn{8}{|c|}{ If a customer buys more than $11,000 but less than $15,000 in goods, the salesperson } \\ \hline 5 & \multicolumn{8}{|c|}{ is eligible for a $500 bonus. If a salesperson sells $15,000 or more in goods, the } \\ \hline 6 & \multicolumn{8}{|c|}{ salesperson earns $1,000 bonus. } \\ \hline 7 & & & & & & & & \\ \hline 8 & \multicolumn{8}{|c|}{ Use the VLOOKUP function to complete the following table. At the left is the "Sales Bonus } \\ \hline 9 & \multicolumn{8}{|c|}{ Process." At the right is the Salesperon name and monthly sales. } \\ \hline 10 & \multicolumn{8}{|c|}{ Under the "Bonus" column, enter a formula to compute the amount of bonus. The } \\ \hline 11 & \multicolumn{8}{|c|}{ formula should be copied down. Do not enter a formula for each customer individually. } \\ \hline 12 & & & & & & & & \\ \hline 13 & \multicolumn{2}{|c|}{ Sales Bonus Process } & & Salesperson & Monthly Sales. & Bonus & & \\ \hline 14 & & & & Craig Jang & 15,750 & & & \\ \hline 15 & Sales & Bonus & & Jamie Ott & 5,420 & & & \\ \hline 16 & 0 & 0 & & Joshua Arcudi & 9,240 & & & \\ \hline 17 & 8000 & 200 & & Maddie Pierce & 17,560 & & & \\ \hline 18 & 11000 & 500 & & Maxine Knight & 11,175 & & & \\ \hline 19 & 15000 & 1000 & & MichelleLiu & 8,785 & & & \\ \hline 20 & & & & & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer