Question

What formula would appear if you copied and pasted the fomula
=SUM(A1:A4) from cell A5 to cell C6? ...?

Answer 1

In MS excel, A denotes the column and the numbers denote the rows.
The colon shows the range of any cell.
Therefore,the fomula 
=SUM(A1:A4)
will give you the sum of all the entries in the column A,starting from first row till the fourth row.