假设在A13单元格存有一公式为SUM(B$2:C$5),将其复制到A200后,公式变为()
A: SUM(B$2:B$5)
B: SUM(C$2:C$5)
C: SUM(B$202:B$205)
D: SUM(C$202:C$205)
A: SUM(B$2:B$5)
B: SUM(C$2:C$5)
C: SUM(B$202:B$205)
D: SUM(C$202:C$205)
举一反三
- 假设在A3单元格存有一公式为SUM(B$2:$C4),将其复制到B4后,公式变为( ) A: SUM(C$2:$C5) B: SUM(B$2:C$4) C: SUM(C$3:D$5) D: SUM(B$3:C$5)
- 假设在A3单元格存有一公式为=SUM(B$2:C$4),将其复制到B8后,公式变为______。 A: =SUM(B$2:C$4) B: =SUM(C$7:D$9) C: =SUM(D$2:E$4) D: =SUM(C$2:D$4)
- 假设在A3单元格存有一公式为SUM(B$2:C$4),将其复制到B48后,公式变为:A.()SUM(B$50:B$52)()B.()SUM(C$2:D$4)()C.()SUM(B$2:C$4)()D.()SUM(D$2:E$4)
- 假设在A3单元格存有一公式为SUM(B$2:C$4),将其复制到B48后,公式变为(
- 在Exce197中,假设在A3单元格存有一公式为SUM(B$2:C$4),将其复制到B48后,公式变为()。 A: SUM(B$50:B$52) B: SUM(D$2:E$4) C: SUM(B$2:C$4) D: SUM(C$2:D$4) E: SUM(B$46:D$44)