AIG Interview Question

Had to do some stuff in excel. Basic commands and functions.