how can I solve this question into the excel sheet? the answers are in the srcond photo. I'm not familiar with excel. thank you in advance for your help

E F 1 2 3 A C D Problem: 6 5 Points Determine cost of ending Inventory using Lower of Cost or Market method. (LCM) 4 5 6 7 Last Purchase Invoice Next to the last purcase invoice Descriptio Quantity Purchase Unit A 75 Unit Cost $ Quaintity Purchase Unit Cost 50 $ 10.00 12.00 Unit B 100 $ 15.00 75 $ 14.00 Unit C 150 $ 18.00 100 $ 20.00 31-Dec-19 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Quaintity on Hand 86 Market Price $ 11.00 Unit A Unit B 112 $ 13.00 Unit C 110 $ 19.00 6. Unit A = 75 x $10 = 750 (Lower cost) (86-75)