when I click the drop-down and then when I select average I should take note of what is currently being selected. I'm making the assumption that what I did last time will work in this situation but let's replay that. I have the wrong answer because what I'm doing is also known as going on automatic pilot. I can't wait to use this in my calculations except I have the wrong answer here.
I'll click and then press ENTER and all of a sudden I have the average just like that. Now I want to get the average so I'm gonna head over to the average since this worked so well for summing values let me click the drop-down and select the appropriate function, average. The one-click is a click on autosum and then the keyboard key I'm gonna press is enter and now I have the total much quicker than the prior method. The autosum functions are gonna automate this for me because if I want to get the same answer all it takes is one click and one press of a keyboard key. then I can put in the closed parenthesis and press enter this will give me the total, but it takes some time. Now I could type equal and then type sum open parenthesis then I could take my mouse and select all the values that I want to sum. I'm gonna head over to the first cell underneath the total header and I want to come up with the total of Alex's scores. I've been a little slow in getting him his scores so I am now going to focus on that. I'm gonna pretend that one of those students is Alex and he's been bugging me to get his test scores because he wants to apply to college. We have 12 students who have taken five tests. Now let's talk about this table of information. If I go to the formulas tab this time over to the left, right after the insert function command, is Auto sum and just like with Auto sum functions on the Home tab I can click this drop-down triangle and access the other Auto sum functions available there. The other place that you can go to is the formulas tab. you can also access more functions, but these are the five most commonly used ones. if you want to find the other functions that are in the package of Auto sum functions just click the little drop-down arrow and you'll see average, count numbers, Max, and min. Now if you're just looking to sum values you can simply click on autosum. in the editing group, you'll see this Greek symbol with Auto sum. First, you can go over to the home tab and then when you click on the home tab you'll head all the way over to the right and you'll go to the editing group. There are two places you can go to access the autosum functions. Well, they are the five most commonly used functions in Excel. when it comes to coming up with answers for complex tables like this, well, this is not too complex, but it's definitely a step up from the basic calculations. Excel’s Autosum functions help you to automate your calculations.
0 kommentar(er)
