打开素材文件test12.xls,按下列要求处理表格后以test122.xls为文件

题型:问答题

问题:

打开素材文件test12.xls,按下列要求处理表格后以test122.xls为文件名保存在考生文件夹中。

(1)使用Sheet2中的数据,创建样张所示的图表。

1)在Sheet2中筛选出“总成绩”大于250且小于290、学号以S起始女生记录。

2)在数据表Sheet3的A1:G16区域内插入数据点折线图。图表标题为“学生成绩”,X轴和Y轴分别显示“学科”和“成绩”;将绘图区背景色设置为天蓝色。

样张如图所示。

考点:计算机操作员初级操作员计算机操作员初级
题型:问答题

补全阅读(15分)

根据短文内容,从短文后的A—G的选项中选出能填入空白处的最佳选项。(有两项多余)

When I was 16 years old, a boy gave me an important present. 小题1:       

It was the early autumn of my first year at a junior high school, and my old school was far away. 小题2:          I was very lonely, and afraid to make friends with anyone.

Every time I heard the other students talking and laughing, I felt my heart broken, I couldn’t talk with anyone about my problems. And I didn’t want my parents to worry about me.

Then one day, my classmates talked happily with their friends, but I sat at my desk unhappily as usual. 小题3:            I didn’t know who he was. He passed me and then turned back. He looked at me, with a smile on his face.

Suddenly, I felt the touch of something bright and friendly. It made me feel happy, lively and warm.

小题4:         I started to talk with other students and made friends. Day by day, I became closer to everyone in my class. The boy with the lucky smile has become my best friend now!

小题5:        I believe that the world is what you think it is. If you think it lonely, you might always be alone. So smile at the world and it will smile back.

A.At that moment, a boy entered the classroom.

B.He’s living in Australia now and he loves it.

C.It doesn’t matter because all the dark days have gone.

D.It was a smile.E. That smile changed my life.

F. It’s impossible to make friends here.

G. As a result, no one knew who I was.

题型:问答题

下列有关数据库的描述,正确的是______。

A.数据库是一个DBF文件

B.数据库是一个关系

C.数据库是一个结构化的数据集合

D.数据库是一组文件

题型:问答题

由于温度的改变,物体会发生长度、面积或体积变化的现象,此现象称为热膨胀,请问理想气体每升高1℃体积变为原来的几倍?

题型:问答题

下面三幅图告诉我们

          

①科学技术是社会发展的强大推力②科学技术的发展为人类的文明进步做出了巨大贡献③科技是力量之源、发展之基④我国已成为科技强国

A.①②

B.①③

C.①④

D.③④

题型:问答题

查询设计器和视图设计器的主要不同表现在( )。

A.查询设计器有“更新条件”选项卡,没有“查询去向”选项卡

B.查询设计器没有“更新条件”选项卡,有“查询去向”选项卡

C.视图设计器没有“更新条件”选项卡,有“查询去向”选项卡

D.视图设计器有“更新条件”选项卡,没有“查询去向”选项卡

更多题库