What is the term for the set of instructions used to perform addition calculations in Excel?

• A. Function
• B. Formula
• C. Macro
• D. Script

Answer: (B)

At its heart, the term you're looking for is formula—the set of instructions you enter in a cell to compute a value. In Excel, an addition operation like adding two numbers or cell references is written as a formula, typically starting with an equals sign, for example =A1+B1. A formula can mix operators and cell references to perform any arithmetic. A function, by contrast, is a predefined calculation named like SUM or AVERAGE that you call with arguments, which Excel then processes. A macro is a stored sequence of actions, usually written in VBA, used to automate tasks. A script refers to a programmatic set of instructions in a scripting language; Excel’s scripting options exist but aren’t the standard term for a basic addition operation. So the set of instructions used to perform addition calculations in a worksheet is best described as a formula.