Page 29 - TP_Modular_V2.1_Class7
P. 29
Ribbon: This bar has tabs with group of related commands displayed on it.
Quick Access Toolbar Title Bar Control Buttons
File Tab
Ribbon
Name Box
Formula
Bar
Highlighted
Headings Column
Active Cell
Heading
Worksheet Column
Window
Row
Cell Workbook
Row Heading Worksheet
Tab Mouse
Pointer
Worksheet
Tab Scrolling
Buttons
Status Bar Components of Excel 2016
Formula Bar: It is used to enter and edit formulas in a cell and perform calculations on your
worksheet data. It is also used for entering and editing the contents of a cell.
Name Box: The address of the active cell is displayed in this box.
Worksheet Window: It is a single page in Excel also called spreadsheet.
Status Bar: The horizontal bar at the bottom that shows information about the file in which you
are working. The right section of the status bar has view control buttons for the spreadsheet.
Row: The horizontal divisions on a worksheet are called rows. There are 10,48,576 rows in an
Excel worksheet. Each row is represented by a number such as 1, 2, 3, and so on.
Column: The vertical divisions on a worksheet are called columns. There are 16,384 columns in
an Excel worksheet. Each column is represented with alphabetic value such as A, B, C and so on.
Row and Column Heading Buttons: Work area is divided into rows and columns.
The rows are reffered using numbers and columns using the alphabets. The row headings
range from 1 to 10,48,576 and column headings range from A to XFD.
Cell: The intersection of a row and a column is called a cell. A cell in Excel worksheet looks
like a rectangular box.
Active Cell: A cell is formed by the intersection of a row and a column. The currently selected
cell that appears highlighted with green border is an active cell. The data we type is entered
in an active cell.
Mouse Pointer: The mouse pointer is displayed as a block plus sign ( ), whenever it is
located in a cell on the worksheet. Another common shape of the mouse pointer is the block
arrow.
Worksheet Tab: There can be more than one worksheet in Excel workbook and each has a
specific name. Any worksheet can be activated by clicking on its name in worksheet tab.
Introduction to Excel 2016 27

