Question:

Answer:

Question:

Answer:

Question: Add a calculated field to this PivotTable to calculate the total pay for each employee (=Salary+Bonus). Name the new field Total Pay.

Answer:

Question: Install the Solver add-in

Answer: You opened the backstage view, clicked the Options navigation button, clicked the Add-Ins tab, and clicked Cell 9x0. Inside the Excel Options dialog, you clicked the Go… button. Inside the Add-ins dialog, you checked the Solver Add-in check box, clicked the OK button.

Question: Create a new scenario to reflect a change in cell B9 to value of 0.01 Name the scenario Low COLA.

Answer: