B.A-B.A 3rd Year REPORT GENERATOR (Acharya Nagarjuna University (ANU), Guntur, Andhra Pradesh-2012)
Sunday, 25 August 2013 09:20anudouglas
Third Year
Paper V — REPORT GENERATOR
Time : Three hours Maximum : 100 marks
SECTION A — (3 × 20 = 60 marks)
Answer any THREE questions.
1. Explain about different parts of Excel Sheet with neat diagram.
2. Explain different available formatting option in Excel.
3. Explain different types of charts in Excel.
4. Explain the meaning and advantages of functions available in Excel.
5. Explain different views of a Excel work sheet.
6. What is a cell address? What are the different addressing methods available in Excel?
Explain each method with example.
SECTION B — (5 × 6 = 30 marks)
Answer any FIVE questions.
7. Explain sheet operations in Excel.
8. How to insert and delete columns in a work sheet?
9. How to create a macro in Excel?
10. Explain about filter command in Excel.
11. Explain about importing and exporting data in MS-Excel.
12. How to create hyperlink in Excel?
13. Explain working with data forms.
SECTION C — (5 × 2 = 10 marks)
Answer any FIVE questions.
14. Clip Art.
15. Sorting.
16. Spell cherk in MS-Excel.
17. Clearing parts of a worksheet.
18. Rotating 3-D charts in Excel.
19. Hide and unhide.
20. Saving a file in Excel.
| Earning: ₹ 5.15/- |
