In this chapter, we revisit mathematical and statistical functions like SUM, AVERAGE, and COUNT from Chapter 2. We will take another look at setting up logical tests based on our studies of Chapter 3. We will touch upon using Excel to evaluate one or more conditions as we have done in Chapter 5 with Excel tables and PivotTables in Chapter 6. We will combine elements from all previous chapters and continue our work with the College Scorecard dataset we introduced in Chapter 6. In this chapter, we take all our existing knowledge of Excel and combine aspects of functions and formulas to do even more with them.
Chapter 8 by Emese Felvégi and Robert McCarn.