MS EXCEL
A spreadsheet is essentially a matrix of rows and columns.
Consider a sheet of paper on which horizontal and vertical lines are
drawn to yield a rectangular grid. The grid namely a cell, is the result
of the intersection of a row with a column. Such a structure is called a
Spreadsheet.
A spreadsheet package contains electronic equivalent of a pen,
an eraser and large sheet of paper with vertical and horizontal lines to
give rows and columns. The cursor position uniquely shown in dark
mode indicates where the pen is currently pointing. We can enter text
or numbers at any position on the worksheet. We can enter a formula
in a cell where we want to perform a calculation and results are to be
displayed. A powerful recalculation facility jumps into action each time
we update the cell contents with new data.
MS-Excel is the most powerful spreadsheet package brought by
Microsoft. The three main components of this package are
Electronic spreadsheet
Database management
Generation of Charts.
Each workbook provides 3 worksheets with facility to increase the
number of sheets. Each sheet provides 256 columns and 65536 rows
to work with. Though the spreadsheet packages were originally
designed for accountants, they have become popular with almost
everyone working with figures. Sales executives, book-keepers,
officers, students, research scholars, investors bankers etc, almost any
one find some form of application for it.
You will learn the following features at the end of this section.
Starting Excel 2003
Using Help
Workbook Management
Cursor Management
Manipulating Data
Using Formulae and Functions
Formatting Spreadsheet
Printing and Layout
Creating Charts and Graphs
MS Excel Page 1 of 40
,Starting Excel 2003
Switch on your computer and click on the Start button at the
bottom left of the screen.
Move the mouse pointer to Programs, then across to
Microsoft Excel, then click on Excel as shown in this screen.
When you open Excel a screen similar to this will appear
MS Excel Page 2 of 40
, The options shown below is called as Menu Bar
The collection of icons for common operations shown below
is called as Standard Tool Bar
MS Excel Page 3 of 40
, MS Excel Page 4 of 40
A spreadsheet is essentially a matrix of rows and columns.
Consider a sheet of paper on which horizontal and vertical lines are
drawn to yield a rectangular grid. The grid namely a cell, is the result
of the intersection of a row with a column. Such a structure is called a
Spreadsheet.
A spreadsheet package contains electronic equivalent of a pen,
an eraser and large sheet of paper with vertical and horizontal lines to
give rows and columns. The cursor position uniquely shown in dark
mode indicates where the pen is currently pointing. We can enter text
or numbers at any position on the worksheet. We can enter a formula
in a cell where we want to perform a calculation and results are to be
displayed. A powerful recalculation facility jumps into action each time
we update the cell contents with new data.
MS-Excel is the most powerful spreadsheet package brought by
Microsoft. The three main components of this package are
Electronic spreadsheet
Database management
Generation of Charts.
Each workbook provides 3 worksheets with facility to increase the
number of sheets. Each sheet provides 256 columns and 65536 rows
to work with. Though the spreadsheet packages were originally
designed for accountants, they have become popular with almost
everyone working with figures. Sales executives, book-keepers,
officers, students, research scholars, investors bankers etc, almost any
one find some form of application for it.
You will learn the following features at the end of this section.
Starting Excel 2003
Using Help
Workbook Management
Cursor Management
Manipulating Data
Using Formulae and Functions
Formatting Spreadsheet
Printing and Layout
Creating Charts and Graphs
MS Excel Page 1 of 40
,Starting Excel 2003
Switch on your computer and click on the Start button at the
bottom left of the screen.
Move the mouse pointer to Programs, then across to
Microsoft Excel, then click on Excel as shown in this screen.
When you open Excel a screen similar to this will appear
MS Excel Page 2 of 40
, The options shown below is called as Menu Bar
The collection of icons for common operations shown below
is called as Standard Tool Bar
MS Excel Page 3 of 40
, MS Excel Page 4 of 40
