In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?
A) The copied formula does not refer to the correct cells and produces a result that is too large to fit in the cell.
B) The copied formula contains a cell which is blank.
C) The copied formula contains a cell with a label.
D) none of the above

Question

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?
A) The copied formula does not refer to the correct cells and produces a result that is too large to fit in the cell. 
B) The copied formula contains a cell which is blank. 
C) The copied formula contains a cell with a label. 
D) none of the above

Quizplus · Accepted Answer

The hash marks appear because the copied formula refers to cells that are not in the correct position, and therefore produces a result that is too large to fit in the cell. This is usually caused by referencing cells that are not absolute (i.e. without the '$' symbol) and changing their position when copied to a different cell.

In the Accompanying Figure, the Original Formula =B5*C2 Works Correctly