Microsoft Excel: Formulae and Functions

Included are two resources that could be used for a full lesson on formulae and functions in Excel. This would be ideal as an introductory lesson.

Students can be given the card sort (laminated) in pairs and must construct various formulae/functions based on teacher instructions. The class can then discuss what 'punctuation' is always the same and can differentiate between a formula and function.

Then they can test out their skills, pretending they are the owner of an ice cream shop. They are given a set of sales data for November and must complete various tasks (using formulae, functions and assessing the data). Answers have been provided on the original Excel document. I have given the pupil instructions as a Word file as one key area of learning for me is having students type out information accurately; however, you can easily give them the original Excel file instead.