I only need to do question 1. Only need to fill all the yellow cell and columns

I only need to do question 1. Only need to fill all the yellow cell and columns and grey cells and columns. Also, provide explain how you do it and what formula you used.