Function of Ctrl + Shift + Enter

[Kenneth]

What is the function of this?
What is the different between purely enter after a formula?

 

[Niek Otten]

Read this:

http://www.cpearson.com/excel/ArrayFormulas.aspx