当Excel工作表C7单元格中有绝对引用=AVERAGE($C$3:$C$6),把它复制到C8单元格,则该单元格中的公式是
=AVERAGE(C3:C6
=AVERAGE($C$3:$C$6)
=AVERAGE($C$4:$C$7)
=AVERAGE($D$4:$D$7)