business analytics midterm

Hi I have this midterm and I need help with it, please read instructions which are in the excel file.