Practical 9 : Scenarios in LibreOffice Calc

Scenarios in in LibreOffice Calc comes under what-if analysis tools, where we are able to get different values for output by changing the input cells. Here, we have a table with Classes , Subjects and Marks .

Now we will perform scenarios, the steps are: –

1. Select the range of cells that are input and will be changed. Here, is
   Marks . —->Go to Tools —–> Scenarios
2. Give the scenario desired name, check Prevent changes and
   uncheck Copy back. Click on OK.
3. Repeat step 2 to add more scenarios and we can see the output
   changing.