Question

write the steps to carryout solver option in spreadsheet​

Answer 1

In Excel for Mac 2011: Click the Data tab, under Analysis, click Solver. After you define a problem, in the Solver Parameters dialog box, click Options. Select the Show Iteration Results check box to see the values of each trial solution, and then click OK. In the Solver Parameters dialog box, click Solve.