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


Answer: A

Computer Science & Information Technology

You might also like to view...

The differences between a shape and a symbol include all of the following ex-cept.

(a) A shape is a vector graphic which has not yet been converted to a symbol. (b) Shapes can be edited with the Paint Bucket and Ink Bottle tools but symbols cannot. (c) Symbols include graphics, buttons and movie clips. (d) Shapes are interactive and can have actions applied to them.

Computer Science & Information Technology

Which tab in the Properties dialog box shows information about revisions to the document as well as the number of pages, word, lines, paragraphs, and characters in the file?

A. Statistics B. General C. Contents D. Summary

Computer Science & Information Technology

A project planning tool that shows basic information about each project task as horizontal bars on a timeline graph is call a ____.

A. planning chart B. pie chart C. predecessor chart D. Gantt chart

Computer Science & Information Technology

When does the support for open access to Internet grow in a country?

a. When only private-sector organizations gain online access b. When only government officials gain online access c. When more people gain online access d. When online access is limited to schools and colleges

Computer Science & Information Technology