FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The RANK Function[1] is categorized as an Excel Statistical function. The function returns the statistical rank of a given value within a supplied array of values. Thus, it determines the position of a specific value in an array.

Detailed explanation-2: -RANK gives duplicate numbers the same rank. However, the presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers sorted in ascending order, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6).

Detailed explanation-3: -To calculate the Range for these numbers, we need to find the upper and lower values using the MAX and MIN function in the list of those cells. Once we get the maximum and minimum values out of those numbers, then subtract the Max value from the Min value. The returned number will be the range.