Page 45 - TP_Play_V2.1_class5
P. 45
Quick Access Toolbar: It is present on the title bar. It displays quick access
buttons of the Save, Undo and Redo commands.
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
Highlighted Bar
Headings Active Cell Column
Heading
Worksheet Column
Window Row
Cell Workbook
Row Heading Worksheet
Tab Mouse
Worksheet Pointer
Tab Scrolling
Buttons
Status Components of Excel 2016
Bar
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.
Introduction to Excel 2016 43

