Which of the following statements about spreadsheet software (MS-EXCEL) are…

Concept — A spreadsheet is a grid of cells, each holding either a literal value or a formula, and the application keeps track of which cells feed which formulas. In automatic calculation mode every formula that depends on a changed cell is re-evaluated the moment that cell changes. Around this calculation engine sit a presentation layer (chart tools that plot any selected range of cells) and a protection layer (a per-cell Locked attribute that takes effect once the sheet itself is protected). Nothing in the software judges whether the values a user types are factually right.

Applying the concept to each statement

• Statement A, on the accuracy of stored data: the program computes faithfully on whatever is entered, so a wrong entry yields a wrong result (garbage in, garbage out). A spreadsheet offers no built-in guarantee of correctness, so this statement does not hold.

• Statement B, on charting: building a graph from a range of cells is a core spreadsheet feature, and MS-Excel's Insert then Charts group supplies Column and Bar chart types directly, so this statement does not hold.

• Statement C, on recalculation: with Formulas then Calculation Options set to Automatic (the default), editing a precedent cell immediately refreshes every formula that depends on it, so this statement holds.

• Statement D, on cell locking: every cell carries a Locked attribute (switched on by default) which becomes effective after Review then Protect Sheet, blocking edits to those cells while the remaining cells stay editable, so this statement holds.

Cross-check — Exactly two statements survive: the automatic-recalculation claim and the cell-locking claim. The choice that names those two and nothing else is “C and D only”. Any choice that includes the always-correct-data claim or the cannot-draw-bar-graphs claim fails on the statement it brings in.