Welcome back. In this video, you'll learn more about Microsoft Excel, in particular, will be present pains and working with some formulas and before I get started, I should mention that
Information shown here. You can find a link to that in the same area as you found the link to this video.
But first thing we do is I look at to freeze and pain supposed to start entering data here, especially if I had a small monitor this would get a little unwieldy and as I would be a scrolling back and forth.
Trying to enter information. So in this case, if I take a look at that as I scroll right now. The name goes off the screen.
Well, what I can do is freeze the pain. So I can select call a I can come up here to view priests pants. I won't even have to hit them. It's like, how many just freeze that first column.
Now watch as a slide I can name is going to stay frozen. So I can enter the data, so I don't have to move as an expert back and forth. I don't have to scroll in order to enter that data.
Okay, now it's time to the inner some data here and I'll go ahead and match what's on the handouts that was a 15
And I'll tell best I can type numbers in here.
Okay, it doesn't matter. I just entered some data here, the big city through ok so again by pressing the pains on able to get the names display in. Now I can
See the name while I'm entering the score. Okay. Well, the next thing we'll do is a compute the total again we've got this match their course.
But 1415 students here, maybe some ID. The Q1. That'd be a quiz. The exam or resume a paper or presentation, etc. There
But the first thing I need to do is know how many points are possible Solomon add all this up with the commission of number c to through Tito Tito sama simply write a formula equals some it's going to be si tu
Tu, Tu
And at the end of June. Okay. So, looks like there was a 410 points possible in this imaginary course at this point, I could repeat that process resumes then continue on down.
That K her case it would be see 333 right just that Microsoft Excel generate that for me. Someone position my cursor over there going, no returns the crosshairs
Drag on down. But no, I didn't create a formula that does it also do the copy of the format in someone's going to come right up here and cheers
Okay, so if I just press on one server. Now see 333 so it's something see three through 33. Okay. Next we need to do is I computed percentage that's going to be YouTube
Divided by 410
Yeah, one thing you're going to notice this number cannot be displayed the whole number can be displayed Microsoft Excel will not display any of the number that is not the case with tax and somebody was to unfreeze
We came up here and resize this first column which just means tax names. It's going to simply display as much as possible.
For as many numbers ahead, and I get that person again.
Raspberry whereas with numbers and percentages of the whole number cannot be displayed number would be, for example, someone had a 94% and he decided
Not to display the nine. So, my good. Wow, it's still here. I've only got 4% of the class. Okay, so again if it cannot be displayed. None of it is so again I position my cursor on the piano and drive it on down.
Remove the formatting them. Okay, last step is to compute the grade and I can either put it here or appear like a certain see up here. Let's take a look. Start off is the information and be too.
Is that greater than or equal to 90%
If so, what do I do on this planet. And that's not going to start a second
I'm gonna go well because V2 greater than or equal to zero TT percent
So display be if not starting another. So I'll take what has been to greater than or equal to 70% AND IF SO, LET'S PLAY A see with them construction.
And then finally, one last one I would take a look is be to read later equal to 60% so display ad, not on this by now I need to make sure I close my why parenthesis.
Okay, at this point, I can disposition or cursor on the pro handle and copy that formula.
And I'll go ahead and turn off.
OK. So again, the power of Microsoft Excel. Look at the student right here, Amy. She's got a 69 let's just go ahead. She never turned in the paper.
On time, she turns in a way to winds up getting 30 points. And as soon as we get that 30 points, we can see for averages automatically jump to
76 and she is now getting to see. And of course, well hopefully this video you'll learn a little bit more about Microsoft Excel, maybe a particular a freezing pains, working with
Price how gets mixed media. Thanks.