Case 7

Case 7 was a compact case with interesting functions like:

❖ Nested IF function
❖ VLOOKUP function
❖ COUNTIF function
❖ SUMIF function
❖ AVERAGEIF function
❖ Database functions

These functions are very useful with large tables. I liked especially the VLOOKUP but even more the database function that will look up for a CRITERIA and then will calculate for what u ask like DSUM, DAVERAGE,...