EXCEL的单元格引用中，以下属于混合引用的是（）。

Question

A. [img]https://img.shiyebian.net/sybshijuan/198/31.png[/img]
B. [img]https://img.shiyebian.net/sybshijuan/198/32.png[/img]
C. [img]https://img.shiyebian.net/sybshijuan/198/33.png[/img]
D. [img]https://img.shiyebian.net/sybshijuan/198/34.png[/img]

Answer 1

【答案】：B、C
本题考查计算机基础知识。
A项错误，绝对引用时，复制公式时地址不会跟着发生变化，如[img]https://img.shiyebian.net/sybshijuan/198/35.png[/img]单元格有公式：[img]https://img.shiyebian.net/sybshijuan/198/36.png[/img]。当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/37.png[/img]单元格时仍为：[img]https://img.shiyebian.net/sybshijuan/198/36.png[/img]；当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/39.png[/img]单元格时仍为：[img]https://img.shiyebian.net/sybshijuan/198/36.png[/img]。
B、C项正确，混合引用时，复制公式时地址的部分内容跟着发生变化，如[img]https://img.shiyebian.net/sybshijuan/198/35.png[/img]单元格有公式：[img]https://img.shiyebian.net/sybshijuan/198/42.png[/img]。当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/37.png[/img]单元格（向下拖）时变为：[img]https://img.shiyebian.net/sybshijuan/198/44.png[/img]；当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/39.png[/img]单元格（向右拖）时变为：[img]https://img.shiyebian.net/sybshijuan/198/46.png[/img]。
D项错误，相对引用时，复制公式时地址跟着发生变化，如[img]https://img.shiyebian.net/sybshijuan/198/35.png[/img]单元格有公式：[img]https://img.shiyebian.net/sybshijuan/198/48.png[/img]。当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/37.png[/img]单元格时变为：[img]https://img.shiyebian.net/sybshijuan/198/50.png[/img]；当将公式复制到[img]https://img.shiyebian.net/sybshijuan/198/39.png[/img]单元格时变为：[img]https://img.shiyebian.net/sybshijuan/198/52.png[/img]。
故正确答案为BC。