Page 61 - TP_iPlus_V2.1_Class7
P. 61
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 for the Save,
Undo and Redo commands.
Window Control Buttons
The window control buttons let you minimize the window, restore or maximize its size, and close
the application while prompting to save any unsaved work.
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.
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: It 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. For example, A1 cell.
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.
Worksheet
A worksheet is the main working area in an Excel window where we can enter data. It consists
of rows and columns. It is also known as a spreadsheet.
Sheet Tabs
There can be more than one worksheet in Excel, and each has a specific name. Any worksheet
can be activated by clicking on its name on the worksheet tab. These tabs are located at the
bottom-left of the Excel window as Sheet1, Sheet2, Sheet3 and so on.
Navigation Buttons
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. We can also directly click on the worksheet tab
to make it active.
59
Spreadsheets—An Introduction

