I don't know how to set up a formular for calculating the moving average of the previous 5 days. The required formular should contain average(), index() and row(). What does the row() indicate?

Next, I don't know how to set up a formular for calculating the commission of a day. Commission rates of each salesperson are provided. The required formular should contain vlookup().

Finally, I don't know how to set up a formular for calculating the yearly total commission of salesperson on sheet 2. The required formular should contain sumif() and it has to refer to sheet 1.

Please help me!