Q: Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply.
or
Q: In the spreadsheet below, which of the following formulae will produce a circular reference error? Choose all that apply.
- All of these will result in a circular reference error
- Formula in cell C14=C10*C4-C10*C2
- Formula in cell C10=sum(C7:C10)*$C$2 Correct
- Formula in cell H10=sum(H5:H10)
- Formula in cell C10=sumproduct(C5:H7, C2)
Explanation: This will create a circular reference error because cell C10 is part of the range (C7 ) it is summing, which leads to the cell referring to itself.
