0% found this document useful (0 votes)
148 views2 pages

DCA Final Exam Question Paper

The document outlines the final examination for a Diploma in Computer Application (DCA) at the Institute for Advanced Computer Technology. It includes various sections covering Computer Fundamentals, Ms-Windows, Ms-Word, Ms-Excel, Ms-PowerPoint, Ms-Access, and Internet & Network, with a total of 100 marks. Each section consists of questions, true or false statements, and fill-in-the-blank exercises related to the respective topics.

Uploaded by

Sujit Paul
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
148 views2 pages

DCA Final Exam Question Paper

The document outlines the final examination for a Diploma in Computer Application (DCA) at the Institute for Advanced Computer Technology. It includes various sections covering Computer Fundamentals, Ms-Windows, Ms-Word, Ms-Excel, Ms-PowerPoint, Ms-Access, and Internet & Network, with a total of 100 marks. Each section consists of questions, true or false statements, and fill-in-the-blank exercises related to the respective topics.

Uploaded by

Sujit Paul
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Institute for Advanced Computer Technology

Final Examination

Diploma in Computer Application (DCA)


Time: 1:30 Hours Full Marks : 100

Computer Fundamentals 20
1. Answer the following Question 5 X 3 = 15
1) What is the role of Binary Number System in Computer?
2) What is Storage Device?
3) Write Second Generation of Computer?
4) Explain Any Four Input Devices?
5) What is Gate? How Many types of Gate?
2. Write True or False the following Question 5X1=5
a. Compact Disk a primary Memory.
b. Scanner is an Input device.
c. In Machine Language, Instruction is written using ‘0’ & ‘1’.
d. IBM Introduce the Personal Computer.
e. Monitor is Output Device.
Ms-Windows 10
1. Fill in the blanks 5X1=5
1) Deleted files are moved to ………………..
2) To ……………… click any icon for copy.
3) Ctrl+A is short cut key ……………….. in Notepad.
4) Text toolbar is in …………….. menu.
5) Replace is in ……………… menu.
2. Write True or False the following Question 5X1=5
1) Notepad is the part of Control Panel.
2) Folder can created in any Application.
3) Attributes are in Word Pad.
4) Deleted files can restores from Recycle Bin.
5) Windows Explorer displays only files.
Ms-Word 20
1. Answer the following Question 5 X 3 = 15
1. What are the main features of Microsoft Word?
2. Write the steps for Mail Merge?
3. Writes the steps of Password Protection.
4. Writes the steps of Hyperlink.
5. Writes the steps of Cross-reference.
2. Write True or False the following Question 5X1=5
a. Inserting picture is not possible in Ms-Word.
b. A protected file can be modifying simply.
c. Macro can be used many times.
d. Auto Correct entry can’t be erased.
e. Short cut key for Double Underline is ctrl+u.
Ms-Excel 20
1. Answer the following Question 5 X 3 = 15
1. What are the main features of Ms-Excel?
Institute for Advanced Computer Technology
Final Examination
2. Writes the formula for all designation as following:
5000 and above Æ Manager
>3100 and < 4000 Æ Accountant
>2100 and < 3000Æ Clerk
>1100 and < 2000 Æ Peon
Below 1000 Æ Sweeper
(Assume Designation is given in B2)
3. Explain referencing with types $ example.
4. Explain Goal Seek.
5. Difference between Paste and Paste Special Command.
2. Fill in the Blanks 5X1=5
a) .Exe is the extension name of file in ……….Application.
b) There are …………… Columns and …………… Rows in a workbook.
c) In conditional formatting max ……………… condition can be set.
d) Changing the Sheet name is …………….. menu.
e) Paste link option is in ……………… menu option.
Ms-PowerPoint 10
Answer the following Question 5 X 2 = 10
a) What is Animation?
b) What is the Master Slide in Power-Point?
c) What is Rehearse Timing?
d) What is Slide Shorter?
e) What is Action Buttons?
Ms-Access 15
Answer the following Question 5 X 2 = 10
a) What is Database Management System?
b) How many data type in Ms-Access?
c) How many types of Page?
d) What is the use of Relationship in Ms-Access?
e) What is Design View in Form?

Internet & Network 5


Answer the following Question 5 X1 = 5
a) What is the role of Internet in Railway?
b) What is www?
c) What is Website?
d) What is the work of Network?
e) Writes the basic requirements of Network.

Common questions

Powered by AI

Action buttons in MS PowerPoint are tools used to trigger certain actions during a presentation, such as navigating to a different slide, launching an external application, or playing an animation. They enhance interactivity and help in guiding the flow of a presentation .

In MS Access, relationships are used to link tables based on common fields. They support data integrity by ensuring that the connections between tables follow the defined relationships, such as one-to-one, one-to-many, or many-to-many. These relationships ensure that data is consistent and reduce redundancy, which is crucial for maintaining accurate and reliable data within the database .

The 'goal seek' function in MS Excel is a powerful tool for data analysis that allows users to find the input value needed to achieve a specific goal in a formula. By adjusting one of the inputs, it iteratively calculates the output to match a desired target, aiding in decision-making and scenario analysis .

The internet plays a crucial role in enhancing railway operations by facilitating real-time communication and data exchange. It supports online booking systems, enabling passengers to make reservations easily. Furthermore, the internet aids in managing schedules, monitoring train status, and improving customer service through instant updates and feedback channels. This connectivity contributes to operational efficiency and customer satisfaction in the railway sector .

Microsoft Word is equipped with numerous features for document creation and editing. Key features include text formatting options, spell check, grammar correction, mail merge for personalized documents, and various templates to enhance productivity. These tools collectively facilitate professional document preparation .

The binary number system is fundamental to computer operations as it is the primary language understood by computers. Computers use binary digits, 0 and 1, to perform calculations and store data. This system is favored due to its simplicity in representing two states, which aligns well with digital electronics that operate on switches being either on or off .

Setting up a computer network requires several basic components: network interface cards (NICs) for connectivity, switches to connect devices within the network, routers to manage data traffic between networks, and appropriate cabling or wireless technology for data transmission. Additionally, a network requires software for configuration and management, alongside adequate security measures to protect data integrity and privacy .

Logic gates are fundamental building blocks of digital circuits; they perform basic logical functions such as AND, OR, NOT, NAND, NOR, XOR, and XNOR. These gates manipulate binary inputs to produce a single binary output representing logical operations. They are crucial in performing arithmetic operations, data processing, and memory storage in computers .

The second generation of computers differed from the first generation primarily due to the use of transistors instead of vacuum tubes. Transistors allowed computers to become more reliable, consume less power, and generate less heat compared to their predecessors. This transition enabled the development of smaller, more efficient machines, marking a significant technological advancement .

The mail merge feature in MS Word combines a template document with a data source to generate personalized documents, such as letters or labels. The steps include selecting the document type, choosing the recipients, inserting placeholders, and finally completing the merge to produce individual documents. This feature is significant as it streamlines mass correspondence, saving time and ensuring consistency .

You might also like