Page 173 - CA 165 ver 1.0 Class 9
P. 173
NF: Add Deci- Increase
Align Right mal Places Indent
Style and Merge Decrease Background
Formatting Font Name Font Size Italic Align Left Cells NF: Percent Indent Color
Bold Underline Justified NF: Standard Borders Font Color
Align Center NF: Currency Delete Decimal
Places
Formula Bar
‘Formula Bar’ lies below the formatting toolbar. It displays the content of the active cell. Formula that
perform different calculations in cells are entered and displayed here. It is denoted by ‘fx’.
Cell Pointer
The active cell in a worksheet is highlighted with a thick boundary called the Cell Pointer.
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 besides 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. We can 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 or enter data in a worksheet. Based
on which type of data is being stored, data can be classified into numeric, alpha-numeric or text, date/
time and formula.
DATA
Numeric Alphanumberic Date/Time Formula
Working with Spreadsheet 171

