What is Microsoft 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
Principles of writing data in Microsoft 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]
as you will press the Enter key computer will show the result in the C1 cell as shown in the image below.
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]
Press the Enter key to see the result in the formula cell
See the image below:
How to Subtract the Numeric Values in the Excel?
=Cell Address-Cell Address
=sum(Cell Address-Cell Address)
How to Multiply the Numeric Values in the Excel?
=Cell Address*Cell Address
=sum(Cell Address*Cell Address)
How to Divide the Numeric Values in the Excel?
=Cell Address/Cell Address
=sum(Cell Address/Cell Address)
How to find the maximum value from the values in a range?
To find the maximum value from the range A1 to A6 type =max(A1:A6) as shown in the image below.
After pressing Enter Computer will type 90 in the formula Cell
How to find the minimum value from the values in a range?
To find the minimum value from the range A1 to A6 type =min(A1:A6) as shown in the image below.
After pressing Enter Computer will type 34 in the formula Cell
How to convert numbers into words in Excel?
In Excel, there are several ways that you can use to change the numbers into the word. But I am explaining the very simple way.
Check the following function 1st.
or type 9 in cell A1 and put cell pointer on A2 and type =SpellNumber(A1)
if the computer converts 9 into words (Your currency name and Nine) then the function is working as shown in the image below.
If it is not working then follow all the following procedures step by step as shown below.
Download This file
- After downloading the file Unzip the File, Right Click on the file and then Click on Extract Here.
- Open the extracted folder copy the file named SpellNumber
- Mark the tick sign on the Show hidden file, folders and drives under the Folder Options.
- Open the Users folder.
- Now open the folder with the name you created.
- You will see AppData Folder Open it
- Then Open the Roaming folder under the AppData folder.
- Under the Roaming folder open the Microsoft Folder.
- Finally, open the AddIns folder and Paste that file (SpellNumber) here that you have copied at step 2.
- Now open the Microsoft Excel Software application.
- Open Excel Options by clicking the upper top left corner MSOffice icon.
- Click on Add-Ins
- Now click on SpellNumber from the next window.
- Click on Go that you will see after, Manage and Excel Add-Ins.
- Checked the SpellNumber and Click Ok
- Now your =SpellNumber() function is activated.
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.
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.
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 |