问题 问答题

(1)打开工作簿文件EX13.XLS(内容如下),将A1:D1单元格合并为一个单元格,内容居中,计算“总计”行的内容,将工作表命名为“专卖店销售情况表”。

ABCD
1专买店销售额情况表
2名称1月份2月份3月份
3北京专卖店62.373.654.3
4上海专卖店36.856.358.4
5深圳专卖店40.360.449.3
6总计
  (2)选取“专卖店销售情况表”的A2:D5单元格的内容建立“数据点折线图”,X轴上的项为月份名称(系列产生在“行”),标题为“专卖店销售情况图”,插入到表的A8:D20单元格区域内。

答案

参考答案:第(1)小题考查4个方面的内容:打开(保存)文件、合并居中单元格、公式计算、工作表命名。合并居中单元格需要选中单元格,单击“合并及居中”按钮即可;公式计算中,注意“复制公式”的功能使用;双击“Sheet1”标签,可以重新进行命名。第 (2)小题考查新建和设置图表功能。这里注意选择不相邻的单元格时,可以按住Ctrl键,然后一一选择。同时注意题目要求的图表类型,不要选错。在插入到表格的操作中,注意不要超出题目指定的区域。

完形填空
完型填空
     A thirsty bee went to a river to drink. As it was drinking, the bee was   1   away by the running water.
     A kind bird saw that the bee was in   2   . It picked   3   off a tree and threw   4   into the water in
front of the bee. The bee climbed  5   the leaf, and it was brought   6   to the land. The bee thanked the
bird a lot and then   7   away.
     Not    8   that, the bird was sitting   9   the branch(树枝) of a tree. It did not know that a man was
shooting(射击) at it. But the bee saw   10  the man was doing. So it flew into the man’s  11   and stung
(刺蜇) him. The   12   in the man’s eye was so great that he was not able to  13  the bird, and the bird
flew away.
        14  ways, the bee,   15  life had been saved by the bird, was able to save the life of the bird.
( )1. A. flying    
( )2. A. trouble  
( )3. A. a leaf    
( )4. A. them      
( )5. A. onto      
( )6. A. safety    
( )7. A. climbed  
( )8. A. long before
( )9. A. in        
( )10. A. that    
( )11. A. eye      
( )12. A. pain    
( )13. A. shoot    
( )14. A. In the  
( )15. A. her      
B. brought  
B. a trouble
B. leaves    
B. one      
B. on        
B. safe      
B. ran      
B. before long     
B. on        
B. what      
B. nose      
B. bee      
B. shoot at  
B. On the    
B. the      
C. flowing  
C. danger  
C. leaf    
C. it      
C. to      
C. saved    
C. flew    
C. after long          
C. at      
C. which    
C. mouth    
C. bird    
C. shoot to
C. In a    
C. whose    
D. carried    
D. dangerous  
D. the leaf  
D. this      
D. at        
D. safely    
D. got        
D. long after        
D. by        
D. when      
D. ear        
D. earache    
D. shoot on  
D. In this    
D. its        
多项选择题