Microsoft Excel

What is Microsoft Excel?

excel

Microsoft Excel is a software application that 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.

or Press the (windows button + R) and press Enter key. A run dialogue box will appear type excel and press the Enter key


Microsoft Excel Sheet

Excel Sheet


Principles of writing data in Microsoft Excel

data typing principle in excel

In Excel, we add data with the following principles.

Numeric data to the right of the cell pointer of the Excel sheet, while non-numeric to the left as shown in the image above.


How to Add the Numeric Values in the Excel?

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

Using this method you can add two or multi numeric values to Microsoft Excel’s sheet.

Start the formula from = sign in excel

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

add two values in excel

as you will press the Enter key computer will show the result in the C1 cell as shown in the image below.

result of adding two values in excel

Add numeric values in a range in Ms Excel

=sum(Start Cell Address:End Cell Address)

 To add the values from A1 to G1 in the range]

=sum(A1:G1)

add values in range in excel

Press the Enter key to see the result in the formula cell 

See the image below:

result of adding values in range in excel

 


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)

To find the maximum value from the range A1 to A6 type =max(A1:A6) as shown in the image below.

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)

To find the minimum value from the range A1 to A6 type =min(A1:A6) as shown in the image below.

min in excel

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 below.

Result Sheet in Excel


Now type the data as you can see on the above image in row 3. From A3 to J3 while Total Avg Grade   Remarks we will get with the help of formulas.


 The formula for Total in Excel

Put cell pointer under subheading Total on K3 according to above sample Result Sheet image and type the following formula

=sum(c3:j3) and then press the Enter to get the result.


The formula for Average in Excel

Put cell pointer under the subheading Avg and type the following formula to get the average of the students’ result while all subjects total marks are equal to 100.

=average(c3:j3) and then press the Enter to get the result.


The formula for Grade in Excel

Put cell pointer under the subheading Grade and type the following formula of the grade while (L3) is the cell address of average which you have solved above.

=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 subheading Remarks and type the following  formula for remarks while (M3) is the cell address of the grade which you have solved above.

=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 |


SiteMap

 

Spread the love
Rana Mehtab Alam Lunar Computer College. WhatsApp +923004467226