Question

You are entering sales targets achieved by six marketing executives in a spreadsheet. Which function will help you find where each executive’s score stands with respect to others?

a. Lookup
b. Rank
c. Average
d. Count

Answer 1

The Rank function is used to find where each executive’s sales targets rank with respect to others in a spreadsheet, as it allows for organizing and ranking the scores.

Step-by-step explanation:

To determine where each marketing executive’s score stands with respect to others in a spreadsheet, you would use the Rank function. This function organizes the scores in ascending or descending order and assigns a rank to each score based on its value relative to the others in the list. Lookup is used to search for a value, Average calculates the mean of a set of numbers, and Count tallies the number of entries in a data set. None of these, however, provide a ranking order like the Rank function does.