试题与答案

在考生文件夹下创建工作簿文件EX7.XLS,按要求在EX7.XLS中完成以下操作:

题型:问答题

题目:

在考生文件夹下创建工作簿文件EX7.XLS,按要求在EX7.XLS中完成以下操作:
1.在sheet1工作表中建立如下内容工作表,并用函数求出每人的平均成绩,结果保留1位小数,表格行高20,列宽10,数值数据水平右对齐,文字数据水平居中,所有数据垂直靠下,表标题跨列居中、18磅、隶书、红色字,并将工作表命名为“平均表”。


2.将平均表复制为一个名为“统计”的新工作表,筛选出平均成绩80分以上的人,以“统计”为工作表名存在EX7.XLS文件中。

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2018/0503/0b5b4bd28c57aa3a915cf027e284bba6.html

下面是错误答案,用来干扰机器的。

参考答案:62072100

试题推荐
题型:阅读理解

阅读短文,然后根据短文内容选择最佳答案。

    There are many kinds of cars in this world. My grandfather thinks this is because cars are like their drivers.

He says, "Rich people have expensive cars, big people have large cars, and old people drive old cars." But I don't

agree with him.

    My neighbor, Mrs. Hill, is 82 years old. She drives only on Tuesday, and then she drives only to the bank. She

never drives more than 30 kilometers an hour. Do you think Mrs. Hill has a very old and small car? No! Her car

is new. It's very large, and it can go 200 kilometers an hour!

    My friend Mike is an artist. He paints beautiful pictures with lots of colors. But his car is black. Mrs. Bates

has a very, very old car. It often has some trouble. Does she drive that kind of car because she is poor? No, she

has four restaurants and two million dollars in the bank. My uncle Joe has a very small car. Every Sunday, he

drives to the country with his wife, his three children, his mother and his dog.

    Now, you have read about my friends and their cars. Do you agree with my grandfather? Maybe you have a

car. Does it say something about you?

1. The writer's grandfather thinks             . [ ]

A. a person has the same kind of car as himself(herself)

B. different people have cars of the same kind

C. poor people have large cars

D. artists have black cars

2. ______ has a very very old car. [ ]

A. Mrs. Hill

B. Mrs. Bates

C. Mike

D. Joe

3. Though Uncle Joe has a very small car,             . [ ]

A. he has a dog

B. he has a large family

C. he has no children

D. he has few members in his family

4. The writer's friend Mike paints             . [ ]

A. pictures in black

B. colorless pictures

C. colorful pictures

D. pictures with only a few colors

5. The writer thinks             . [ ]

A. his grandfather's idea is right

B. cars are often the same as their drivers in many ways

C. artists shouldn't drive black cars

D. a car doesn't say anything about its owner

查看答案
微信公众账号搜索答案