MO-211 practice question 11 of 35

What is the formula to calculate the product of cells A1 to A10?

Full set: 355 questions

Domain Insert tables, charts, SmartArt, 3D models, and media

Answer options
A: PRODUCT(A1, A10)
B: PRODUCT(A1-A10)
C: PRODUCT(A1:A10) Correct answer
D: PRODUCT(A1, A9)
Correct Answer:
C. PRODUCT(A1:A10)
Explanation

The PRODUCT function in Excel is used to multiply all numbers provided as arguments. The correct syntax for defining a continuous range of cells, such as from A1 through A10, is to use a colon (:) between the first and last cell references. The formula PRODUCT(A1:A10) correctly identifies this range, instructing Excel to calculate the product of the numerical values in all cells from A1 to A10, inclusive.

Why Incorrect

A. PRODUCT(A1, A10) only multiplies the values in the two specified cells, A1 and A10, ignoring the cells between them.
B. PRODUCT(A1-A10) is syntactically incorrect. The hyphen (-) is a subtraction operator, not a range identifier, and will result in a #VALUE! error.
D. PRODUCT(A1, A9) multiplies only the values in cell A1 and cell A9, omitting the rest of the intended range.

References

1. Microsoft Corporation. (n.d.). PRODUCT function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/product-function-8e6b5b24-90ee-4650-aeec-80982a0512ce

Reference Details: The "Syntax" section explicitly shows PRODUCT(number1

[number2]

...) and the examples demonstrate that an argument like A1:A10 can be used to "multiply the numbers in cells A1 through A10."

2. University of California

Berkeley. (n.d.). Excel: Formulas & Functions. UC Berkeley Library. Retrieved from https://guides.lib.berkeley.edu/excel/formulas

Reference Details: Under the section "The components of a formula

" the guide explains that a "range of cells" is specified using a colon

providing the example A1:A5.

3. Indiana University. (2023

October 10). Use formulas and functions in Excel. University Information Technology Services (UITS). Retrieved from https://kb.iu.edu/d/aiau

Reference Details: In the section "Referring to cells

" it is stated: "To refer to a range of cells

type the address of the first cell in the range

a colon (:)

and then the address of the last cell in the range (for example

A1:B10)."

Scroll to Top