They want to add marks students for wise for the three subject separately suggest a suitable option from OO.Calc
Answers
Answer:
Tools > Scenarios opens a dialog with options for creating a scenario. To create a new scenario:
Select the cells that contain the values that will change between scenarios. To select multiple ranges, hold down the Ctrl key as you click. You must select at least two cells.
Choose Tools > Scenarios.
On the Create Scenario dialog, enter a name for the new scenario. It’s best to use a name that clearly identifies the scenario, not the default name as shown in the illustration. This name is displayed in the Navigator and on the title bar of the scenario on the sheet itself.
Creating a scenario
Optionally add some information to the Comment box. The example shows the default comment. This information is displayed in the Navigator when you click the Scenarios icon and select the desired scenario.
Optionally select or deselect the options in the Settings section. See below for more information about these options.
Click OK to close the dialog. The new scenario is automatically activated.
You can create several scenarios for any given range of cells.
Settings
The lower portion of the Create Scenario dialog contains several options. In most cases the default settings (shown selected in the example) are likely to be suitable in most situations.
Display border
Places a border around the range of cells that your scenario alters. To choose the color of the border, use the field to the right of this option. The border has a title bar displaying the name of the active scenario. Click the arrow button on the right of the scenario name to open a drop-down list of all the scenarios that have been defined for the cells within the border. You can choose any of the scenarios from this list at any time.
Copy back
Copies any changes you make to the values of scenario cells back into the active scenario. If you do not select this option, the saved scenario values are never changed when you make changes. The actual behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.
Explanation: