Page 59 - iPlus_Ver_2.0_class_7
P. 59
Title Bar
Title bar lies at the top of the window screen. It displays the name of the active workbook. When
the spreadsheet is newly created, by default it is named as Book1, second is Book2 and so on.
Quick Access Toolbar
Quick Access Toolbar is present on the title bar. It displays quick access buttons of the Save,
Undo and Redo commands.
File Tab
A green button located below the Quick Access Toolbar contains the file menu commands such
as New, Open, Save, etc.
Ribbon
Ribbon is like a strip that has various tabs such as Home, Insert, Page, Layout, Formulas, and
Data. These tabs consist of different groups that contain related commands.
Name Box
Name box is a box located on the left side of the Excel window, just below the Ribbon. The
address of the active cell is displayed in this box.
Formula Bar
Formula bar lies below the Office Ribbon. Formula that performs different calculations in cells is
entered and displayed here. It is denoted by ‘fx’.
It is used for entering and editing the formula in the cell. Formula bar consists of:
Name box: displays the cell reference, for example A1 or D10.
Function: It lets you click on the Function icon and inserts an equals (=) sign into the selected
cell.
Input line: It displays the contents of the selected cell (data, formula, or function). It allows
editing of the the cell contents. Click in the area, then type the changes. To edit within the current
cell, just double-click in the cell.
Cell Pointer
The active cell in a worksheet is known as the Cell Pointer. It remains highlighted with bold
border in the active worksheet.
Active cell: The selected or activated cell is referred to as 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. In
a spreadsheet, active cell is the place where data is entered. Before entering any data in the cell,
it has to be first selected by placing a cursor on it. When we position the mouse cursor on a cell,
it gets selected, and is ready to take data from the user or do editing.
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’.
57
Spreadsheets—An Introduction

