Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown?AB51RedYes52RedYes53RedYes54BlueNo55RedYesa.  =IFNA(A51=”Red”,”Yes”,”No”)b. =SHOWIF(A51=”Red”,”Yes”,”No”)c. =COUNTIF(A51=”Red”,”Yes”,”No”)d. =SUMIF(A51=”Red”,”Yes”,”No”)e. =IF(A51=”Red”,”Yes”,”No”)