BT Group interview question

Basic questions on Excel, pivot etc