Case 8

Case 8 asks to protect a worksheet. This is useful for a company and other big organizations. A second tool for companies are to create validation rules for data entry. This is like programming. It prevents employees to fenter false data and tells them whats wrong. I like the function of a macro. I heared of macro's but I never knew exactly what it was. I did not know untill I did this case. It actually records your steps and repeats it when you run the macro. I also liked that you can assign a macro to a butto.

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,...

Nested fuctions and Vlookup

For the case found here we can use nested formulas like =IF(B11>=B6,SUM(C2:C6),IF(B11>=B5,SUM(C2:C5),IF(B11>=B4,SUM(C2:C4),IF(B11>=B3,SUM(C2:C3),IF(B11>=B2,SUM(C2),IF(B11>=0,0,0)))))) . It looks complicated but if you havve a look at it it is not. It just repeats itself. The first part says that if the amount of homeruns is equal or bigger than 60, he will get 1000000 (the sum of C2:C4) and if not it would look if it is bigger orequal to 50 and so on...
For the vlookup you can convert first the range into a table to make it easier. You have to add a third column to the table with the cumulative amounts. After you did that you just need to enter the formule =VLOOKUP(B11,table1,3 where B11 is the lookup data and table1 is the name of the table where it should lookup and 3represents the column of the table where to look ti up and refer to that value.