Question

Give salient features of a spreadsheet.

Answer 1

• Grid-Based Layout: Organised into numbered rows and alphabetical columns.
• Unique Cell Addressing: Uses distinct coordinates (like A1) to locate data instantly.
• Built-in Formulas: Automates mathematical calculations using tools like SUM, AVERAGE, and IF.
• Automatic Recalculation: Changing one cell value automatically updates all related totals.
• Data Sorting and Filtering: Quickly reorders massive datasets alphabetically, chronologically, or numerically.
• Visual Charts and Graphs: Converts raw table figures into bar, line, or pie diagrams.
• What-If Analysis: Predicts future financial scenarios by altering individual cell variables.