Microsoft Excel

What is Microsoft Excel?

excel

Microsoft Excel is a software application which provides an electronic sheet.

Where you can create Result Sheet, Pay Sheet, Electricity Bill Sheet, Shop Bill Sheet and other accounts sheets.


How to Open Excel?

Click on the Start, type excel, if MSOffice will already be installed then click on the excel otherwise install it.


Microsoft Excel Sheet

Excel Sheet


How to Add Data in Excel?

data typing principle in excel

In Excel, we add data with the following principles.

Numeric Data on the right side of the cell pointer of Excel Sheet, while Non-Numeric at the left.


How to Add the Numeric Values in the Excel?

There are several ways we can use to add numeric values in Ms Excel.

Start the formula from = sign in excel

=Cell Address + Cell Address [To add the values in A1 and B1 cells]
=A1+B1

=sum(Start Cell Address:End Cell Address)

=sum(A1:G1) [To add the values from A1 to G1 in the range]


How to Subtract the Numeric Values in the Excel?

=Cell Address-Cell Address
=A1-B1

=sum(Cell Address-Cell Address)
=sum(A1-B1)


How to Multiply the Numeric Values in the Excel?

=Cell Address*Cell Address
=A1*B1

=sum(Cell Address*Cell Address)
=sum(A1*B1)


How to Divide the Numeric Values in the Excel?

=Cell Address/Cell Address
=A1/B1

=sum(Cell Address/Cell Address)
=sum(A1/B1)


How to find the maximum value from the values in a range?

=max (range)

max in excel

After pressing Enter Computer will type 90 in the formula Cell


How to find the minimum value from the values in a range?

=min (range)

min in excel

After pressing Enter Computer will type 34 in the formula Cell


How to Create a Result Sheet in Excel?

Result Sheet in Excel

Step1. Type Result Sheet in the A1 Cell Address

Step2. Type Result Sheet Sub Headings from S/No to Remarks Starting from A2  to N2, as shown in the image above.


The formula for Total in Excel

Put cell pointer under Total and type

=sum(c2:j2)


The formula for Average in Excel

Put cell pointer under Avg and type

=average(c2:j2)


The formula for Grade in Excel

Put cell pointer under Grade and type the following while (L3) is the cell address of Average.

=+IF(L3>=80,”A+”,+IF(L3>=70,”A”,+IF(L3>=60,”B”,+IF(L3>=50,”C”,+IF(L3>=40,”D”,+IF(L3>=33,”E”,”Fail”))))))


The formula for Remarks in Excel

Put cell pointer under Remarks and type the following while (M3) is the cell address of the Grade.

=+IF(M3=”A+”,”Most Excellent”,+IF(M3=”A”,”Excellent”,+IF(M3=”B”,”Very Good”,+IF(M3=”C”,”Good”,+IF(M3=”D”,”Fair”,+IF(M3=”E”,”Poor”,”Very Bad”))))))


How to Make a Result Sheet in Excel | English Subtitles |


Excel Video Lectures 

Video  Ms Excel 2003 Menus


      Home      Courses     

 

Spread the love
Rana Mehtab Alam Lunar Computer College.