Use a solver to find the combination of units sold for each product that will result in the maximum profit in cell B1. Use the range name "UnitsSold" as the variable cells, and then open the add constraints dialogue.

Choose an option:

1. Go to the "Data" tab, and select "Solver" to set up the optimization problem.
2. Use the "What-If Analysis" tool and choose "Solver" to configure the problem.
3. Go to the "Formulas" tab, and select "Solver" to set up the problem.
4. Use the "Optimize" tool in the "Data Analysis" menu to set up the problem.

Answer :

Final answer:

To find the combination of units sold for each product that will result in the maximum profit in cell B1, you can use the Solver tool in Excel.

Explanation:

The correct option to find the combination of units sold for each product that will result in the maximum profit in cell B1 is Option 1: Go to the "Data" tab, and select "Solver" to set up the optimization problem.

To use Solver, you need to define the variable cells, which in this case are UnitsSold. Then, you open the add constraints dialogue to set any constraints that need to be considered. Once the problem is set up, Solver will calculate the combination of units sold for each product that maximizes the profit.