Docstoc

EX

Document Sample
EX Powered By Docstoc
					                           MS-EXCEL EXAM
                                        
                                                                        Marks : 25
                                                                        Time : 1 hr
  I.       Fill up the blanks:
           5

       1. Each formula in Excel starts with _____________.
       2.The bar which shows the information about current cell is _____.
       3.Cell address is a combination of ________________.
       4.A worksheet contains ___________ columns.
       5.Goal seek is present in ____________ menu..


II.                     Match the following:
                    5
       1.Chart                                    a. Positioning the character.
       2.Data Base                                b. Condition.
       3.Alignment                                c. Logical results.
       4.If function                              d. Collection of records
       5.Criteria                                 e. Graphs.


III.                    Write the answers:
                    10
       1. What is a pivot table ?
       2. What are the main features of Excel ?
       3. Name any five types of charts you can create in Excel .
       4. What are filters ?
       5. What is function wizard ? Why is it useful ?


IV.                 Write true (or) false:
                    5
       1. A cell can contain maximum character up to 255.
       2. A new field cannot be added to a pivot table.
       3. Custom filter option is used to design your own filter conditions .
       4. We can't change a chart from one type to another.
5.We can't copy a formula.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:8
posted:12/23/2010
language:English
pages:3