Page 29 - modular4.0
P. 29
Chapter Profile
COMPONENTS OF EXCEL 2019
Following are the components of Excel 2019 window:
Title Bar: It is located on the top of the window that shows the name of the current workbook.
File Tab: A green button located at the left top corner that contains the file menu commands
such as New, Open, Save, etc.
Quick Access Toolbar: It is present on the title bar. It displays quick access buttons of the Save,
Undo and Redo commands.
Quick Access Toolbar
Title Bar Control buttons
File tab
Ribbon
Name box
Formula
Highlighted bar
headings Column
Active Cell
Heading
Worksheet Window
Mouse Pointer
Cell
Row Heading
Worksheet Tab
Worksheet tab
scrolling buttons
Status bar Components of Excel 2019
Formula Bar: It is used to enter and edit formulas and perform calculations on the data present
in your worksheet. 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: The work area is divided into rows and columns. The rows are
referred 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 appears a
rectangular box.
Active Cell: 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 2019 27

