在Excel中.若Sheet1工作表的A1单元格需计算Sheet2工作表中A2到A7单元格的和,则应在Sheet1工作表的A1单元格中输入______。
A: =SUM(Sheet2!A2:A7)
B: =SUM(Sheet2!A2:Sheet2!A7)
C: =SUM((Sheet2)A2:A7)
D: =SUM((Sheet2)A2:(Sheet2)A7)
A: =SUM(Sheet2!A2:A7)
B: =SUM(Sheet2!A2:Sheet2!A7)
C: =SUM((Sheet2)A2:A7)
D: =SUM((Sheet2)A2:(Sheet2)A7)
举一反三
- 要在当前工作表(Sheet1)的A2单元格中引用另一个工作表(如Sheet4)中A2到A7单元格的和,则在当前工作表的A2单元格输入的表达式应为( )。 A: =SUM(Sheet!A2:A7) B: =SUM(Sheet4!A2:A7) C: =SUM((Sheet4)A2:A7) D: =SUM((Sheet4)A2:Sheet4)A7)
- 在Excel2010的Sheet1工作表中,对Sheet2工作表的A2单元格进行绝对引用,正确的书写格式是()。 A: =[Sheet2]A2 B: =Sheet2!A2 C: =[Sheet2]$A$2 D: =Sheet2!$A$2
- 在Excel2010工作表的当前单元格A8中输入的表达式,错误的一个是() A: =Sheet2!B2+Sheet1!A2 B: =SUM(Sheet2!A1:A8) C: =SUM(a1:a7, b1,b5) D: =SUM(A1;A7)
- 要在当前工作表Sheet1的A2单元格中计算工作表Sheet2中B1到B5单元格的和,则在当前工作表的A2单元格中输入的公式是应为( )。 A: =SUM(SHEET2!B1:B5) B: =SUM([sheet2]!B1:B5) C: =SUM(B1:B5) D: =SUM([Sheet2]!B1:[Sheet2]!B5)
- 若要在当前工作表(Sheet1)的A2单元格中引用另一个工作表(如Sheet4)中A2到A7单元格数据之和,则在当前工作表的A2单元格输入的表达式应为________。 A: =SUM(Sheet4!A2:A7) B: =SUM(A2:Sheet4!A7) C: =SUM((Sheet4)A2:A7) D: =SUM((Sheet4)A2:(Sheet4)A7) E: =SUM((Sheet1)A2:(Sheet1)A7) F: =SUM(Sheet1!A2:A7)