The LARGE or SMALL functions can be used with arrays to get the k largest or smallest values in a dataset. This process can use variable number for k in the formula by using the & and connecting it to a cell that can change. True False

The   is the difference between the largest and smallest values that occur in a set of data.

______ function is use to get maximum number of among series of data in excel.

Imagine a sports event where participants are ranked based on their performance, and medals are awarded to the best athletes. In this scenario, you have an array of athletes' performance scores and you want to identify the kth largest score among all the scores.ExampleInput:N = 5, scores = {3, 5, 1, 2, 4}k = 1Output:5Explanation: The 1st largest score in the provided scores {3, 5, 1, 2, 4} is 5.Input format :The first line of input consists of an integer N, representing the number of athletesThe second line consists of N space-separated integers, representing the athlete scores.The third line consists of an integer k.Output format :The output prints the kth largest score.Refer to the sample output for formatting specifications.Code constraints :1 ≤ N ≤ 201 ≤ scores ≤ 100Sample test cases :Input 1 :53 5 1 2 41Output 1 :5Input 2 :610 20 30 40 50 604Output 2 :30

K-ClosenessYou are given an array 𝐴A of length 𝑁N, and an integer 𝐾K.You can perform the following operation:Choose any index 𝑖i (1≤𝑖≤𝑁1≤i≤N), and increase 𝐴𝑖A i​ by 𝐾K.Find the minimum possible value of max⁡(𝐴)−min⁡(𝐴)max(A)−min(A) attainable, if you can perform this operation as many times as you like (possibly, zero times).Input FormatThe first line of input will contain a single integer 𝑇T, denoting the number of test cases.Each test case consists of two lines of input.The first line of each test case contains two space-separated integers 𝑁N and 𝐾K — the length of the array and the parameter 𝐾K.The second line contains 𝑁N space-separated integers 𝐴1,𝐴2,…,𝐴𝑁A 1​ ,A 2​ ,…,A N​ — the initial values of the array elements.Output FormatFor each test case, output on a new line the answer: the minimum possible value of max⁡(𝐴)−min⁡(𝐴)max(A)−min(A) if you can perform the given operation any number of times.Constraints1≤𝑇≤1051≤T≤10 5 1≤𝑁≤2⋅1051≤N≤2⋅10 5 1≤𝐾≤1091≤K≤10 9 1≤𝐴𝑖≤1091≤A i​ ≤10 9 The sum of 𝑁N over all test cases won't exceed 2⋅1052⋅10 5 .Sample 1:InputOutput43 41 5 43 212 8 44 11 43 62 8256 121 2 4 128 130 1311008Explanation:Test case 11: Increase the first element by 𝐾=4K=4 to obtain the array [5,5,4][5,5,4].Here, max⁡−min⁡=5−4=1max−min=5−4=1, which is the best possible.Test case 22: The second and third elements can be increased by 22 till they reach 1212, at which point all the elements of the array are equal, so max⁡(𝐴)−min⁡(𝐴)=0max(A)−min(A)=0.Test case 33: Since 𝐾=1K=1, again it's possible to make all the elements equal.Test case 44: Do the following:Increase 𝐴1A 1​ by 1212 repeatedly to make it 133133.Increase 𝐴2A 2​ by 1212 repeatedly to make it 134134.Increase 𝐴3A 3​ by 1212 repeatedly to make it 136136.The array is now [133,134,136,128,130,131][133,134,136,128,130,131].For this array, max⁡(𝐴)−min⁡(𝐴)=136−128=8max(A)−min(A)=136−128=8.It can be shown that this is optimal.

What does the =LARGE function do if you use it with a range?Returns numeric values based on their position in a list when sorted by values; such as largest to smallestOnly shows the largest number of the rangeRemoves the largest number of a range