请在“答题”菜单下选择“电子表格”命令,然后按照题目要求再打开相应的命令,完成下面的

题型:问答题

问题:


请在“答题”菜单下选择“电子表格”命令,然后按照题目要求再打开相应的命令,完成下面的内容,具体要求如下:
注意:下面出现的所有文件都必须保存在考生文件夹下。


1.在下打开EXCEL.XLS文件:(1)将sheetl工作表的A1:F1单元格合并为一个单元格,内容水平居中;计算总积分列的内容,按总积分的递减次序计算“积分排名”列的内容(利用RANK函数)。
(2)选取A2:D10数据区域,建立“簇状柱形图”(系列产生在“列”),图表标题为“成绩统计图”,图例位置靠上;将图插入到表的A12:F26单元格区域内,将工作表命名为“成绩统计表”,保存EXCEL.XLS文件。


2.打开工作簿文件EXC.XLS,对工作表“人力资源情况表”内数据清单的内容进行自动筛选,条件为部门为开发部或工程部、学历为硕士或博士,工作表名不变,保存EXC.XLS文件。

考点:计算机等级考试MSOffice全国计算机等级考试一级MSOffice真题2009年3月
题型:问答题

Look at the girl in the picture. She is an English pop singer(流行歌手). Her name is Connie Talbot. She is only 11. But she could sing Over the Rainbow well on TV at six. Her grandmother likes her very much and often asks her to sing for her.Connie’s grandmother is not healthy. But for her, it is a relaxing thing to hear Connie sing. “She sings really well,” her grandmother says.

Connie is good at English. She does well at school. She likes French fries very much and often eats them at home. She doesn’t like ice cream or hamburgers. Connie is a star now. But her mother only wants her daughter to be healthy.

小题1:Who is Connie?

A.A teaacher.

B.A doctor.

C.A player.

D.A singer.小题2:Connie’s        often asks her to sing.

A.daughter

B.mother

C.grandmother

D.grandfather小题3:Connie likes to eat        at home.

A.French fries

B.hamburgers

C.ice cream

D.pizza小题4:Connie’s mother wants her to be       .

A.healthy

B.busy

C.famous

D.cool小题5:We can know that Connie        .

A.is from the USA

B.learns English well

C.likes ice cream

D.isn’t healthy now

题型:问答题
设p,q均为自然数,且
p
q
=1-
1
2
+
1
3
-
1
4
+
1
5
-…-
1
18
+
1
19
,求证:29|p.
题型:问答题

下列何项缺乏时,红细胞内游离原卟啉增高()

A.二价铁

B.叶酸

C.维生素B

D.氨基酸

E.血红蛋白

题型:问答题

案例摘要:患者,男性,21岁。1周前出现发热、呼吸急促,两肺湿性啰音,心尖区可闻及双期杂音,肝界扩大,两肢水肿,被诊断为亚急性感染性心内膜炎。

治疗亚急性感染性心内膜炎,首选的抗生素是()

A.庆大霉素

B.青霉素

C.红霉素

D.链霉素

E.阿米卡星

题型:问答题

被里格斯定义为研究“自然以及人类文化环境与公共政策运行之间的相互影响情形”的学说是()

A.行政生态学

B.社会系统学

C.新公共行政学

D.目标管理学

更多题库