Topics-References, logical operator, Stat formulas, IFS, Vlookup, Hlookup, Practice lookup, Index match, Switch, EMI calculator, Text formula, Date & time formulas, Error type, Offset-Match, Pivot chart
I've included the assignment with a solution sheet, so attempt to solve it on your own first.