【单选题】【消耗次数：1】
在Excel操作中,假设A1,B1,C1,D1单元分别为2,3,7,3，则SUM(A1:C1)/D1的值为（ ）。
①
12
②
18
③
4
④
3
参考答案：
复制
纠错
相关题目
【单选题】
在Excel工作表中，已知A1=12,B1=67,在C1单元格中输入公式”=IF(B1A1),”A”,” B””,则C1最后显示的是( )
①
A
②
B
③
TRUE
④
79
【单选题】
在Excel中，已知C1单元格的值为6、D1单元格的值为2。在单元格中输入的公式，错误的是____。
①
=C1*D1
②
=C1/D1
③
=C1“OR”D1
④
=OR（C1，D1）
【简答题】
统计整数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); }
随机题目
【单选题】
You’ ll have to____ your wrongdoing one day.
①
answer for
②
answer to
③
ask for
④
allow for
【单选题】
Classification is a useful ____ to the organization of knowledge in any field.
①
means
②
approach
③
mode
④
manner
【单选题】
We will be losing money this year unless that new
economic plan of yours ____ miracle.
①
is working
②
works
③
will be working
④
worked
【单选题】
The population of the world ______ still _____ now.
①
will; grow
②
have; grown
③
is ; growing
④
is ; grown
【单选题】
It takes a lot of ____ to put on a school play such as
King Lear.
①
organization
②
arrangement
③
management
④
preparation
【单选题】
You are ____ to have had the help of such a man.
①
thoughtful
②
considerate
③
fortunate
④
moderate
【单选题】
You’ d rather have a cup of tea than have a cup of coffee,
_____?
①
wouldn’ t you
②
hadn’ t you
③
would you
④
had you