The spreadsheet below includes information about Our Store: the products $($Column A$),$ product category $($Column B$),$ quantity sold $($Column C$),$ agent name $($Column D$),$ and bonus for agent based on quantity sold $($Column E$).$ There are two tables that hold additional information: The Category Table $($A$1$:B$6)$ and the Bonus Amount Table $($D$1$:E$6).$

SS$-$SLookup.png

$($a$)$ In order to calculate the value in Cell B$10,$ a VLOOKUP function is used. The value calculated for B$10$ will be dragged down Column B for all other products. Write the correct VLOOKUP formula for B$10.$

$($b$)$ The value in Cell E$10$ is based on the quantity sold. The bonus amount is found by using the Bonus Table $($D$1$:E$6).$ The agent receives no bonus if the Quantity Sold is under $200$; a bonus of $$25$ if the Quantity Sold is between $200$ and $399$; a bonus of $$60$ if the Quantity Sold is between $$400$ and $$649$; and a bonus of $$85$ if the Quantity Sold is $$650$ or more. Write the VLOOKUP formula to calculate the bonus amount displayed in E$10,$ which will then be filled$-$down into the cells in the rest of the column.

Write the formula$($s$)$ and$/$or function$($s$)$ exactly as they would be typed on an Excel spreadsheet cell.