Please explain the logic behind this issue? Cell range / array question.

Hi there,   I've just learned that you can use a function within an range instead of a cell reference. I however do not understand the logic behind it and need some assistance in understanding it. ...