This is a 7 page document perfect for students to work on individually. I would say it is perfect for year 7 and 8 but could be used for older KS2 children also. The document then briefly describes ...

Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.

There are 4 MS Excel worksheets to teach the basic excel functions such as SUM, AVERAGE, MAX and MIN. Suitable for primary grades 3, 4 and 5.