问题 问答题

打开工作簿文件EX18.XLS(内容如下),将工作表sheet1的A1:D1单元格合并为一个单元格,内容居中;表格数据为宋体19磅、居中放置,计算“总计”列的内容,将丁作表命名为“2006年2月份工资表”。

2.选取“2006年2月工资表”的“姓名”列和“总计”列的内容建立“簇状柱形圆柱图”,X轴上的项为“人员”(系列产生在“列”),标题为“2006年2月份工资表”,插入到表的A12:E22单元格区域内,并保存到EX18.XLS。

答案

参考答案:

解析:第1小题 打开文件,在D3中键入公式“=SUM(B3:E3)”,表示将B3至E3的单元格数据求和。双击此单元格,向下拖动又下角的实心方块填充到其他需要产生结果的单元格。选中全表,使用[格式]|[单元格]|[字体]命令,设置字体的属性,在[对齐]选项卡中设置水平和垂直的对齐方式。选中第一行,使用[格式]|[单元格]|[对齐]命令,合并单元格,并输入“2006年2月份工资表”。第2小题 选中“姓名”列和“总计”列,单击工作栏上[图表向导]按钮,弹出[图表向导-4步骤之1-图表类型]对话框中进行[图表选择]。 单击下一步,在[图表向导-4步骤之2-图表源数据]对话框中选择[数据区域]。 单击下一步,在[图表向导-4步骤之3-图表选项]对话框中选择[图表标题]。 单击下一步,在[图表向导-4步骤之4-图表位置]对话框中选择[作为其中的对象插入]。

阅读理解


阅读理解
                                                            2011 Top Education News

"Tiger Mother" became well known both in the US
and China after the publication of the Battle Hymn
of the Tiger Mother by Amy Chua, a professor of
Yale University and a Chinese immigrant mother.
In the book, Chua describes how she educates her
two daughters in a strict "typical Chinese" way.
The South University of Science and Technology
of China (SUSTC), became "China's first independent
university"-the only university to recruit students through
its independent exam rather than the National College
Entrance Exam adopted by almost all public universities
in China.
Wuhan schoolboy Huang Yibo, 13, known as
the deputy chief of all Wuhan's young pioneers,
became an overnight sensation after blogging
about watching prime time news on China's  
Central Television since he was two years
old and reading People's Daily since the age
of seven because his father asked him to do so. 
The First Experimental Elementary School of
Weiyang district in Xi'an, Shaanxi province, hit
the headlines for requiring students with a poor
performance to wear a green scarf, distinguishing
them from the good performance of the red scarf,
a symbol  for  the Young Pioneer organization.
Dong Fan, a professor from Beijing Normal
University, the director of the university’s real
estate research center, refused to see any of his
students who do not possess 40 million yuan by
the time they are 40. Dong said people who had
received high-level education should be ashamed
if they do not live a wealthy life.  
The No 4 classroom building on the campus of
Tsinghua University, one of China's elite colleges,
took on the name of a popular clothing company,
the Hong Kong-based Jeanswest Clothing in May.
A golden-colored plate bearing the name of the
company was affixed on to the wall of the teaching
building.
1. How many pieces of the news above have something to do with family education?
A. 2          
B. 3          
C. 4        
D.5
2. Which of the following statements is True according to the news above?
A. "Tiger Mother" is famous for her book about how she educates her two daughters.
B.  Students caring about environmental protection will wear a green scarf.
C.  Tsinghua University became "China's first independent university".
D.  Huang Yibo began to read People's Daily at the age of two.
3. We can infer from the news about Dong Fan that _______.
A. he works hard                  
B. he spares no efforts to help his students
C.he tends to measure success by money    
D. he is a professor of Yale University
4. All the six pieces of news above deal with the subject of ______.
A. schools    
B. parents      
C. students    
D. education
选择题