Saturday, July 23, 2022

Home Class X IT Class 10 IT | Chapter - Spreadsheet | Topic - Scenarios Open Office Calc

Class 10 IT | Chapter - Spreadsheet | Topic - Scenarios Open Office Calc

Arvindz Eclass Saturday, July 23, 2022 Class X IT,

What is 'what if scenarios' in OpenOffice calc?

In ‘What if scenario’ a set of values are changed to predict some results, which spreadsheet save automatically with scenario names.

These are the steps for ‘what if scenario’
1) Create a table in a spreadsheet.
2) Select the table.
3) Go to ‘Tools’ tab.
4) Select ‘Scenarios’ option.
5) In ‘Create Scenarios box’ give scenarios name.

Create Scenarios box

6) Now for other scenarios, change the Principal amount and repeat same steps (2 - 5).

--------------------------------------------------

Other Topic of this Chapter

-------------------------------------------------

What is ‘What if multiple operations tools’ in OpenOffice Calc?

What if multiple operations is used to make many scenarios unlike in what if scenarios two or three values could be changed. The multiple operations tool creates a formula array a separate set of cells that give all the alternative results.

These are the steps to use multiple operations:
1) Create a table,
2) Type values as row input cell or column input cell,
3) Select the column input cell,

--------------------------------------------------