Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The spreadsheet below includes information about Our Store: the products ( Column A ) , product category ( Column B ) , quantity sold (
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:B and the Bonus Amount Table D:E
SSSLookup.png
a In order to calculate the value in Cell B a VLOOKUP function is used. The value calculated for B will be dragged down Column B for all other products. Write the correct VLOOKUP formula for B
b The value in Cell E is based on the quantity sold. The bonus amount is found by using the Bonus Table D:E The agent receives no bonus if the Quantity Sold is under ; a bonus of $ if the Quantity Sold is between and ; a bonus of $ if the Quantity Sold is between $ and $; and a bonus of $ if the Quantity Sold is $ or more. Write the VLOOKUP formula to calculate the bonus amount displayed in E which will then be filleddown into the cells in the rest of the column.
Write the formulas andor functions exactly as they would be typed on an Excel spreadsheet cell.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started