在考生文件夹下打开文件EX03A.XLS(内容如下表)，要求如下：
1.将工作表Sheet1的A1:C1单元格合并为一个单元格，内容水平居中；计算“人数”列的“总计”项及“所占比例”列的内容(所占比例=人数/总计，百分比型，保留小数点后2位)；将工作表命名为“员工年龄情况表”。
参考答案：本小题操作步骤如下：
①打开工作簿文件EX03A.XLS。
②选中A1:C1单元格区域，单击工具栏中的“合并及居中”按钮。
③选中B7单元格，单击工具栏中的“自动求和”按钮“∑”并回车。
④选中C3单元格，输入“=”，单击B3单元格，按“/”键，单击单元格B7，在数据编辑区中将B7改写为$B$7并回车键。
⑤选中C3单元格，拖动填充句柄到单元格C6。
⑥选中C3:C6单元格区域，选择“格式”→“单元格”命令，在“单元格格式”对话框中选择“数字”选项卡，在“分类”列表框中选择“百分比”，“小数位数”设置为2。
⑦双击工作表标签Sheet1，输入“员工年龄情况表”并回车键。
Do you want to know something about children in Africa? What do they do for fun every day? Find out here: Education（教育） School is expensive for many African children. Lots of families can’t afford（支付不起）school uniforms or exercise books even though（尽管）they don't have to pay for school. For those lucky enough to go to school, they have a lot to learn. Some take two language classes: English or French, and their first language. There is also maths, science, history, social（社会的）studies and geography. Chores(繁琐的事) take up much of children’s time after school. They have to get water and firewood for the family every day. Also there’s cleaning, washing and helping with the meal. Daily（日常）fun It’s not all work and no play. Sports are very popular. Children can make goals（球门） with twigs（树枝）and their own footballs with string（绳子）. They play in the country（乡村）and streets of old towns. There’re many football teams for young people in Africa. Internet It's really expensive to get on the Internet. To get online （上网）for 20 hours costs over 600 yuan. Most people don’t have enough money for the fee（费用）. Egypt（埃及）and South Africa are the top two users of the Internet in Africa. All the people in the two countries can get on Internet. Some schools offer（提供）computer lessons but few students can enjoy computer fun at home.
| ||||||||
