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

Comments

SIMPLE DECISION MAKING FLOW CHART IN MS WORD

MS WORD helps you to create different flow chart. Here, you will get an idea how to make flow chart and with the help of this tutorial you can easily create any design. SHORT CUT KEYS USED: Ctrl + C= Copy Ctrl + V= Paste

HOW TO INSERT POWERPOINT THEMES?

MS PowerPoint, gives you an option to transform white background into different themes. Besides, you have an option to select the slide size. SLIDE SIZE: Go to Design tab, you will find this icon on top right corner. THEMES : For desired themes click on Design tab and there you are provided with the list of themes. Further, you can browse your own favorite theme according to the presentation topic. There is an option to change the colors of selected theme. SLIDE MAKING: Write title and subtitle and change the font style and size.

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

Getskills1

Search This Blog