Page 21 - ThinkGPT_V2.1_C5_Flipbook
P. 21
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 the worksheet has an address, which is called a cell address.
A cell address is a combination of a column heading and a row heading. For example, a cell
in the second row of column A has the cell address A2.
Active Cell
The currently selected cell that appears highlighted with the green border is 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.
Cell Range
A cell range is a collection of two or more cells. It is of two types: Contiguous Cell
Range and Non-Contiguous Cell Range. Contiguous Cell Range is a collection of cells
that are adjacent to or next to one another. A colon (:) is used for specifying this cell
range, for example, A1:A6. Non-contiguous Cell Range is a collection of cells that
are not adjacent to one another. A comma (,) is used for specifying this cell range,
for example, A1, B2, C3.
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 requirements.
Worksheet Tab
There can be more than one worksheet in Excel, and each has a specific name. Any worksheet
can be activated by clicking on its tab in the worksheet tab. These tabs are located at the
bottom-left of the Excel window as Sheet1, Sheet2, Sheet3 and so on.
Worksheet Tab Navigation Buttons
Worksheet tab navigation buttons are located on the left side of the worksheet tabs.
These are used to move from one worksheet to another in a workbook.
Status Bar
The horizontal bar at the bottom, which shows various information about the file on which
you are working, is called the Status bar. The right section of the status bar has view control
buttons such as Normal and Page Layout for the spreadsheet.
Introduction to Excel 2016 19

