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 in Excel Options.
C) The Solver Add-in was enabled in Excel Options.
D) A what-if analysis was created,which enabled the Solver Add-in.

Question

Quizplus · Accepted Answer

Enabling the Solver Add-in in Excel Options is the necessary step to add Solver to the Analysis group on the DATA tab. Linear programming options and creating a what-if analysis may be related to the use of Solver, but they are not the steps required to add it to the ribbon. Enabling all add-ins may not necessarily include the Solver Add-in specifically. Therefore, the best choice is C.

Solver Is Now Present in the Analysis Group on the DATA