Excel Solution Required

Hello hive mind, I'm using Excel on a Mac.   PART ONE So I have a cell in Excel that contains a drop down, the drop down has the options: Pass, Merit, Distinction, Fail   Later down the spreads...