The correct answer is: B. Array formula
An array formula is a formula that performs multiple calculations on a range of cells. It is entered by pressing Ctrl+Shift+Enter instead of Enter.
Standard formulas are formulas that perform a single calculation on a single cell. They are entered by pressing Enter.
Complex formulas are formulas that perform multiple calculations on a single cell. They are entered by pressing Enter.
Smart formulas are formulas that are created by Excel automatically. They are used to perform common tasks, such as summing a range of cells or finding the average of a range of cells.
Here is an example of an array formula:
=SUM(A1:A10)
This formula will add up the values in cells A1 through A10.
Here is an example of a standard formula:
=A1+A2
This formula will add the values in cells A1 and A2.
Here is an example of a complex formula:
=IF(A1>B1,”A is greater than B”,”B is greater than A”)
This formula will return the text “A is greater than B” if the value in cell A1 is greater than the value in cell B1, and the text “B is greater than A” if the value in cell A1 is less than or equal to the value in cell B1.
Here is an example of a smart formula:
=SUM(A1:A10)/COUNT(A1:A10)
This formula will return the average of the values in cells A1 through A10.