试题与答案

用Excel按下列要求建立数据表格和图表,具体要求如下: (1)在指定的文件夹下新

题型:问答题

题目:

用Excel按下列要求建立数据表格和图表,具体要求如下:
(1)在指定的文件夹下新建EX06.XLS工作簿文件,将下列某市学生的大学升学和分配情况数据建成一个数据表(存放在A1:D6的区域内),并求出“考取/分配回市比率”(保留小数点后面两位),其计算公式是:考取/分配回市比率:分配回市人数/考取人数,将数据表保存在sheet1工作表中。

时间 考取人数 分配回市人数 考取/分配回市比率
2003 456 195
2004 423 211
2005 550 244
2006 536 260
2007 608 330
  (2)选择“时间”和“考取/分配回市比率”两列数据,创建“折线散点图”图表,图表标题为“回市散点图”,设置分类(X)轴为“时间”,数值(Y)轴为“考取/分配回市比率”,嵌入在工作表的A6:E19的区域中。将sheet1更名为“回市比率表”。

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2017/0708/bb5ebfe18035bce236fcddd3717ecbf1.html

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

参考答案:A, B, C

试题推荐
题型:单项选择题

李平(女)与王坚(男)二人于1993年在A市甲区某街道办事处登记结婚,婚后二人一直居住在B市乙区。1997年李平与王坚固在C市从事假烟生产被公安机关查获,C市丙区人民法院子同年12月以生产假冒产品罪判处李平与王坚有期徒刑5年。判决生效后李平与王坚被关押在位于C市丁区的监狱。2000年5月,李平拟向法院起诉离婚,请问下列哪个法院对本案有管辖权

A.A市甲区法院

B.B市乙区法院

C.C市丙区法院

D.C市丁区法院

查看答案
题型:阅读理解

阅读理解。

     Maurice Sendak's children's book, Where the Wild Things Are, published in 1963, has become

very successful throughout the years and was made into a movie earlier this year.

     The book's main character is a boy named Max who gets into trouble with his mother and is sent

to bed without any supper. Before long, Max's room magically becomes a forest, and he sails away

to a land where monsters(怪物,怪兽) live. Max isn't scared, though, and becomes king of the wild

things, but after a while, he begins feeling homesick. Max sails back home and his supper is still hot

when he arrives in his bedroom.

     Many teachers and professors like this story and use it to help children develop creativity and

imagination. Melina Davis, an education professor, said she likes how the book contains a couple

of pages that have only pictures on them. "This allows children to shape the story themselves," she

said.

     The book contains a few of larger words that some parents worry may confuse children, but

experts say those words help improve children's reading skills and challenge them.

     Davis said the book is well written which helps kids get involved in the story. "The book talks

about what all children go through, like 'I was naughty but my mommy still loves me'," Davis said.

The book also encourages children to face their fears. "I think it's really good to show that Max

makes friends with the monsters," Davis said. "Kids can find out monsters aren't always the thing

under the bed that's going to scare them. I think this is good because it shows that the children can

go to scary places but still have a positive experience."

     Since the book has been successful throughout the years, a movie was recently made and many

people are excited to see it. Davis said she thinks the movie will be wonderful but it might be a little

scary for younger children. "You don't want bad dreams over a book that's extremely wonderful,"

Davis said.

1. Teachers and professors like the book because it helps children ______.

A. understand pictures                      

B. improve reading skills

C. face their fear bravely                  

D. become more imaginative

2. Why does the book contain some larger words?

A. To make the story more formal.    

B. To help challenge the children's reading skills.

C. To encourage the children to learn more new words.          

D. To help children better understand the story.

3. Which of the following is TRUE according to the passage?

A. The character Max is brave enough in the story.        

B. Max was sent to the forest as punishment.

C. People of all ages are in favor of the book.            

D. The movie based on the book proves to be a great success.

4. What does Davis think of the movie?

A. She thinks children of all ages will love it.  

B. She encourages children to see it to fight against their fear.

C. She worries that it might be too frightening for some children.

D. She believes it will be a better choice for children than the book.

5. What's the author's purpose in writing the passage?

A. To advise parents to help children to improve their reading skills.        

B. To comment on a famous children's book.

C. To encourage children to face their fear and become more imaginative.        

D. To introduce a movie based on a children's book.

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