Which term defines the formulas used to perform calculations on spreadsheet data?

Which term defines the formulas used to perform calculations on spreadsheet data?

• A. Distribution Lists
• B. Formulas
• C. Keywords
• D. Presentation Software

Answer: (B)

In a spreadsheet, calculations are performed with formulas. A formula is an expression that uses numbers, cell references, operators, and built-in functions to compute a result. When you enter something like =A1+A2 or =SUM(B2:B10), the program evaluates it and updates the result automatically as data changes, allowing you to quickly calculate totals, averages, percentages, and more. Other options don’t fit because they relate to different tools or concepts: Distribution lists are for grouping email addresses, keywords are search terms or metadata, and presentation software is used to create slides.

In a spreadsheet, calculations are performed with formulas. A formula is an expression that uses numbers, cell references, operators, and built-in functions to compute a result. When you enter something like =A1+A2 or =SUM(B2:B10), the program evaluates it and updates the result automatically as data changes, allowing you to quickly calculate totals, averages, percentages, and more.

Other options don’t fit because they relate to different tools or concepts: Distribution lists are for grouping email addresses, keywords are search terms or metadata, and presentation software is used to create slides.