Page 167 - Computer - 10(A&B)

Write T for True and F for False statements.

1. Data consolidation helps to gather data from different worksheets into a single worksheet.

2. Several scenarios can be easily defined on a single worksheet.

Session 2

Link Data and Spreadsheets

When you open a new workbook, by default, it has a sheet named ‘Sheet1’, which is managed using tabs at the
bottom of the spreadsheet. Calc provides the ability to link cells of same or different worksheets in the same or
different workbook.

Setting up Multiple Sheets
Calc provides options to manage and work with multiple sheets in different ways.

Adding New Worksheet
If you want to have more worksheets, you can do it like this:

Step 1: Click and select the sheet using Sheet tab before which you want to insert a new sheet.
Step 2: Right-click on it and choose Insert Sheet option from the shortcut menu. The Insert Sheet dialog box
appears.

49