MICROSO
FT EXCEL
MICROSO
MICROSOFT EXCEL
FT EXCEL
Electronic spreadsheet refers to a collection of text
and numbers laid out in a rectangular grid.
It is an application program commonly used for
budgeting, inventory management, decision
making, forecasting and other finance-related tasks.
Components
of MS EXCEL
Main Components of MS EXCEL
Cell
A cell is a smallest but most powerful part
of a spreadsheet. Data can be a text, a
number, or a date. You can also
customize it by changing its size, font
color, background color, borders, etc.
Main Components of MS EXCEL
Cell
Every cell is identified by its cell address,
cell address contains its column number
and row number.
Columns represented by Letter and Rows
represented by numbers.
Cell address is combination of letters and
numbers.
Main Components of MS EXCEL
Workbook
Each workbook contains one or more
worksheets. You can also say that a
workbook is a collection of multiple
worksheets or can be a single worksheet.
Main Components of MS EXCEL
Worksheet / Sheet
A worksheet is made up of individual cells
which can contain a value, a formula, or
text. It also has an invisible draw layer,
which holds charts, images, and diagrams.
Components of MS EXCEL
Active Cell
A cell that is currently selected. It will be
highlighted by a rectangular box and its
address will be shown in the address bar.
You can activate a cell by clicking on it or
by using your arrow buttons. To edit a
cell, you double-click on it or use F2 as
well.
Components of MS EXCEL
Column
A column is a vertical set of cells. A single
worksheet contains 16384 total columns.
Every column has its own alphabet for
identity, from A to XFD. You can select a
column by clicking on its header.
Components of MS EXCEL
Row
A row is a horizontal set of cells. A single
worksheet contains 1048576 total rows.
Every row has its own number for
identity, starting from 1 to 1048576. You
can select a row by clicking on the row
number marked on the left side of the
window.
Components of MS EXCEL
Fill Handle
It’s a small dot present in the lower right
corner of the active cell. It helps you to fill
numeric values, text series, insert ranges,
insert serial numbers, etc.
Components of MS EXCEL
Address Bar
It shows the address of the active cell. If
you have selected more than one cell,
then it will show the address of the first
cell in the range.
Components of MS EXCEL
Formula Bar
The formula bar is an input bar, below the
ribbon. It shows the content of the active
cell and you can also use it to enter a
formula in a cell.
Components of MS EXCEL
Title Bar
The title bar will show the name of your
workbook, followed by the application
name (“Microsoft Excel”)
Components of MS EXCEL
File Menu
The file menu is a simple menu like all
other applications. It contains options like
(Save, Save As, Open, New, Print, Excel
Options, Share, etc).
Components of MS EXCEL
Quick Access Toolbar
A toolbar to quickly access the options
which you frequently use. You can add
your favorite options by adding new
options to the quick access toolbar.
Components of MS EXCEL
Ribbon
Starting from Microsoft Excel 2007, all the
options menus are replaced with ribbons.
Ribbon tabs are a bunch of specific option
group which further contains the option.
Components of MS EXCEL
Worksheet Tab
This tab shows all the worksheets which
are present in the workbook. By default
you will see, three worksheets in your
new workbook with the names Sheet1,
Sheet2, and Sheet3 respectively.
Components of MS EXCEL
Status Bar
It is a thin bar at the bottom of the Excel
window. It will give you instant help once
you start working in Excel.
