MS Excel- For beginners

Lets learn basic things about MS- excel.

Very first question, What is it?
Ms-Excel is a spreadsheet program developed by Microsoft.Using this we can manipulate, format or calculate various arithmetic functions on data arranged in columns and rows.It looks like below:

MS Excel basically consists of rows and columns.
Rows:  Rows consists of horizontal lines, two parallel horizontal lines make a row as shown in fig below:

 

Here first row is selected. Number 1 represent row number 1 and similarly each number represents respective row number.

Columns: Columns consists of vertical lines, two parallel vertical lines make a column as shown in fig below:  

Each column is identified by a different alphabet as first column is marked as A. 

Cell : A cell is a rectangular box which occurs as the result of intersections of rows and columns as shown below:

             

How to perform various arithmetic functions in MS excel?

It is very easy to perform arithmetic functions on a huge data in MS excel. Lets have look on each function separately: 

1. Sum : After entering the data in MS Excel worksheet click on the cell where you want to calculate the sum,  and type  = SUM(cellnumber1,cellnumber2) and press enter,whereas cellnumber1,cellnumber2  represents the cells which you want to sum up.Like in my case i want to sum up Math and English marks, so i would enter =SUM(B2,D2)

Now,if  we want to sum more than two entries then we can use formula =SUM(cellnumber1:cellnumber2) whereas cellnumber1 represents the first cell and cellnumber2 represents the last cell upto which we want to get the sum.For example, if i want to sum all the three subjects then i would use =SUM(B2:D2) as shown below 

Moreover, we can select all the cells which we want to sum and in the next cell, click Autosum from the home tab and press enter to get the result.

2. Subtraction: For this, we can simply type =cellnumber1-cellnumber2, whereas cellnumber1 represents the cell from which you want to subtract and cellnumber2 represents the cell which you want to subtract.For example if i want to subtract expenditure amount from the salary to know the savings of Rohit so in the cell where i want to get the velue , i would type =B2-C2 and press enter

And to subtract more value, Either we can simply use =cellnumber1-cellnumber2-cellnumber3 and so on, OR we can use =cellnumber1-(SUM(cellnumber2:cellnumber3))

3. Multiplication And Division: To multiply,we could type =cellnumer1*cellnumber2 in the column where we want to get the multiplication value and to divide the value we could use =cellnumber1/cellnumber2

Lets see an example of both multiplication and division, we can use both to calculate percentage

we already know that formula of percentage is (Marks obtained multiplied by 100) divided by Total 

marks, same formula has been used to calculate percentage as shown below: 

 

To know about Merge&center  or Sort&Filter in Ms Excel click on Merge cells and Sort&Filter in Ms Excel