# Microsoft Excel

#### What is Microsoft 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 #### How to Add Data 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.

=A1+B1

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

=A1-B1

=sum(A1-B1)

=A1*B1

=sum(A1*B1)

=A1/B1

=sum(A1/B1)

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

=max (range) 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) After pressing Enter Computer will type 34 in the formula Cell

#### How to Create a 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.