Page 246 - open office
P. 246
It is used for entering and editing the formula in the cell. Formula bar consists of:
Name box: It displays the cell reference, for example A1 or D1 .
Functions wizard: It consists of a list of available functions that we can search .
Sum: It is used to find the total of the numbers in the cells above the selected cell. The sum is placed in the
selected active cell.
Function: It lets you click on the Function icon and inserts an equals (=) sign into the selected cell.
Input line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the
cell contents. Click in the area and, then type the changes. To edit within the current cell, just double-click
in the cell.
Cell Pointer
The active cell in a worksheet is known as the Cell Pointer. It remains highlighted with bold border in the active
worksheet.
Active cell: The selected or activated cell is referred to as the active cell which is always highlighted with a
thick border. The address of the active cell is displayed in the name box for example, A1. In a spreadsheet,
active cell is the place where data is entered. Before entering any data in the cell, it has to be first selected by
placing a cursor on it. Then, when we position the mouse cursor on a cell, it gets selected and is ready to take
data from the user or perform editing.
Cell Address
Each cell has a unique address which identifies its location. A cell address is identified with its column position
followed by its row number. For example, A5 is the cell address that is a combination of column A and row
5 .
Name Box
It lies beside the Formula Bar. It contains the address of the current cell or active cell.
Status Bar
It lies at the bottom of the screen. It shows the current status of an active application.
Sheet Tabs
It lies below the active sheet of the screen. The names of the worksheets appear in the sheet tabs at the
bottom of the workbook. Click on the specific sheet tab to open it.
Horizontal Scroll Bar
It lies below the worksheet at the right side of the ‘Sheet’ tabs. It helps to view the worksheet screen by
moving the scroll button from left to right and vice-versa.
Vertical Scroll Bar
It lies towards the right side of the worksheet. It helps to view the worksheet by moving the scroll button from
top to bottom and vice-versa.
TYPES OF DATA
To begin working with a spreadsheet package, the user has to feed data. Data can be classified into numeric,
alpha-numeric or text, date/time and formula.
246 Touchpad Information Technology-IX

