Needs to be done in excel

NEED THIS TO BE DONE IN EXCEL. READ THE QUESTION CAREFULLY AND ANSWER CORRECTLY. MY PROFESSOR HAS ALREADY GIVEN ME ANSWER FOR IT, BUT I AM NOT ABLE TO DO IT. ONLY BID IF YOU CAN DO IT. THANK YOU.