What is Excel?

Microsoft Excel
is spreadsheet software widely used to perform mathematical calculations. The
data is spread in a tabular form consisting of rows and columns.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

It provides
built in features and tools such as formulas, functions and data analysis tools
that make it easier to work with large amount of data.

Features of Excel

1.    
Formatting
Features: Improve the appearance of data.

2.    
Auto
calculation: The data is automatically recalculated in the whole worksheet if
any change is made in a single cell.

3.    
Functions
and Formulas: Functions are the built in formulas used for calculating
percentage, interest, average etc, in MS Excel. Formulas are mainly used for
performing simple and complex calculation.

4.    
Fast
searching and instant replacing of data.

Uses of Excel

It helps us to

1.    
Arrange
data in an organized way

2.    
Type
less and get more

3.    
Perform
calculations

4.    
Sort
data for better analysis

5.    
Compare
two workbooks side by side.

Starting MS Excel

 To start MS Excel, perform the following
steps:

Click on Start Button à
Type Excel à
Microsoft Office Excel will
appear on the screen à Left click on Microsoft Office Excel

Workbook and Worksheet

Workbook – When
you start Excel, you open a file which is called a Workbook. It is like a
notebook that has number of pages in it. Each new workbook comes with three
worksheets known as sheet tabs. They can be seen at the bottom left of the
workbook window. These are named as Sheet1, Sheet2, and Sheet3.

Worksheet – Data
is entered into the worksheet. You can add additional worksheets, if you need
more than three. Data can be viewed in a worksheet by clicking on its sheet
tab. A worksheet is divided into rows and columns.

Columns, Rows, Cell, Cell Reference, Cell pointer

Columns – Each
column has an alphabetical heading at the top. The first 26 columns have the
letters from A through Z, then AA through AZ and carrying up to XFD. Each
worksheet contains 16,384 columns.

Rows – Each row
also has a heading. Row heading are numbers, ranging from 1 to 1048576

Cell – A cell is
the space which if formed by the intersection of one row and one column. Each
small rectangle in a spreadsheet is called a cell.

Cell Reference –
the heading of a column and a row combines to form the cell address, also
called the cell reference.

Cell Pointer – A
cell pointer is a highlighted cell boundary that indicates which cell is active
at the moment.

Entering data in Excel

 You can enter three types of data in worksheet
cells: number, text and formula.

1.    
Click
on the cell where you want to enter the data

2.    
Type
your data into the cell

3.    
Press
Enter key to move the pointer down by one cell. Press the Tab key to move to
the next adjoining cell towards right.

4.    
Click
on suppose cell B1 and type your data(School Name)

5.    
Press
the Enter key

6.    
Click
on suppose cell A3 and type the data.(Roll No)

7.    
Press
tab key and type the data (Name).

8.    
Press
the Right Arrow key and type the data (Grade).

 

 

Activity: Create an
excel sheet as the mentioned below

 

Formatting in MS Excel

Copy Paste option

Copy
and paste option is used to duplicate the text. We can copy text from one
location to another location.

Follow
the steps to copy and paste the text

1.    
Select
cell which is to be copied.

2.    
The
cell will be highlighted with a dashed border.

3.    
Click
on copy button in the clipboard group on the Home tab or press Ctrl + C

4.    
Select
a cell where you want to paste the copied text.

5.    
Click
on paste button in the clip board group on the Home tab or press Ctrl + V

6.    
Click
on ESC key to remove the dashed border of the selected cell.

Cut Paste Option

Cut
and paste option is used to remove the text from one location and add it to
another location.

Follow
the steps to cut and paste the text

1.    
Select
cell which is to be cut.

2.    
The
cell will be highlighted with a dashed border.

3.    
Click
on cut  button in the clipboard group on
the Home tab or press Ctrl + X

4.    
Select
a cell where you want to paste the text.

5.    
Click
on paste button in the clip board group on the Home tab or press Ctrl + V

6.    
Click
on ESC key to remove the dashed border of the selected cell.

Activity: Create a
Sheet as mentioned below and use cut paste and copy paste option

         

Copy details of roll no 3 and paste the contents
after roll no 5 as shown below.

 

Cut the details of roll no 5 and paste after
contents of roll no 3 as shown below.