Topics which we will cover in this post
ü Define
Microsoft Excel?
ü Why
Should I learn Microsoft Excel?
ü How
to Open Microsoft Excel?
ü Discuss interface of MS Excel?
Define MS Excel?
ü Microsoft Excel is the most powerful tool developed by Microsoft.
ü It is available for both for Microsoft Windows & Macintosh OS.
ü It can manage and analyze various types of Data.
ü This software is part of the Microsoft Office suite and is also compatible with other applications in the Office suite.
What is MS-Office?
MS Office is a package developed by Microsoft Corporation.
It includes Microsoft Word, Excel, Access, PowerPoint, Outlook and other productivity software commonly used in our offices.
Each program serves a different purpose and is compatible with other programs included in the package.
Versions of MS Excel
Excel 2.0 is the first version of Excel for the Intel
platform released in 1987. Versions prior to 2.0 were only available on the
Apple Macintosh.
Latest version of MS Excel is Excel 2019, It was
released for Windows 10 and macOS on September 24, 2018, we can’t run this
version of excel on previous versions of windows.
Why Should I learn Microsoft Excel?
ü We can Organize data.
ü Do basic and complex mathematical functions.
ü Turn piles of data into helpful graphics and charts
ü We can also work on Data Analysis part like sort, filter
ü We can Import and Export data etc.
Along with these, much more options are available in
MS EXCEL
How we Open Microsoft Excel?
Click
on Start Ã
Programs Ã
Microsoft office Excel 2007
You
can also enter into search box
Window Key + R then type excel in the box finally click on OK button you Microsoft Excel will start.
Cell: A cell is a smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, background color, borders, etc. Every cell is identified by its unique cell address, cell address contains its column number and row number (If a cell is on 11th row and on column D, then its address will be D11).
Worksheet: 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. Each worksheet in a workbook is accessible
by clicking the tab at the bottom of the workbook window. In addition, a
workbook can store chart sheets; a chart sheet displays a single chart and is
accessible by clicking a tab.
Workbook: A workbook is a separate file just like every other
application has. 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. You can add or delete worksheets, hide them within the workbook without
deleting them, and change the order of your worksheets within the workbook.
Active Cell:
A cell which 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 to as well.
Columns:
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 clicking on its header.
Rows:
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 clicking on the row number marked on the left side of the
window.
Fill Handle: It’s a small dot present on the lower right corner of
the active cell. It helps you to fill numeric values, text series, insert
ranges, insert serial numbers, etc.
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.
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.
Title Bar: The title bar will show the name of your workbook,
followed by the application name (“Microsoft Excel”).
Status Bar: It is a thin bar at the bottom of the Excel window.
It will give you an instant help once you start working in 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).
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 quick access toolbar.
Ribbon Tab: Starting from the Microsoft Excel 2007, all the
options menus are replaced with the ribbons. Ribbon tabs are the bunch of
specific option group which further contains the option.
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 name of Sheet1, Sheet2, Sheet3 respectively.
Status Bar: It is a thin bar at the bottom of the Excel window.
It will give you an instant help once you start working in Excel.
0 Comments