Page 185 - CA_165_V2.0_C9_Flipbook
P. 185
NF: Add Decimal Increase
Align Right Place Indent
Styles 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 NF: Delete
Horizontally Decimal Place
Formula Bar
Formula Bar lies below the formatting toolbar. Formula that perform different calculations in cells are
entered and displayed here. It is denoted by fx.
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.
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 sheets appear in the sheet tabs at the
bottom of the spreadsheet. We can click on the specific sheet tab to open it.
Horizontal Scroll Bar
It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from
left to right and vice-versa.
Vertical Scroll Bar
It lies towards the right side of the spreadsheet. It helps to view the spreadsheet 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 spreadsheet.
Based on which type of data is being stored, data can be classified into numeric, alphanumeric or text,
date/time and formula.
DATA
Numeric Alphanumberic Date/Time Formula
Working with Spreadsheet 183

