Page 54 - IT-802_class_12
P. 54
Open Edit File Show Draw
Print Cut Paste Hyperlink Functions Data
New Save Page Autospell Undo Redo Short Navigator Sources
Preview Check Copy Descending
Gallery Zoom
Document Export Spelling and Format Short Chart Find and Help
as e-mail Directly Grammar Paintbrush Ascending Replace
as PDF
Ð ÐStatus Bar: It lies at the bottom of the screen. It shows the current status of an active worksheet.
Ð ÐFormatting Toolbar: It lies below the Standard toolbar. It contains shortcut buttons that provide quick access to
frequently used formatting options that help to change the appearance of the text or data inside the sheet.
Ð ÐName Box: It is located beside the Formula Bar. It contains the address of the current cell or active cell.
Ð ÐFormula Bar: All the data that is entered by the user appears in the formula bar.
Ð ÐRow: A row is a horizontal arrangement of cells. There is a total of 1048576 rows in a single worksheet of Calc.
Ð ÐColumn: A column is a vertical arrangement of cells. Columns are labelled from left to right. There are 1024 columns
available in a single worksheet of Calc.
Ð ÐCell: A cell is the intersection of a row and a column in the worksheet where data is entered by the user. It is
identified by its column letter and row number. An active cell is a cell that is currently being edited.
Ð ÐCell Address: Each cell has a unique address called the cell address, which is formed by the intersection of row
number and column letter. For example, a cell formed by the intersection of column F and row 5 will have the
address F5.
3.3.2 Creating a New Spreadsheet
To work in Calc, the user needs to know how to work with a spreadsheet. Calc opens with a new spreadsheet named
Untitled1 as the default spreadsheet where the user can begin work or create a new spreadsheet. To do so, perform
the following steps:
1 Open OpenOffice Calc.
2 Click on the File menu from the Menu bar. A submenu appears.
3 Click on New and select the Spreadsheet option from the submenu. A new spreadsheet will be created.
2
3
You can also create a new spreadsheet by clicking on the New icon from the Standard toolbar.
52 Touchpad Information Technology-XII

