Page 56 - iPro_trackGPT_V5_Class7
P. 56
Row and Column Heading
The row heading is the grey number (1, 2, 3, etc.) at the beginning of each row in the worksheet.
In contrast, the column heading is the grey letter (A, B, C, etc.) at the top of each column. Row
headings range from 1 to 1,048,576, while column headings range from A to XFD.
Cell
The intersection of a row and a column is known as a cell. In an Excel worksheet, a cell appears
as a rectangular box. Each cell has a unique address, known as the cell address, which is a
combination of the column heading and the row heading. For instance, a cell in the second row
of column A is addressed 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.
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 is used to enter the date in different formats. The default format of date in
Excel is mm/dd/yy. Time is used to enter time in either hh:mm or hh:mm:ss format. By default,
Excel aligns dates and times to the right.
CREATING A NEW WORKBOOK
To create a new workbook in Excel 2021, follow the given steps:
1 Click on the File tab.
3 Click on the
Blank workbook.
2 Click on the
New option.
A new workbook will be created.
54 TrackGPT iPRO (V5.0)-VII

