Page 47 - TP-Play_V-2.0_Book-5
P. 47
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
Window Mouse Pointer
Cell
Row Heading
Worksheet Tab
Worksheet
tab scrolling
Status Components of Excel 2016
buttons
bar
Formula Bar: It is used to enter and edit formulas and perform calculations on
your worksheet data. It is also used for entering and editing the all contents.
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 shows various 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.
Column: The vertical divisions on a worksheet are called columns. There are
16,384 columns in an Excel worksheet.
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 is entered in an active cell.
Introduction to Excel 2016 47

