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.