The new functions do all that calculating internally and return a range of result values ... be in a Table, but don’t enter the actual function into a Table. Excel’s built-in dynamic array ...

Thanks to the new dynamic array functions, complicated requirements are easier than ever to meet. The results ... Ctrl + T. Excel provides the Table with a default name, but you can change it ...