This is a very grey area, because while excel is fun to enter, and play around with, often times it's seen as a pseudo-programming language.
In Excel, one can drag-down formulas to automatically match cell entries, and other minor patterns. Usually, these formulas are dragged to the bottom of the input index, or (often times) all the way down to the bottom of the sheet.
One can start to see how this gets strange very quick, as these drag-downs are useful, but hard to score.
Note, I'm not talking about answers where dragging down is part of the input. I'm explicitly referring to answers that already have the formulas in them before any input.
How should we handle these answers? Should they be ignored? Scored?