Excel is handy course that can be utilized to arrange all kinds of data. An Excel spreadsheet can be utilized to do computations with data set or just to bring jointly varied data. It is particularly helpful for making grade databases; you can make grade sheet that brings jointly more data about students, and you can search and calculate in Excel.

Instructions

Creating a Grade Sheet

Step 1

Open Microsoft Excel and stat new spreadsheet.

Step 2

Enter "Last Name" in first column, second row. Format cell in bold so it is noticeable from real names.

Step 3

Enter "First Name" in subsequent column, row. Make this daring also.

Step 4

Enter last name of student under "Last Name", preliminary on third row.

Step 5

Enter first names of learners below "First Name", starting on third row.

Step 6

Choose first two cells in initial row. In formatting toolbar, choose 'Merge Cells.' This makes one big cell in place of original two. Enter "Assignment:" in new cell.

Step 7

Enter related homework or dates in initial row. If you want to make any kind of break, signaling end of semester, choose whole column, and change color of cells so that they show up.

Step 8

Test with remaining formatting options. Create grade sheet that suits specific class and data requirements.

Step 9

Enter grades for students by getting last name on left of spreadsheet and valid assignment. In spreadsheet, you can search for particular term or number. Extra superior ability with Excel permits to run complex searches and do calculations.