Please help on this three part problem, it seems simple but I have not done this in a while, an explanation with screenshots would really help,

Please help on this three part problem, it seems simple but I have not done this in a while, an explanation with screenshots would really help, thanks - the link to the Excel file is provided below (copy and paste into a new tab/browser)

Excel file: https://1drv.ms/x/s!AnWxTJTVVD_IgQAE9HtWAQXun4Iu