A formula is an expression created by a user that calculates a value in a cell. It must always begin with an equals sign (=). A function is a predefined, named formula that is built into Excel to perform a specific calculation. Functions simplify complex formulas by taking specific values, called arguments, in a particular order. For example, =A1+A2+A3 is a user-created formula, whereas =SUM(A1:A3) is a formula that uses the pre-built SUM function to achieve the same result more efficiently.

A. Both formulas and functions can operate on single or multiple cells. A formula like =A1:A102 and a function like =SUM(A1:A10) both work across multiple cells.
C. They are distinct concepts. A function is a specific type of pre-built formula, but not all formulas are functions. A formula is the entire calculation expression in a cell.
D. All formulas, including those that use functions, must begin with an equals sign (=) to instruct Excel to perform a calculation.

1. Microsoft Corporation. (n.d.). Overview of formulas in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173.

Reference Point: In the section "The parts of a formula

" the document states

"Functions are predefined formulas and are already available in Excel." This directly supports the distinction made in answer B.

2. University of Washington. (n.d.). Excel 2016: The Basics. UW Bothell Information Technologies.

Reference Point: In the "Formulas and Functions" section

a formula is defined as "an equation that performs a calculation

" and a function is defined as a "predefined formula." This aligns perfectly with the correct answer.

3. Alexander

M.

Kusleika

D.

& Walkenbach

J. (2019). Excel 2019 Bible. John Wiley & Sons.

Reference Point: Chapter 10

"Introducing Formulas and Functions

" explains: "A formula is an expression that you enter into a cell... A function is essentially a predefined formula... Using a function is a real time-saver because you don’t have to create the formula from scratch." This academic-level text reinforces that a function is a pre-built formula.