Introduction to Microsoft Excel (Part1)
As we have already learnt the terminologies of Excel in the previous note, we will straight get to the actual task today!
After entering all the data, if you want to print them, go to the top and click on the file option, there will be a print option where you can view the print copy’s preview . If you want to add more clear lines between the data, you can click and drag the whole table and add borders to make it more specific to display. If you want to color a certain cell , click and drag the whole cell and click on the color option there on top , something that looks like “A” and select the color and the cell will be colored. We can also make it bold, larger or smaller just like normal text. Also you can select and drag the whole table and make it centered to look better just like normal line assigning too. This will make it look clear and professional and easier to analyze data.
Now for formulas,
Always we use equal sign to use formulas . For example , we enter “+10” in a cell. Then if we notice up there, there will be something like a function sign and then an equation.
f (x)= 2*5.
Even though on the particular cell we will only see the 5, not the plus sign before that but will be able to see the function over there on the top.
Now, If we enter 5 into a cell , on the tip , there will be no equation but a 5 only.
Now suppose we want a function that will tell us the average marking of each student here.
We can double click on the column and insert a new column there. In this column we will display the average mark of the student. We name the column “Average”
For that assuming we have already entered the number of courses and the total marks for each student into two different columns here.
Now in the third column we will just write “=” and then click on the total mark of the student from the cell and on the “Average” named column we will see “=B3” and then we hit “/” and click on the total number of courses, on the “Average” named column we will see “=B3/A3” or something like that depends on the column sequence . Right after that if we press enter we will find the average on the cell .We can change the number from decimal to point by entering the small button there right beside the number button and here we can place two or three decimal places to find specific numbers. Now if we select the resulted number and drag and copy the whole column down, that’s the magic!
We will find the average number for all the students automatically !
You can try it at home and can explore yourself easily. Keep practicing.