MO-211 practice question 11 of 35
What is the formula to calculate the product of cells A1 to A10?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
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.
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.
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)."
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
