Microsoft Excel Tutorial: Extracting Values

This video tutorial covers extracting values using Excel functions: small, large, rank, and percent rank. It begins with the small function to find the NTH smallest value, followed by the large function for the NTH largest value. The tutorial then explains ranking numbers in a range, both in ascending and descending order. Finally, it covers the percent rank function to determine percentile ranks. Each function is demonstrated with examples, and the video concludes with a Q&A invitation.

What is the primary purpose of the SMALL function in Excel?

• To calculate the average of a dataset

• To rank values in ascending order

• To find the Nth smallest value in a dataset

• To find the Nth largest value in a dataset

If you want to find the second smallest number using the SMALL function, what should you input as the N value?

• 1

• 2

• 4

• 3

How does the LARGE function differ from the SMALL function?

• It ranks values in descending order

• It calculates the median of a dataset

• It finds the Nth largest value

• It finds the Nth smallest value

What is the default order for the RANK function if no order is specified?

• Descending

• Ascending

• Alphabetical

• Random

Which argument in the RANK function allows you to specify ascending or descending order?

• Significance

• Order

• Range

• Cell number

What does the PERCENTRANK function return in Excel?

• The sum of all values in a dataset

• The median of a dataset

• The average of a dataset

• The rank of a value as a percentage of the dataset

In the PERCENTRANK function, what value is given to the highest value in the dataset?

• 1

• 2

• 0.5

• 0