Which of the following statements about spreadsheet software (MS-Excel) are true? Choose the correct answer from the options given below.

1.Data in spreadsheets is always correct.

2.Spreadsheet software cannot draw bar graphs.

3.Spreadsheet software automatically recalculates.

4.Some cells in a spreadsheet can be locked to prevent a user changing their contents.

A1, 2 only

B3, 4 only ✓ Correct

C1, 3 only

D2, 4 only

Correct answer: (B) 3, 4 only

Explanation

Spreadsheet software automatically recalculates results and lets cells be locked, making Statement 3 and Statement 4 the true ones.

Statement 3 is right because changing one value updates every dependent formula at once.

Statement 4 is right because cells can be protected so a user cannot alter their contents.

Statement 1 is wrong because a spreadsheet only computes on the data entered, which may itself be mistaken.

Statement 2 is wrong because spreadsheets can readily draw bar graphs and other charts.

This automatic recalculation is what makes spreadsheets useful for what-if analysis.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.