Excel中C7单元格中有绝对引用=AVERAGE($C$3

---

问题: Excel中C7单元格中有绝对引用=AVERAGE($C$3:$C$6),把它复制到C8单元格后,双击它单元格中显示?

A: =AVERAGE(C3:C6)

B:=AVERAGE($C$3:$C$6)

C:=AVERAGE($C$4:$C$7)

D:=AVERAGE(C4:C7)