Page 300 - TP_IT_V1.0_C9_flipbpookl
P. 300
The currently active sheet is highlighted and has an active cell.
Status Bar
It gives the status of the sheet in terms of insert or overwrite mode, sheet sequence number, page style and many
more.
Answer the following questions:
uiz Bee 1. Which bar is used to navigate a sheet?
2. What are the actions that can be performed in a sheet?
How can you remove duplicate values in a range of cells in LibreOffice Calc?
CREATING A SPREADSHEET
To work in ‘Calc’, the user needs to know how to work with Spreadsheet. ‘Calc’ opens with a new spreadsheet named
‘Untitled1’ as the default spreadsheet where the user can begin to work or create a new spreadsheet. To do so:
Step 1: Click on the File menu and select the New option.
A sub-menu appears.
Step 2: Click on the Spreadsheet option.
Or
Click on the New button from the Standard toolbar.
A new spreadsheet named Untitled 1 appears on the screen. A new spreadsheet displaying the active sheet Sheet1
appears on the screen with cell A1 as the active cell.
To create a new
Spreadsheet:
Short key Ctrl + N
It will be saved with the given name. The extension of a file in Calc is .ods.
298 Trackpad Information Technology (Ver. 1.0)-IX

