Which of the following statements about spreadsheet software (MS-EXCEL) are true?
A. Data in spreadsheets are always correct.
B. Spreadsheet software cannot draw bar graphs.
C. Spread sheet software automatically recalculates.
D. Some cells in a spreadsheet can be locked to prevent a user changing its contents.
Choose the correct answer from the options given below:

Correct option is B

The correct answer is (b) C and D only.
Statement A: "Data in spreadsheets are always correct." This statement is false. While spreadsheets are powerful tools for data management, the data they contain is only as accurate as the input. Spreadsheets do not automatically check or validate the correctness of data, so users must manually ensure the correctness of the entered data.
Statement B: "Spreadsheet software cannot draw bar graphs." This statement is false. MS Excel, and other spreadsheet software, can indeed draw bar graphs. In fact, Excel provides a wide variety of charting options, including bar graphs, line charts, pie charts, etc.
Statement C: "Spreadsheet software automatically recalculates." This statement is true. Spreadsheet software, including MS Excel, automatically recalculates formulas when the data in referenced cells change. For example, if you modify a value in a cell that a formula depends on, Excel will automatically update the result of the formula without requiring any manual intervention.
Statement D: "Some cells in a spreadsheet can be locked to prevent a user changing its contents." This statement is true. Excel allows users to lock certain cells in a worksheet to prevent changes. This feature is often used when sharing a spreadsheet but ensuring that certain critical cells (like formulas or headers) remain protected. Users can lock cells by selecting them, right-clicking to format them, and checking the "locked" option in the cell protection settings.
Information Booster 1. Automatic Recalculation (C): MS Excel is designed to automatically recalculate formulas whenever a referenced value changes. For example, if you have a sum formula like =SUM(A1:A10) and you change any value within that range, Excel will update the result immediately. This feature is extremely useful for real-time data analysis and calculations.
2. Locking Cells (D): You can lock specific cells in Excel to prevent them from being edited. To do this, select the cells you want to protect, right-click and choose "Format Cells." Then, in the "Protection" tab, check "Locked." After this, you must protect the sheet by selecting Review > Protect Sheet, which will prevent unauthorized editing of the locked cells.
Additional Knowledge · Data Accuracy (A): Incorrect. The data in a spreadsheet is only correct if entered correctly. Excel does not automatically check or correct data; it is up to the user to ensure its accuracy.
· Bar Graphs (B): Incorrect. MS Excel allows users to create a variety of graphs, including bar graphs, line charts, and pie charts, to visually represent data. These graphs help in analyzing trends, distributions, and comparisons in the data.