Excel 2010 - possible to apply a function to an entire column?

Question

In Excel 2010, is it possible to apply a function (not a formula) to an entire column (without dragging the plus symbol all the way to the bottom)?

Answer 1

A function is part of a formula. So the below should work in exactly the same way.

Select the column you want:

Paste your formula:

Then hit Ctrl + Enter.

Done!