Question $5$

$2$ pts

Which is the correct formula to determine the rank of the number in cell B$2$ wirhin the list of numbers in range $B2$:$B10$ with respect to a ascending order $($we want the smallest number to be the top rank: $1)?$

$=$RANK.$EQ(B2$:$B10,B2,1)$

$=$RANK.$EQ(B2,B2$:$B10,0)$

$=$ RANK.EQ$($B$2,$ B$2$:B$10,1)$

$=$ RANK.EQ$($B$2$:B$10,$ B$2,$ O$)$