Does the order of columns in an index matter?

In this blog Joe answers the question, 'does the order of columns in an index really matter?' He provides several examples and shows the results of the Query Execution Plan.