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.