how to find grade in Microsoft Excel
Answers
Answer:
The best way to learn anything is to actually do something useful and Excel is the best example of this! Let’s say you are a high school or college teacher and you want to keep track of your student’s grades, calculate their average and tell them the lowest grade they would need to get on their final exam in order to pass the class.
Sounds like a simple problem and it is (once you get the formula in your head)! Excel can do this for you very quickly, so let’s see how.
First off, let’s enter some data into the cells in Excel. In Excel, the columns are labeled starting from A and continuing to Z and beyond. A cell is simply a particular row number and column, i.e. A1 is the very first cell in an Excel worksheet.
Let’s type Students into well A1 and then type A through E as the student names continuing down column A as shown below:
student names
Now let’s enter Test 1, Test 2, and Test 3 into cells B1, C1, and D1 respectively. Now we have a 5×4 grid, so let’s fill out some fake test grades also as shown below:
excel student scores
Now let’s learn some of the basics of formatting cells in Excel. Right now our table doesn’t look very nice since the text and numbers are aligned differently and the headers are not visually separate from the data. First, let’s center all the data so that things look nicer. Click on cell A1 and drag your mouse down to cell D6 to highlight the entire data set:
highlight cells excel
Then click on the Home tab and click on the Center Justify button. The grid is now nicely centered with all the data directly underneath the headings.
center data excel
Now let’s look more at how we can format Excel cells. Let’s change the color of the first row to something else so that we can clearly separate the header from the data. Click on cell A1 and drag the mouse while holding the button down to cell D1. Right click and select Format Cells.
format cells excel
Now there are two options you have at this point. You’ll notice in the image above, a normal right-click menu that starts with Cut, Copy, etc, but you’ll also notice a kind of floating toolbar right above the menu. This floating menu is kind of a popular options toolbar that lets you quickly change the font, change the text size, format the cell as money or percentage, lets you change the background or font color and add borders to the cell. It’s convenient because you don’t have to open the Format Cells dialog separately and do it there.
If you have to do some more advanced formatting not available in the quick toolbar, then go ahead and open the dialog. In this tutorial, I’ll show you the dialog method just so we can see it. In the Format Cells dialog, click on the Patterns tab and select a color from the palette. I chose yellow to make it distinct.
format cells fill tab
Click OK and you’ll now see that the color has been changed for the selected cells.
cells with format
Let’s also add some borders between the cells so that if we decide to print out the Excel sheet, there will be black lines between everything. If you don’t add borders, the lines you see in Excel by default do not print out on paper. Select the entire grid and go to Format Cells again. This time go to the Border tab. Click on the Outside and Inside buttons and you should see the small display box directly below the buttons change accordingly with the borders.
excel add cell borders
Click OK and you should now have black lines between all of the cells. So now we’ve formatted our grid to look much nicer! You can do this type of formatting for your data also in the way you feel appropriate.
excel cells formatted
Explanation:
..........