Answer:
RANK.AVG
Explanation:
Required
Arrange data in descending order based on average
The feature to do this is to use the RANK.AVG() function.
By default, the function will return the ranks of the selected data in descending order (i.e. from highest to lowest); though, the sort order can be changed to ascending order.
The syntax is:
=RANK.AVG (number, ref, [order])
Where
number 
The number to use as rank
ref The cell range
order 0 represents descending order while 1 represents ascending order
Answer:
Explanation:
The following code is written in Java and is a function/method that takes in an int array as a parameter. The type of array can be changed. The function then creates a counter and loops through each element in the array comparing each one, whenever one element is found to be a duplicate it increases the counter by 1 and moves on to the next element in the array. Finally, it prints out the number of duplicates.
public static int countDuplicate (int[] arr) {
int count = 0;
for(int i = 0; i < arr.length; i++) {
for(int j = i + 1; j < arr.length; j++) {
if(arr[i] == arr[j])
count++;
}
}
return count;
}
Answer:
The code will get stuck in an infinite loop.
Explanation:
Since val is decreasing by 1 each time it meets the criteria of being smaller than 10, your code will get stuck in an infinite loop since val will always be smaller than 10.
Hope this helps :)
Answer:
I would need the sentence to make sure that I am correct but I am pretty sure it is C. aficionados
Explanation:
Hi There!
Binary Coding is not for games! If you want to learn coding go on a website called codeacademy!
Hope This Helps!
