Excel like functionality where in you can see the cell's being referenced when a cell formula is being edited.
And create formulas the same way it is done in Excel, when you are able to select regions, which contribute to the formula.