Solver is now present in the Analysis group on the Data tab.What was done to add Solver to the Ribbon?
A) Linear programming options were enabled in Excel Options.
B) All Add-ins were enabled on the Tool menu.
C) The Solver Add-in was enabled from Add-ins on the Tools menu.
D) A what-if analysis was created,which enabled the Solver Add-in.

Question

Quizplus · Accepted Answer

The Solver Add-in was enabled from Add-ins on the Tools menu. This is the correct way to add Solver to the Ribbon. Linear programming options being enabled in Excel Options is a separate setting that does not directly affect the appearance of the Solver button on the Ribbon. Enabling all Add-ins does not specifically address the Solver Add-in. Creating a what-if analysis may trigger the use of Solver, but it does not add Solver to the Ribbon on its own.

Solver Is Now Present in the Analysis Group on the Data