Question

question 2
which statement is true about excel formulas and functions?
a function is a built-in formula you call with arguments (e.g., sum(a1:a10))
functions only work on text
a function is not a formula
a formula must always use a function

Explanation:

• Analyze Option 1: In Excel, a function is a built - in formula that takes arguments (like SUM(A1:A10) where A1:A10 is the argument range for the SUM function to calculate the sum of values in that range). This is a correct description of Excel functions.
• Analyze Option 2: Excel functions can work on numbers (e.g., SUM, AVERAGE), dates (e.g., TODAY, DATE), and text (e.g., CONCAT, LEFT) as well. So the statement "Functions only work on text" is false.
• Analyze Option 3: Functions are a type of formula in Excel. A formula can be a simple arithmetic operation (like =A1 + A2) or a function - based operation (like =SUM(A1:A2)). So the statement "A function is not a formula" is false.
• Analyze Option 4: A formula in Excel can be a simple arithmetic expression without using a function. For example, =A1 + B1 is a formula that does not use a function. So the statement "A formula must always use a function" is false.

Answer:

A. A function is a built - in formula you call with arguments (e.g., SUM(A1:A10))