You are working as a financial analyst, creating monthly financial ratio analyses. Which of the following formulas are entered in cell C12 to return the value for the asset turnover ratio from existing ratios? 1 2 3 45678 9 10 12 13 11 A B Ratio name Current ratio Debt to equity ratio Asset turnover ratio Return on equity ratio Liquidity ratio Ratio name Ratio value fx C Value 2.4 0.84 1.35 0.31 0.93 Asset turnover ratio 1.35 Select all answers that apply: A. INDEX($C$5:$C$9,MATCH($C$11,$B$5:$B$9)) B. IF($C$11-"Asset turnover ratio",MATCH($C$11,$B$4:$B$9,0),FALSE) C. =HLOOKUP($C$11,$B$4:$C$9,MATCH($C$11,$B$4:$C$9,0), FALSE) D. =VLOOKUP($C$11,$B$5:$C$9,2,FALSE) E. IF(AND($C$11="Asset turnover ratio",$C$12="1.35), MATCH($C$11,$B$4:$C$9,0),0)

You are working as a financial analyst, creating monthly financial ratio analyses. Which of the following formulas are entered in cell C12 to return the value for the asset turnover ratio from existing ratios? Select all answers that apply: A= INDEX ($CS5:$C9,MATCH($C$11,$8$5:$B$9)) E,=IF(AND(SC$11="Asset turnover ratio $C12=1,35) MATCH ($CS11,$B$4:SCS9,0),0)