在如图5-3所示的Excel中，在D3单元格中输入公式“=AVERAGE(A1:D2,6)”，则D3单元格中显示的值为 (54) 。
A．3.5
B．2.5
C．3
D．2.625
参考答案：C
解析：[要点解析] Excel函数AVERAGE的主要功能是，计算一组数字的算术平均值。如果单元格数值为0，将参于计算平均数。如果某个单元格是空的或包含文本，它将不用于计算平均数。若在D3单元格中输入公式“=AVERAGE(A1:D2,6)”，则D3单元格的值=(0+1+2+3+4+5+6)/7=21/7=3，如图5-12所示。其中，A1单元格是空，A2单元格包含文本，都不用于计算平均数；参与计算的数值6是表达式中的值，要参于计算平均数。
| 完形填空。 |
| A: Good morning! B: 1 A: 2 your name, please? B: 3 name is Amy. And you? A: I 4 Peter. Nice to meet you. B: 5 . A: What's this 6 English? B: It's 7 . A: And 8 this in the picture? B: 9 Kate. She's English. A: Thank you very much. B: 10 . |
| ( )1.A. Thanks ( )2.A. What ( )3.A. I ( )4.A. am ( )5.A. Nice to meet you, too ( )6.A. for ( )7.A. picture ( )8.A. What ( )9.A. It's ( )10.A. Ok | B. Thank you B. What's B. I'm B. is B. Thanks B. at B. a picture B. What's B. Its B. All right | C. Good morning C. Who C. My C. name C. Thank you C. in C. the picture C. Who C. It C. That's all right | D. I'm nice D. Who's D. My is D. name's D. You are very nice D. with D. an picture D. Who's D. He's D. Right |