问题 问答题

Excel操作题

品牌 种类 零售量(台) 零售单价(元/台)
三洋 吸尘器 6439 650
老板 吸尘器 2149 410
三菱 油烟机 11508 665
美的 吸尘器 11045 505
帅康 油烟机 19220 715
春花 吸尘器 3864 555
日立 吸尘器 1875 740
松下 吸尘器 1201 360
(1)删除第五行与第七行的数据,即种类为油烟机所在行;
(2)在第二行中的E2单元,输入“零售总额(元)”,其中第二行中带括号的单元,将括号连同括号中的内容一起放在单元格中的第二行;
(3)计算第E列中各种吸尘器的零售总额;
(4)将第二行开始的数值单元设置成千位分隔不保留小数位的格式,其他单元要求水平、垂直居中;
(5)在第一行中输入标题“吸尘器销售汇总”,标题采用跨列居中,四字,18磅黑体。

答案

参考答案:略。

选择题
完形填空
完形填空。
     A woman in her sixties lived alone in her little cottage with a pear tree at her door. She spent all her time
taking care of the tree. But the children nearby drove her   1   by making fun of her. They would climb her
tree and then run away with pears,   2    "Aunty Misery" at her.
     One evening, a passer by asked to   3   for the night. Seeing that he had an   4   face, she let him in and
gave him a nice   5  . The next morning the stranger, actually a sorcerer (巫师), thanked her by granting
(允准) her   6   that anyone who climbed up her tree   7   not be able to come back down until she   8   it.
     When the children came back to steal her   9  , she had them stuck on the tree. They had to beg her long 
 10   she gave the tree permission to let   11   go. Aunty Misery was free from the   12   at last.
     One day another man   13   her door. This one did not look trustworthy to her,  14   she asked who he
was. "I am Death, I've come to take you  15  me." said he.
     Thinking fast Aunty Misery said, "Fine, but I'd like to   16   some pears from my dear tree to remember
the 
 17  it brought to me in this life. But I am too   18   to climb high to get the best fruit. Will you be so   19   as
to do it for me?" With a deep sigh, Mr. Death climbed up the tree   20   and was immediately stuck to it. No
matter how much he warned or begged, Aunty Misery would not allow the tree to let Death go.
( )1.  A. hopeless         
( )2.  A. calling          
( )3.  A. stay             
( )4.  A. interesting      
( )5.  A. gift             
( )6.  A. suggestion       
( )7.  A. could           
( )8.  A. permitted       
( )9.  A. branch          
( )10.  A. after          
( )11.  A. it                          
( )12.  A. trick          
( )13.  A. stepped into    
( )14.  A. so             
( )15.  A. with           
( )16.  A. choose          
( )17.  A. honor           
( )18.  A. light          
( )19.  A. proud           
( )20.  A. disappointedly
B. painful          
B. shouting         
B. live            
B. honest          
B. kiss            
B. demand          
B. should          
B. promised        
B. food          
B. while         
B. them                      
B. question         
B. left for       
B. but              
B. off                
B. pick           
B. pleasure        
B. short           
B. kind            
B. cheerfully     
C. dull          
C. announcing      
C. hide           
C. anxious        
C. treat         
C. permission     
C. might           
C. answered       
C. tree         
C. since           
C. him                          
C. trouble          
C. stopped at   
C. although       
C. upon             
C. shake          
C. hope         
C. old           
C. fine          
C. unwillingly 
D. crazy                      
D. whispering                  
D. lie                       
D. angry                      
D. smile                      
D. wish                       
D. must                        
D. declared                    
D. fruit                      
D. before                     
D. her                      
D. difficulty                   
D. walked around               
D. because                   
D. for                       
D. hit                         
D. excitement                 
D. thin                       
D. smart                      
D. eagerly