Page 202 - Trackpad 402_Class-X_Final
P. 202
Step 5: Click on Keep Result button. This will change the values of the cells to get the desired 95%. The worksheet
after the changes will appear as follows:
LINKING DATA AND WORKSHEETS
Linking the worksheets is done to access data present in the different sheets of the same workbook or in different
workbooks. This data is needed for calculation and data analysis. OpenOffice Calc gives you the facility of using data
from multiple worksheets at the same time.
As you known that a file in OpenOffice Calc is known as a workbook. A workbook by default has 3 worksheets named
as Sheet1, Sheet2 and Sheet3.
Setting up Multiple Sheets
If you want to add a new worksheet, then follow the given steps:
Step 1: Select a sheet where you want the sheet to be inserted after it or before it.
Step 2: Click on Insert menu and select Sheet option.
OR
Right-click on Sheet tab and select Insert Sheet option.
OR
Click on an empty block just after Sheet3.
The Insert Sheet dialog box appears with following options:
202 Trackpad Information Technology-X

