Đang chuẩn bị liên kết để tải về tài liệu:
Beginning Microsoft Excel 2010 phần 3

có thể xảy ra của họ trên thanh trạng thái quá nếu bạn cần chúng, chỉ cần nhấp vào chúng trên. Nhưng bây giờ mà chúng tôi đã nhận được bàn chân của chúng tôi ướt trong hồ bơi Olympic-kích thước của các chức năng, lấy một khăn tắm và ngồi lại, | CHAPTER 3 FROM DATA ENTRY TO DATA CREATION FORMULA BASICS AND BEYOND Figure 3-21. Where you can add functions to the Status Bar Thus Numerical Count that is COUNT Max and Min can take their place on the Status Bar too if you need them simply click them on. But now that we ve gotten our feet wet in the Olympic-sized pool of functions grab a towel and sit back because we ve some more copying and moving to do of a different and most important kind. And in this connection let s go all the way back to that sample grade-average worksheet I served up in Chapter 1 the one festooned with red highest-score cells and those Sparklines. Don t remember it I m not taking it personally look at Figure 3-22 for a refresher 66 CHAPTER 3 FROM DATA ENTRY TO DATA CREATION FORMULA BASICS AND BEYOND Exams Student 1 2 3 4 5 Average Alice 67 96 67 100 85 83.0 Derek 82 89 45 93 67 75.2 X Dorothy 73 70 93 65 93 78.8 Edith 81 48 52 75 76 66.4 George 90 67 84 59 77 75.4 Gordon 90 86 89 77 94 87.2 John 83 96 60 63 70 74.4 Mary 77 78 80 90 100 85.0 Paul 61 91 68 61 99 76.0 Ringo 56 80 79 82 77 74.8 Class Averages 76.0 80.1 71.7 76.5 83.8 Figure 3-22. Grade averages by student Now look at the Formula Bar. I ve clicked cell I10 the one bearing Alice s exam average and its means of calculation using AVERAGE of course-----is recorded up there in that bar. By way of review we see that Alice s grades occupy range D10 H10 and by inserting that range reference between average s parentheses we determined her average grade was 83.0. The point is this What if I have 150 students in the class and I ve had more than that on occasion and I need to figure the test average for each and every one of them Do I have to click the AutoSum button 150 times in order to carry out that disagreeable task Yes that sounds like a rhetorical question and it is. The answer to it is no because what we can do instead is copy Alice s AVERAGE formula down the I column for as many rows of students as I need. Yes this is a .