Combined Insurance interview question

Turn raw data into usable info, especially in excel.