要将Sheet1和Sheet2工作表中A1单元格内容之和存放到Sheet3的A1单元格中,那么在Sheet3的A1单元格中应输入公式______。
A: =Sheet1:Sheet2A1
B: =Sheet1!A1+Sheet2!A1
C: =Sheet1:A1+Sheet2:A1
D: =Sheet1(A1)+Sheet2(A1)
A: =Sheet1:Sheet2A1
B: =Sheet1!A1+Sheet2!A1
C: =Sheet1:A1+Sheet2:A1
D: =Sheet1(A1)+Sheet2(A1)
举一反三
- 在Excel的sheet3中正确计算sheet1的单元格A1与sheet2的单元格A1之和的是( )。 A: =SUM(Sheet!A1:A1) B: =SheetA1+SheetA1 C: =Sheet1!A1+Sheet2!A1 D: =SheetA1+Sheet2A1
- 要将Sheet1和Sheet2工作表中A1单元格内容之和存放到Sheet3的A1单元格中,那么在Sheet3的A1单元格中应输入公式______。 A: =Sheet1:Sheet2A1 B: =Sheet1!A1+Sheet2!A1 C: =Sheet1:A1+Sheet2:A1 D: =Sheet1(A1)+Sheet2(A1)
- Excel 2016默认的工作簿名是_____。 A: Sheet 1 B: Sheet 2 C: Sheet 3 D: 工作簿n.x Is x(n为整数)
- 打开Excel2003系统默认的当前工作表为（）。 A: 工作表 B: 工作表1 C: Sheet D: Sheet1
- The Balance Sheet has ( ) sides A: 1 B: 2 C: 3 D: 4