国家开放大学 / EXCEL在财务中的应用
要在当前工作表Sheet1的B2单元格中计算工作表Sheet2中的C2到C9单元格的算术平均值,则在当前工作表的B2单元格中输入的公式应为( )。
=AVERAGE(C2:C9)
=AVERAGE([Sheet2!]C2:C9)
=AVERAGE(Sheet2!C2:Sheet2C9)
=AVERAGE(Sheet2!C2:C9)
=AVERAGE(C2:C9)
=AVERAGE([Sheet2!]C2:C9)
=AVERAGE(Sheet2!C2:Sheet2C9)
=AVERAGE(Sheet2!C2:C9)
参考答案:
佳题速递: