【多选题】【消耗次数：1】
求C1至C5共5个单元格的平均值，可以应用公式___。
①
=SUM(C1:C5)/5
②
=AVERAGE(C1:C5)
③
=SUM(C1:C5)/COUNT(C1:C5)
④
=SUM(C1:C5)
参考答案：
复制
纠错
相关题目
【简答题】
统计整数n的各个位上出现数字1、2、3的次数，并通过外部（全局）变量c1、c2、c3返回主函数。
例如，当n=123114350时，结果应该为：c1=3 c2=1 c3=2。
#includeint c1,c2,c3;
void fun(long n)
{
c1 = c2 = c3 = 0;
while (n)
{
/************found************/
switch([填空1])
{
case 1: c1++; break;
/************found************/
case 2: c2++;[填空2]
case 3: c3++;
}
n /= 10;
}
}
main()
{
int n=123114350;
fun(n);
printf(\nn=%d c1=%d c2=%d c3=%d\n,n,c1,c2,c3); }
【单选题】
在Excel工作表中，表示一个以单元格C5、N5、C8、N8为四个顶点的单元格区域，正确的是____。
①
C5:C8:N5:N8
②
C5:N8
③
C5:C8
④
N8:N5
【单选题】
在Excel工作表中，已知A1=12,B1=67,在C1单元格中输入公式”=IF(B1A1),”A”,” B””,则C1最后显示的是( )
①
A
②
B
③
TRUE
④
79
随机题目
【单选题】
10.We should see ourselves as part of nature rather than in ______ with it.
①
argument
②
connection
③
conflict
④
crash
【单选题】
14.Anyone can borrow magazines from the club ______ he returns them in a week.
①
as long as
②
so that
③
unless
④
as far as
【单选题】
9. They have ______ each other for a long time.
①
corresponded on
②
corresponded with
③
communicated with
④
kept writing
【单选题】
6.The old lady fainted on the street and found herself in the first aid room when she came_________.
①
across
②
over
③
in
④
to
【单选题】
In Britain, the season of the year is probably _____ spring.
①
later
②
last
③
latter
④
late
【单选题】
All _____ is peace and progress.
①
what is needed
②
for our needs
③
the thing needed
④
that is needed
【单选题】
_____ that my head had cleared, my brain was also beginning to work much better.
①
For
②
Now
③
Since
④
Despite