Which term is defined as an equation that makes a calculation based on the data in your spreadsheet?

Which term is defined as an equation that makes a calculation based on the data in your spreadsheet?

• A. Queries
• B. Formulas
• C. Uniform Resource Locator (URL)
• D. Viruses

Answer: (B)

In spreadsheets, calculations are performed with formulas. A formula is an equation‑like expression that uses cell references, numbers, operators, and sometimes functions to compute a value from the data you have. For example, =A1+B1 adds the values in two cells, or =SUM(B1:B10) totals a range. Formulas typically start with an equals sign, signaling the program to perform a calculation. This distinguishes them from other terms: a query pulls specific data from a database, a URL is a web address, and viruses are harmful software.

In spreadsheets, calculations are performed with formulas. A formula is an equation‑like expression that uses cell references, numbers, operators, and sometimes functions to compute a value from the data you have. For example, =A1+B1 adds the values in two cells, or =SUM(B1:B10) totals a range. Formulas typically start with an equals sign, signaling the program to perform a calculation. This distinguishes them from other terms: a query pulls specific data from a database, a URL is a web address, and viruses are harmful software.