Skip to main content

HOW TO CREATE MARK SHEET?

 





Microsoft Excel is a tool to generate mark sheet. Mark sheet represents the students' data in tabular form. It reveals the student’s roll number, their name along with the marks they obtained. In today’s blog we will construct marksheet. Let’s assume five students are enrolled in three subjects- English, Mathematics and Computer. Firstly, we have to create seven columns and six rows. The seven columns include- Roll no., English, Mathematics, Computer, Marks Obtained, Percentage and Grades.

                                


OBTAINED MARKS: 

Add up all the subjects marks of an individual. We will get Obtained Marks. Formula: “=Sum(……)”

Write =Sum( then put a cursor on the marks you want to add and drag it by pressing a “Shift + Right ward arrow” and finally close the bracket ).

                                 


PERCENTAGE: 

We all know the formula of percentage. Here, we simply apply it by pressing ‘equal to =’ and put the cursor on marks obtained cell, press / and write total marks which is 300. The answer we will get in decimal form. Therefore, for converting it into percentage, select a cell, click on home tab, go to number box and click on % icon in the list box.

                                 




GRADES:

For grading we are required to apply conditions. However, MS Excel has this feature to apply conditions by inserting ‘IF’ function. ‘IF’ function allows you to test the condition and get the result (Is whether the condition ‘true’ or ‘false’?). Formula=IF(F2>=80%,"A1",IF(F2>=70%,"A",IF(F2>=60%,"B",IF(F2>=50%,"C",IF(F2>=40%,"D","FAIL"))))) After applying the condition, place the cursor on cell and drag it.   

                                     



COMPLETE VIDEO:

                               

VISIT:

https://getskills1.blogspot.com/2020/12/short-cut-keys-in-excel.html


Labels:

Comments

Post a Comment

Please don't enter any spam link in the comment box

Popular posts from this blog

HOW TO INSERT PICTURE IN MS WORD?

Sometimes, words are not necessary, a picture is enough to elaborate the whole scenario. Therefore, this blog instructs you how to insert picture in MS. Word docx. Click on Insert tab, you will find picture icon, click on it then two drop down box occur labelled as ‘This Device’ and ‘Online Picture’, a pop up screen appears. Finally, select the picture you want to insert.                                                                         CROPPING AND EFFECTS: Click on Format tab button and click on ‘Crop button’ which is on top right corner. Further, MS Word provides you an option to pour ‘Artistic Effects’. You will find this icon on top left corner.                                         ...
Post a Comment
Read more

SHORT CUT KEYS IN EXCEL

When it comes to make table, data sheet, pie chart and graphs we prefer Microsoft Excel. Therefore, another name of excel is worksheet. By inserting formula and short cut keys we can easily navigate the data. Although Excel has an advanced version, we will start up with basic formula.  Shift+F11:   By using this key a new sheet appears in excel. For instance, if you are working in sheet 1 and you require sheet 2, for this press Shift+F11 F2: This key is used to rename the cell in excel doc. Ctrl+D: This key is used to copy the selected cell vertically. Select the targeted cell, press  Shift+ D ownward arrow and finally press Ctrl+D                                Ctrl+ PAGE UP: This key is used to move to the previous sheet in excel. Ctrl+ PAGE DOWN: This key is used to move to the next sheet in excel. Ctrl + Downward arrow: This key drag you to the last cell in excel sheet....
Post a Comment
Read more