Create a one variable data table on the left to find the projected profit at different...

Transcribed Image Text:

Create a one variable data table on the left to find the projected profit at different price increases in cells C13:C23. Now, complete cells F13:F23 using only cell referencing. Number of Units Unit Cost Total Cost Price Increase Projected Profit Price Increase 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100% $40 $600 15 40% $840 Projected Profit $840 $900 $930 $960 $990 $1,020 $1,050 $1,080 $1,110 $1,140 $1,170 $1,200 Use a one-variable Data Table Price Increas 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100% Projected Profit $840 $300 $330 $360 $390 $420 $450 $480 $510 $540 $570 $600 Use Cell Referencing Create a one variable data table on the left to find the projected profit at different price increases in cells C13:C23. Now, complete cells F13:F23 using only cell referencing. Number of Units Unit Cost Total Cost Price Increase Projected Profit Price Increase 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100% $40 $600 15 40% $840 Projected Profit $840 $900 $930 $960 $990 $1,020 $1,050 $1,080 $1,110 $1,140 $1,170 $1,200 Use a one-variable Data Table Price Increas 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100% Projected Profit $840 $300 $330 $360 $390 $420 $450 $480 $510 $540 $570 $600 Use Cell Referencing

Answer rating: 100% (QA)

The image provided shows a spreadsheet where the task is to create a onevariable data table to find ... View the full answer