Page 58 - Trackpad_ipro 4.1_Class7
P. 58
Column
The vertical divisions in a worksheet are called columns. There are 16,384 columns in an Excel
worksheet. Columns are labelled from left to right with letters such as A, B, C, D, ... and so on up
to XFD.
Row and Column Heading
The row heading is the grey-coloured number (1, 2, 3, etc.) located in front of each row in the
worksheet. On the other hand, the column heading is the grey-coloured letter (A, B, C, etc.)
located at the top of each column. The row headings range from 1 to 10,48,576 and the column
headings range from A to XFD.
Cell
The intersection of a row and a column is called a cell. A cell in an Excel worksheet looks like a
rectangular box. Every cell in a worksheet has an address, which is called a cell address. A cell
address is a combination of a column heading and the row heading. For example, a cell in the
second row of column A has the cell address as A2.
Active Cell
The currently selected cell that appears highlighted with a green border is an active cell. The
data is entered in an active cell.
Mouse Pointer
The mouse pointer is displayed as a block plus sign ( ), whenever we move over a cell in a
worksheet. Another common shape of the mouse pointer is the block arrow ( ).
Workbook
An Excel file is called a workbook. It is a collection of different worksheets. By default, a workbook
contains only one worksheet, Sheet1. The number of worksheets can be increased as per the
requirement.
Tech
Funda
A cell range in Excel refers to a group of two or more cells. There are two
types: Contiguous Cell Range, where cells are next to each other and
specified with a colon (e.g., A1:A6), and Non-Contiguous Cell Range, where
cells are not adjacent and specified with commas (e.g., A1, B1, C3).
TYPES OF DATA
While working in Excel, the following types of data can be entered:
Numbers: Numbers include the digits (0–9) and their various combinations. All types of
calculations can be done on numbers. By default, Excel aligns numbers to the right.
Text: Text includes the collection of letters, numbers, and special characters. No mathematical
calculation can be performed on text. By default, Excel aligns text to the left.
Date and Time: Date type is used to enter the date in different formats. The default format of
date in Excel is mm/dd/yy. Time type is used to enter time in either hh:mm or hh:mm:ss format.
By default, Excel aligns dates and times to the right.
56 iPro (Ver. 4.1)-VII

