Press Enter to execute the Excel test function and return the desired values. The function is now replaced with a value representing the result of the t-test.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.