link : https://docs.google.com/file/d/1FzFWHPe0D9bChfG3W9jl9za4IVftxN8a/edit?filetype=msexcel

According to the worksheet from the link and use the 5 different Excel functions listed below:

Absolute cell referencing and Relative cell referencing

NestedIF Function i.e. multiple IF functions in the one formula

VLOOKUP Function

PivotTable and PivotChart (order)

Filters and the Subtotal function

When using the functions, make the purpose of their use relevant to the business.