NALANDA OPEN UNIVERSITY
Annual Examination 2016
Bachelor of Computer Application Part I
Paper IV (PC SOFTWARE SKILLS, CS 612)
Time: 3 hours Maximum Marks:
Answer any five questions. Answer all the questions.
1. Explain different components of MS-EXCEL with example.
2. What is a macro? Explain its utility in MS-Excel. Write steps for recording and running a macro.
3. Explain the best way of solving Decanting problems and provide a solution for the following
problem:-
You are provided 3 vessels. The capacities are 12, 9 and 5 liters. The 12-litre vessel is full of water.
How can you divide the water in the 12-litre vessel into two equal portions?
4. What are the advantages of using Internet? Briefly explain the working of Internet. Also explain
different methods of connecting to the Internet.
5. Explain different types of charts created in MS-Excel? Explain any six chart components.
6. Write the basic functionality of the following in MS-Excel components
Format Painter Chart Wizard Firewall
7. What is the significance of Domain Name System? List some domain names.
8. What is a decision tree? Draw and explain a decision tree by giving an example of your own choice.
9. Write the major difference between a Worksheet and a Workbook. Explain any three ways of
restricting access to a Workbook.
10. Write short notes on any three:
FTP
Pivot Table
WWW
Complexity problem