问题 问答题

在考生文件夹下打开EXCEL.XLS文件,将sheet1工作表的A1:F1单元格合并为一个单元格,内容水平居中;用公式计算“总计”列的内容和“总计”列的合计,用公式计算“所占百分比”列的内容(所占百分比=总计/合计),单元格格式的数字分类为百分比,小数位数为2,将工作表命名为“植树情况统计表”,保存EXCEL.XLS文件。


(2)选取“植树情况统计表”的“树种”列和“所占百分比”列的内容(不含合计行),建立“三维饼图”(系列产生在“列”),标题为“植树情况统计图”,数据标志为显示百分比及类别名称,不显示图例,将图插入到表的A8:D18单元格区域内,保存EXC2EL.XLS文件。

答案

参考答案:(1)
步骤1:通过“答题”菜单打开EXCEL.XLS文件,选中要合并的单元格,单击[合并及居中]按钮合并单元格,并使内容居中。
步骤2:选中要插入函数的单元格,单击工具栏中的[插入函数]按钮,在弹出的“插入函数”对话框中选择相应的函数和参数,计算“总计”列、“总计”列的“合计”和“所占百分比”列内容。
步骤3:选中要设置单元格属性的单元格,单击[格式]|[单元格]命令,在弹出的“单元格格式”对话框中按要求设置单元格格式。
步骤4:双击现有名称,输入新名称,并保存文件。
(2)
步骤1:选中要建立图表的数据,单击[插入]|[图表]命令,在弹出的“图表向导”对话框中按照要求建立“三维饼图”,并设置图表标题、数据标志和图例。
步骤2:按住鼠标左键单击图表不放,拖动图形,将图插入到A8:D18区域。
步骤3:保存文件。

阅读理解

Doctor Seuss was born in 1904. By the middle 1950s, he had become one of the best-loved and most successful children's book writers in the world. His books are very popular with young readers. They enjoy the invented words and the pictures of unusual funny animals and plants.

In 1954, life magazine published a report about school children who could not read well. The report said many children's books were not interesting. Doctor Seuss strongly hoped to help children and decided to write books that were interesting and easy to read. He used words with the same ending sound, like fish and wish. He did not receive training in art. Yet, he drew the pictures for most of his books.

In 1957, Dr. Seuss wrote The Cat in the Hat. He used less than 230 words to write the book and even a six-year-old should be able to read it. It was a fun story and easy to read. Children loved it. Their parents loved it, too. Today it is still one of the stories they like best. The success of The Cat in the Hat made him want to write more books for children. In 1960, he wrote a book using less than fifty words. The book is called Green Eggs and Ham.

In 1984, Doctor Seuss won a Pulitzer Prize. He was honored for the education and enjoyment his books provided American children and their parents.

He died at the age of 87, but his influence remains. Millions of his books have been sold worldwide. People say his books helped change the way American children learned to read. Yet, his books are loved by people of all ages. Doctor Seuss once said, "I do not write for children. I write for people.

小题1:Doctor Seuss learned from the magazine that _______.

A.some school children could not read well

B.many children's books were interesting

C.children wanted to learn to write

D.a writer for children was wanted小题2: People like his books because the books ______.

A.are cheap and easy to get

B.were written in different languages

C.are easy and interesting to read

D.were written with invented words小题3:He wrote the book The Cat in the Hat at the age of _____.

A.50

B.53

C.56

D.87小题4:Which of the following is TRUE according to the passage?

A.Doctor Seuss wrote Green Eggs and Ham with over 230 words.

B.Doctor Seuss wrote books only for children in the United States.

C.The Cat in the Hat was written only for six-year-old children.

D.His books provided education and enjoyment for Americans.小题5: From the text we know that Doctor Seuss __________.

A.won a Pulitzer Prize soon after his death

B.sold millions of his books himself worldwide

C.changed American children's way of reading

D.wrote the largest number of books in the world

填空题