SSE interview question

Excel test based on the data set that was provided