Microsoft Excel 2021365 - Beginner to Advanced - Ranking Data with Sorting Using RANK.EQ and RANK.AVG

The video tutorial explains how to rank movies based on the number of five-star reviews using Excel. It introduces the RANK function and its arguments, demonstrating how to rank data without altering the original order. The tutorial also covers handling ties in rankings and introduces the RANK.AVG function, which calculates the average rank for tied values. Examples include ranking movies and call logs, illustrating the differences between RANK and RANK.AVG functions.

What is the main limitation of sorting movies by their five-star reviews directly?

• It changes the order of movie titles.

• It only works with numbers.

• It does not sort the reviews correctly.

• It requires additional software.

Which function is used in Excel to rank items based on a specific criterion?

• Sum

• Sort

• Rank

• Filter

What does the optional 'order' argument in the Rank function specify?

• The number of items to rank

• The order of ranking: ascending or descending

• The type of data to rank

• The color of the ranked cells

How does Excel handle two movies with the same number of five-star reviews using Rank.EQ?

• It removes one of the movies.

• It assigns them different ranks.

• It averages their ranks.

• It assigns them the same rank.

What happens to the ranking positions when two items have the same rank using Rank.EQ?

• The next rank is skipped.

• The next rank is doubled.

• The next rank is unchanged.

• The next rank is halved.

What is the main difference between Rank and Rank.AVG functions?

• Rank.AVG requires additional software.

• Rank.AVG assigns the same rank to all items.

• Rank.AVG calculates an average rank for tied items.

• Rank.AVG only works with text data.

How does Rank.AVG calculate the average rank for tied values?

• By assigning the lowest rank to all tied values

• By assigning the highest rank to all tied values

• By ignoring the tied values

• By averaging the positions of the tied values