A C D Purchase Price Current Value Rank Asset 8/4/2008 CD 12/22/2008 Stock 4/3/2009 Bond 8/13/2009 Bond 10/20/2009 Stock 5. Purchase Date 6. 20.00 $ 65.00 4 $ 17.00 $ 40.00 8 $ 10.00 $ 35.00 6 7.00 $...

4

DO NOT COPY FROM OTHER WEBSITES

Correct and detailed answer will be Upvoted else downvoted. Thank you!

Extracted text: A C D Purchase Price Current Value Rank Asset 8/4/2008 CD 12/22/2008 Stock 4/3/2009 Bond 8/13/2009 Bond 10/20/2009 Stock 5. Purchase Date 6. 20.00 $ 65.00 4 $ 17.00 $ 40.00 8 $ 10.00 $ 35.00 6 7.00 $ 17.00 $ $ 45.00 10 2$ 18.02 14 13 17 $ 20.00 $ 25.65 12/11/2009 CD 9/1/2010 CD 11/28/2010 Bond 8/10/2011 CD 8/12/2012 Bond 11/12/2012 Bond 11/22/2012 CD 3/2/2013 Bond 11 12 2$ 10.00 $ 12.50 13 $ 24.00 $ 28.00 11 14 25.00 $ 27.50 12 15 $ 6.00 $ 10.00 19 16 9.00 $ 10.54 18 17 $ 24.00 $ 30.00 10 18 2$ 19.00 $ 32.12 5/21/2013 Stock 9/7/2013 Stock 7/22/2014 CD 3/6/2015 Stock 7/13/2015 Stock 10/25/2015 CD 19 $ 14.00 $ 75.00 2.5 20 $ 18.00 $ 60.00 5 21 2$ 9.00 $ 13.50 16 22 15.00 $ 110.00 23 20 24 15.00 $ 15.90 15 What is the correct formula to calculate the Rank for the current values in cell F23? O -RANK.AVG(E23,E$6:E$24) O =RANK.EQ(E23,E$6:E$24) O =RANK.AVG(E23,E6:E24) O -RANK.EQ(E23,E6:E24) ト