Free Microsoft MO-211 Actual Exam Questions - Question 11 Discussion

The hyphen in B isn’t valid syntax for cell ranges, so C is the safe bet.

C imo, it’s the only option that correctly covers all cells A1 through A10.

Option C works because it correctly uses the colon to include every cell from A1 through A10 in the product calculation. The other choices either use commas that separate individual cells, but not the whole range continuously, or have incorrect syntax like in B. Also, options A and D don’t cover all cells in the range, so they can’t be right. This notation is standard in modern spreadsheet software like Excel and Google Sheets, so it’s the most straightforward and reliable choice.

C imo, because PRODUCT needs a range or individual cells separated by commas, and A1:A10 is the standard way to refer to all those cells together. B's syntax is just wrong with that dash.

Maybe C makes the most sense since it includes every cell from A1 to A10 in one go. A and D miss some cells, and B isn’t even the right syntax with that minus sign.

It’s C for sure. The question wants the product of every cell from A1 through A10, and using a colon to specify the range is how you do that in spreadsheet formulas. A and D don’t cover all cells, and B uses a minus sign, which doesn’t make sense here. So C is the only one that correctly multiplies all those cells together in one go.

Is it clear if we should use a range or individual cells? Because C looks right if it's a continuous range, but A and D separate cells don’t cover all 10. Does the question imply a range?