Page 274 - Computer - 10(A&B)

• Click Scenarios option from the Tools menu.

• In the Create Scenario dialog box, type a name for the scenario, and in the Comment box, type a short
description for the scenario. Click the Ok button to create the scenario.
• Repeat the process to create two more scenarios with tax and bonus rate as 12% and 15%, and 12% and 20%
respectively.

• Click the Scenario list down arrow and choose a scenario.

• Change the values in the Tax rate and Bonus rate cells for the selected scenario. The changes are saved
automatically.

• Select each scenario and to see how the data changes.
• Save your work.

Project 2
Create a simple profit model in LibreOffice Calc to find out how many products you need to sell to reach a
specific profit amount using the Goal Seek feature.
• Launch LibreOffice Calc on your computer and create a new spreadsheet with the structure as shown in the
given image. The formula used in cell E2 to calculate the profit is = (B2 – C2)*D2.
156