Question

What are various ‘what-if’ tools available in Calc?

Answer 1

Select the cells that contain the values that will change between scenarios. ...
Choose Tools > Scenarios.
On the Create Scenario dialog, enter a name for the new scenario. ...
Optionally add some information to the Comment box. ...
Optionally select or deselect the options in the Settings section.

Answer 2

Answer:

what are car various what if tool available in calc