# PGDCA First Semester Exam 11/03/2020

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By PHULBANIOCA
P
PHULBANIOCA
Community Contributor
Quizzes Created: 3 | Total Attempts: 585
Questions: 50 | Attempts: 228

Settings

• 1.

### A floppy disk contains

• A.

Circular track only

• B.

Sectors Only

• C.

Both Circular Track and Sector

• D.

None of the above

C. Both Circular Track and Sector
Explanation
A floppy disk contains both circular tracks and sectors. The circular tracks are concentric circles on the surface of the disk that store data, while the sectors are pie-shaped sections within each track that divide the data into smaller units. The combination of circular tracks and sectors allows for efficient storage and retrieval of data on the floppy disk.

Rate this question:

• 2.

### During data processing, the actual execution of the instruction takes place in the:

• A.

Output Unit

• B.

Control Unit

• C.

Hard Disk

• D.

Arithmetic Logic Unit

D. Arithmetic Logic Unit
Explanation
During data processing, the actual execution of the instruction takes place in the Arithmetic Logic Unit (ALU). The ALU is responsible for performing arithmetic and logical operations on the data, such as addition, subtraction, comparison, and logical AND/OR operations. It receives data from the memory, performs the necessary operations, and then sends the result back to the memory or to the output unit for further processing. The ALU is a critical component of the central processing unit (CPU) and plays a crucial role in carrying out the instructions of a program.

Rate this question:

• 3.

### ASCII stands for

• A.

American Standard Code for Information Interchange

• B.

Alphabetic Series Code for Information Interchange

• C.

American Statistical Code for Information Interchange

• D.

Alphabetic Standard Code for Information Interchange

A. American Standard Code for Information Interchange
Explanation
ASCII stands for American Standard Code for Information Interchange. It is a character encoding standard that represents text in computers and other devices. ASCII uses a unique numerical value to represent each character, including letters, numbers, punctuation marks, and control characters. This standard allows different computer systems to communicate and exchange information effectively.

Rate this question:

• 4.

### Dot matrix printer resolution is specified in terms of

• A.

CPI

• B.

DPI

• C.

LPI

• D.

ASI

A. CPI
Explanation
Dot matrix printer resolution is specified in terms of CPI, which stands for Characters Per Inch. This measurement indicates the number of characters that can be printed in a one-inch space. The higher the CPI, the more characters can be printed in a given area, resulting in a higher resolution printout. DPI (Dots Per Inch) is a measurement used for inkjet and laser printers, while LPI (Lines Per Inch) is used for halftone printing. ASI is not a commonly used term in printer resolution specifications.

Rate this question:

• 5.

### Which is an open-source operating system?

• A.

Linux

• B.

Unix

• C.

Windows

• D.

All of the above

A. Linux
Explanation
Linux is an open-source operating system because its source code is freely available to the public, allowing anyone to view, modify, and distribute the code. This openness promotes collaboration and innovation, as developers can contribute to improving the system. Unix and Windows, on the other hand, are not open-source operating systems. Unix is a proprietary operating system, and Windows is a commercial operating system developed by Microsoft.

Rate this question:

• 6.

### Office 2010 Package does not includes:

• A.

Word 2010

• B.

Excel 2010

• C.

Access 2010

• D.

Coreldraw

D. Coreldraw
Explanation
The Office 2010 Package includes Word 2010, Excel 2010, and Access 2010. However, Coreldraw is not included in the Office 2010 Package.

Rate this question:

• 7.

### You can use the Delete key to remove characters to the left of the insertion point.

• A.

True

• B.

False

B. False
Explanation
The explanation for the given answer is that the statement is incorrect. The Delete key is used to remove characters to the right of the insertion point, not to the left.

Rate this question:

• 8.

### While typing in a line, you will:

• A.

Press Enter key at the end of each line

• B.

Press Enter only at the end of a paragraph

• C.

Both a and b can be applied

• D.

None of the above

D. None of the above
Explanation
The given question presents different options for how to type in a line. However, none of the options mentioned (pressing Enter at the end of each line or only at the end of a paragraph) are correct. The correct answer would be to press Enter only at the end of each line, not at the end of a paragraph.

Rate this question:

• 9.

### Shift+del keys pressed together, for

• A.

Cut

• B.

Copy

• C.

Move the selected text

• D.

None of the above

C. Move the selected text
Explanation
Pressing the Shift+Del keys together is not a recognized keyboard shortcut for Cut or Copy operations. However, it is a commonly used shortcut for permanently deleting or moving a selected text or file to the Recycle Bin or Trash. Therefore, the correct answer is "Move the selected text".

Rate this question:

• 10.

### When you move the mouse pointer towards the left side of the window, it changes to a right pointing arrow, this area is called :

• A.

Selection bar

• B.

Selection pointer

• C.

Selection Beam

• D.

None of the above

A. Selection bar
Explanation
The selection bar is the area in a window where you can select or highlight text or objects. It is typically located at the top or left side of the window. When you move the mouse pointer towards the left side of the window, it changes to a right pointing arrow, indicating that you can click and drag to select or highlight content in that area. Therefore, the correct answer is "Selection bar."

Rate this question:

• 11.

### The ability to combine name and addresses with a standard document is called _________

• A.

Document Formatting

• B.

Database Formatting

• C.

Mail Merge

• D.

Form Letter

C. Mail Merge
Explanation
Mail Merge is the correct answer because it refers to the process of combining a standardized document, such as a letter or an email, with a list of names and addresses from a database. This allows for personalized and customized communication to be sent to multiple recipients without having to manually input each individual's information. Mail Merge is a commonly used feature in word processing software, making it easier and more efficient to create mass communications.

Rate this question:

• 12.

### The Key ctrl+F12 opens a

• A.

Save As Dialog box

• B.

Open Dialog Box

• C.

Save Dialog Box

• D.

None of the above

B. Open Dialog Box
Explanation
The key combination ctrl+F12 is used to open the Open Dialog Box in many software applications. This dialog box allows users to browse and select a file from their computer or network to open within the application. It is a commonly used shortcut for quickly accessing the Open Dialog Box without having to navigate through menus or toolbar options.

Rate this question:

• 13.

### Which of the following is used yo open a new file

• A.

Ctrl+N

• B.

Ctrl+S

• C.

Ctrl+V

• D.

Alt+N

A. Ctrl+N
Explanation
Ctrl+N is used to open a new file. This keyboard shortcut is commonly used in various software applications, including text editors, word processors, and graphic design programs. By pressing Ctrl+N, users can quickly create a new document or file without having to go through the menu options. This shortcut is widely recognized and implemented across different operating systems, making it a convenient and efficient way to start a new file.

Rate this question:

• 14.

### When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.

• A.

Pointer

• B.

Selector

• C.

Selection Pointer

• D.

Cursor

C. Selection Pointer
Explanation
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps you visually identify the area you are selecting on the spreadsheet. It allows you to accurately choose the cells you want to work with and perform actions such as formatting, copying, or deleting.

Rate this question:

• 15.

### _______, ________ and _______ are what you see when you open Excel

• A.

Column, Row, Chart

• B.

Column, Row, Formula

• C.

Column, Row, Cell

• D.

All of the above

C. Column, Row, Cell
Explanation
When you open Excel, you will see columns, rows, and cells. Columns are vertical sections labeled with letters, rows are horizontal sections labeled with numbers, and cells are the intersecting points of columns and rows where you can enter data or formulas. Therefore, the correct answer is Column, Row, Cell.

Rate this question:

• 16.

### Access sorts the data in ascending order only

• A.

True

• B.

False

B. False
Explanation
Access is a database management system that allows sorting data in both ascending and descending order. Therefore, the given statement that Access sorts data in ascending order only is incorrect.

Rate this question:

• 17.

### You can enter two basic kinds of data into worksheet cells:

• A.

Numbers and text

• B.

Numbers and Figures

• C.

Text and Chart

• D.

None of the above

A. Numbers and text
Explanation
In a worksheet, you can enter two basic kinds of data: numbers and text. Numbers are used for calculations and can be used in formulas, while text is used for labels or descriptions. This allows for a combination of numerical data and explanatory text in the worksheet, providing a comprehensive representation of information.

Rate this question:

• 18.

### To print an image, which key is used

• A.

Alt+P

• B.

Alt+tab

• C.

Ctrl+Tab

• D.

Ctrl+P

D. Ctrl+P
Explanation
Ctrl+P is the correct answer because Ctrl+P is a common keyboard shortcut used to open the print dialog box in most applications. This shortcut allows users to quickly access the print settings and options for printing a document or image. By pressing Ctrl+P, users can easily select a printer, specify the number of copies, choose the desired page range, and adjust other print settings before sending the image to the printer.

Rate this question:

• 19.

### To start PowerPoint, click the Start button on the Windows taskbar, point to Programs, point to Microsoft Office and then select ____.

• A.

Accessories

• B.

Microsoft office tools

• C.

Microsoft Power point

• D.

None of the above

C. Microsoft Power point
Explanation
To start PowerPoint, you need to click the Start button on the Windows taskbar. Then, you should point to Programs and then to Microsoft Office. Finally, select Microsoft Power point from the options provided. This is the correct answer because it accurately describes the steps required to open PowerPoint on a Windows computer.

Rate this question:

• 20.

### A separate window within the application that provides a list of commonly used commands is called a ____.

• A.

Dialog box

• B.

Command Window

• C.

• D.

None of the above

A. Dialog box
Explanation
A separate window within the application that provides a list of commonly used commands is called a dialog box. A dialog box is a graphical control element that allows users to interact with the software by presenting options and receiving input. It typically contains buttons, checkboxes, dropdown menus, and text fields that enable users to make selections or provide information. This feature enhances user experience by providing a convenient and accessible way to access frequently used commands without navigating through menus or memorizing keyboard shortcuts.

Rate this question:

• 21.

### MIS stands for

• A.

Maintenance Information System

• B.

Model Information System

• C.

Management Information System

• D.

Media Information Source

C. Management Information System
Explanation
MIS stands for Management Information System. This system refers to the use of technology and data to provide managers with the information they need to make informed decisions and manage their organizations effectively. It helps in collecting, processing, storing, and retrieving data to generate reports, analyze trends, and support decision-making processes. By providing timely and accurate information, MIS enables managers to monitor performance, identify problems, and take necessary actions to achieve organizational goals.

Rate this question:

• 22.

### You will use ____ to making a presentation.

• A.

MS- Powerpoint

• B.

• C.

Both of the above

• D.

None of the above

C. Both of the above
Explanation
Both MS-Powerpoint and Google Presentation can be used to make a presentation. MS-Powerpoint is a software developed by Microsoft that allows users to create slideshows with various multimedia elements. Google Presentation is a web-based application provided by Google that also allows users to create and share presentations. Therefore, the correct answer is "Both of the above" as both options are valid choices for making a presentation.

Rate this question:

• 23.

### To access the PowerPoint Help system use ____.

• A.

F1

• B.

Help Button

• C.

Both a and b

• D.

None of the above

C. Both a and b
Explanation
Both options A and B are correct because you can access the PowerPoint Help system by pressing the F1 key on your keyboard or by clicking on the Help button within the PowerPoint software.

Rate this question:

• 24.

### To open go to dialog box in excel using a keyboard, Press

• A.

F1

• B.

F2

• C.

F5

• D.

F12

C. F5
Explanation
To open the Go To dialog box in Excel using a keyboard, you need to press the F5 key. The F5 key is a shortcut key that allows you to quickly access the Go To dialog box, which is used to navigate to a specific cell or range in the worksheet. By pressing F5, you can easily enter the cell reference or range address and jump to that location in the spreadsheet.

Rate this question:

• 25.

### Which object is used to create a query?

• A.

Tables and query

• B.

Form Wizard

• C.

Tables

• D.

Query Wizard

D. Query Wizard
Explanation
The Query Wizard is used to create a query. It is a tool that guides users through the process of creating a query by providing a step-by-step interface. The Query Wizard helps users select the tables, fields, and criteria they want to include in the query, and it generates the necessary SQL code behind the scenes. This allows users to easily create complex queries without having to write the SQL code manually.

Rate this question:

• 26.

### What determines a table’s sort order?

• A.

Auto Number Field

• B.

Index Number

• C.

Primary Number

• D.

Field Order

B. Index Number
• 27.

### What is the intersection of a row and a column?

• A.

Sheet

• B.

Cell

• C.

Cursor

• D.

Table

B. Cell
Explanation
The intersection of a row and a column refers to a specific cell in a table or spreadsheet. A cell is the smallest unit in a table and is formed by the intersection of a row and a column. It is where data can be entered, edited, and stored. Therefore, the correct answer is "Cell."

Rate this question:

• 28.

### Full Form of SQL

• A.

Simple Query Language

• B.

Structure Query Language

• C.

System Query Language

• D.

Solution Query Language

B. Structure Query Language
Explanation
The correct answer is "Structure Query Language" because SQL is a programming language that is used for managing and manipulating relational databases. It is specifically designed to handle structured data and perform various operations such as querying, inserting, updating, and deleting data from a database. Therefore, "Structure Query Language" accurately describes the purpose and functionality of SQL.

Rate this question:

• 29.

### Choose the 'odd one out' of the following

• A.

COBOL

• B.

PASCAL

• C.

FORTRAN

• D.

Assembler

D. Assembler
Explanation
The odd one out in this list is "Assembler" because it is the only programming language that is not considered a high-level language. COBOL, PASCAL, and FORTRAN are all high-level languages that are designed to be easily readable and writable by humans, while Assembler is a low-level language that is more closely tied to the hardware and requires a deeper understanding of the computer's architecture.

Rate this question:

• 30.

### Which one of the following is an input device?

• A.

Microphone

• B.

Scanner

• C.

Mouse

• D.

All of the above

D. All of the above
Explanation
All of the options listed - microphone, scanner, and mouse - are input devices. An input device is any hardware component that allows users to enter data or commands into a computer. A microphone is used to input audio, a scanner is used to input printed documents or images, and a mouse is used to input movement and commands. Therefore, all of these options are valid examples of input devices.

Rate this question:

• 31.

### The internet is owned by:

• A.

IAB

• B.

Inter NIC

• C.

IETF

• D.

All of the above

B. Inter NIC
Explanation
Inter NIC (Internet Network Information Center) is responsible for the management and allocation of internet resources, such as IP addresses and domain names. While IAB (Internet Architecture Board) and IETF (Internet Engineering Task Force) are important organizations that contribute to the development and standardization of internet protocols, they do not own the internet. Inter NIC, on the other hand, plays a crucial role in the administration of the internet, making it the correct answer.

Rate this question:

• 32.

### An Operating System is:

• A.

A collection of hardware components

• B.

A collection of input output devices

• C.

A collection of software routines

• D.

None of these

C. A collection of software routines
Explanation
An operating system is a collection of software routines that manage and coordinate the hardware components and input/output devices of a computer system. It provides a platform for other software applications to run and facilitates communication between the hardware and software. The operating system controls the execution of programs, manages memory and storage, handles input and output operations, and ensures the overall functioning and security of the system. Therefore, it can be described as a collection of software routines that enable the computer system to operate efficiently.

Rate this question:

• 33.

### Payroll System is a typical example of

• A.

Batch Processng

• B.

Real time Processing

• C.

Online Processing

• D.

None of the above

A. Batch Processng
Explanation
A payroll system is a typical example of batch processing because it involves processing a large volume of data at once. In a payroll system, employee data such as hours worked, deductions, and taxes are collected over a specific period, typically a pay period. At the end of the pay period, all the data is processed together in a batch, and paychecks are generated for all employees simultaneously. This approach is efficient for handling large amounts of data and allows for the automation of repetitive tasks, making it suitable for payroll processing.

Rate this question:

• 34.

### The errors that can be pointed out by the compiler are:

• A.

Syntax Error

• B.

Logical Error

• C.

Run time Error

• D.

Semantic Error

A. Syntax Error
Explanation
Syntax errors are errors that occur when the code violates the rules of the programming language. These errors are detected by the compiler during the compilation process. They typically occur due to mistakes in the syntax of the code, such as missing or misplaced punctuation, incorrect use of keywords or operators, or incorrect indentation. When a syntax error is encountered, the compiler is unable to understand and translate the code into machine-readable instructions, resulting in a compilation error. Therefore, the given answer is correct as it correctly identifies one of the types of errors that can be pointed out by the compiler.

Rate this question:

• 35.

### DOS is a which type of Operating System?

• A.

Open Source

• B.

GUI

• C.

CUI

• D.

None of the above

C. CUI
Explanation
The correct answer is CUI, which stands for Character User Interface. CUI is a type of operating system that uses text-based commands or prompts to interact with the user. Unlike GUI (Graphical User Interface), which utilizes icons, menus, and windows, CUI relies on a command-line interface where users type commands to execute tasks. DOS (Disk Operating System) is a notable example of a CUI operating system.

Rate this question:

• 36.

### Process of turning on the Computer is:

• A.

• B.

Editing

• C.

Booting

• D.

None of the above

C. Booting
Explanation
The correct answer is "Booting" because it refers to the process of starting up a computer system. When a computer is turned on, it goes through a series of steps to initialize the hardware, load the operating system, and prepare the computer for use. This process is commonly known as booting. Loading and editing are not accurate terms to describe the initial startup process of a computer, so they are not the correct answers. "None of the above" is also incorrect because booting is the correct term for this process.

Rate this question:

• 37.

### Which one of the following is a system tools in windows?

• A.

• B.

Disk Fragmenter

• C.

Disk Defragmenter

• D.

MS-Word

C. Disk Defragmenter
Explanation
Disk Defragmenter is a system tool in Windows that helps to optimize the performance of a computer's hard drive. It rearranges fragmented data on the hard drive, making it easier and faster for the computer to access and retrieve files. This tool can improve overall system performance and reduce the time it takes to open files and programs. Notepad and MS-Word are text editing applications, while Disk Fragmenter is not a valid term.

Rate this question:

• 38.

### To delete the selected sentence, press

• A.

Delete

• B.

Backspace

• C.

Both of the above

• D.

None of the above

C. Both of the above
Explanation
The correct answer is "Both of the above" because the question asks which keys can be used to delete the selected sentence. Both the Delete key and the Backspace key can be used to delete the selected sentence, so the correct answer is both of them.

Rate this question:

• 39.

### To repeat the last editing press

• A.

F4

• B.

F1

• C.

F2

• D.

Ctrl+Z

A. F4
Explanation
Pressing F4 on a computer keyboard is a common shortcut used to repeat the last action or command performed. In the context of the given question, the phrase "To repeat the last editing" suggests that the question is referring to a text editing or formatting action. Therefore, pressing F4 would be the correct answer to repeat the last editing action.

Rate this question:

• 40.

• A.

Underline

• B.

Italian

• C.

Italic

• D.

Bole

C. Italic
• 41.

### Replace Command is available on

• A.

Insert Tab

• B.

Home Tab

• C.

Page Layout Tab

• D.

Review Tab

B. Home Tab
Explanation
The correct answer is Home Tab. The Replace Command is available on the Home Tab in various software applications, such as Microsoft Word or Excel. This command allows users to search for a specific word or phrase and replace it with another word or phrase throughout the document or spreadsheet. The Home Tab typically contains a range of basic editing and formatting options, including the Find and Replace functionality.

Rate this question:

• 42.

### Advanced Filter option is available on:

• A.

Home Tab

• B.

Insert tab

• C.

Data Tab

• D.

Review Tab

C. Data Tab
Explanation
The advanced filter option is available on the Data Tab. This tab is specifically designed for managing and manipulating data in various ways. It provides tools and functions for sorting, filtering, and analyzing data. The advanced filter option allows users to apply complex criteria and conditions to filter data based on specific requirements. By selecting the Data Tab, users can easily access and utilize this feature to efficiently filter and extract the desired data from a dataset.

Rate this question:

• 43.

### F7 is used for

• A.

Auto text

• B.

Spelling and Grammar

• C.

Thesauraus

• D.

None of the above

B. Spelling and Grammar
Explanation
F7 is commonly used for checking spelling and grammar in various software applications, such as Microsoft Word. When pressed, it runs a spell check on the document, highlighting any misspelled words or grammatical errors. This feature helps users ensure that their written content is error-free and professional. The other options mentioned, auto text and thesaurus, are not directly associated with F7.

Rate this question:

• 44.

### Which one is the smallest memory?

• A.

Bit

• B.

GB

• C.

Byte

• D.

TB

A. Bit
Explanation
A bit is the smallest unit of memory because it represents a single binary digit, either a 0 or a 1. It is the fundamental building block of all digital data and is used to represent the most basic form of information in a computer system. In comparison, a byte is composed of 8 bits, a gigabyte (GB) is much larger and is equal to 1 billion bytes, and a terabyte (TB) is even larger, equal to 1 trillion bytes. Therefore, the bit is the smallest memory unit among the given options.

Rate this question:

• 45.

### Which of the following extension does not indicate graphics file?

• A.

BMP

• B.

JPEG

• C.

GIF

• D.

DOC

D. DOC
Explanation
The extension "DOC" does not indicate a graphics file. It is commonly used for Microsoft Word documents. The other extensions mentioned, BMP, JPEG, and GIF, are all commonly used for various types of image files.

Rate this question:

• 46.

### In MS-Powerpoint which layout can be used to display hierarchies of employees in a company?

• A.

Dialog Box

• B.

Table

• C.

Pie Chart

• D.

Organization Chart

D. Organization Chart
Explanation
An organization chart is the correct layout to display hierarchies of employees in a company in MS-Powerpoint. This layout allows for a clear and visually appealing representation of the different levels and positions within the organization. It typically includes boxes or shapes representing individuals or departments, connected by lines to show the reporting relationships. This helps to illustrate the hierarchical structure and relationships within the company, making it easier to understand and navigate.

Rate this question:

• 47.

### Choose the correct one for the expression: =roundup(31.2345,-1)

• A.

31

• B.

30

• C.

32

• D.

None of the above

C. 32
Explanation
The expression =roundup(31.2345,-1) rounds the number 31.2345 up to the nearest multiple of 10. Since 31.2345 is closer to 30 than 40, rounding up to the nearest multiple of 10 gives us 40. Therefore, the correct answer is 32.

Rate this question:

• 48.

### Ctrl+K is used for

• A.

Left Align

• B.

Hanging Indent

• C.

• D.

Cut

Explanation
Ctrl+K is used to insert a hyperlink. This keyboard shortcut allows users to quickly add a hyperlink to a selected text or object in various software applications, such as word processors, presentation software, and web browsers. By using Ctrl+K, users can easily link to web pages, email addresses, files, or other locations within a document or on the internet, enhancing the accessibility and interactivity of the content.

Rate this question:

• 49.

### By default, Word 2010 format your text as

• A.

Right Align

• B.

Center Align

• C.

Justify

• D.

Left Align

D. Left Align
Explanation
Word 2010 formats the text as "Left Align" by default. This means that the text is aligned to the left margin, creating a straight edge on the right side of the text. It is the most commonly used alignment for text in documents, as it provides a clean and organized appearance.

Rate this question:

• 50.

### Shortcut key used for 1.5 line space

• A.

Ctrl+1

• B.

Ctrl+2

• C.

Ctrl+1.5

• D.

Ctrl+5

D. Ctrl+5
Explanation
The shortcut key used for 1.5 line spacing is Ctrl+5. This key combination allows the user to quickly adjust the line spacing in a document or text editor to 1.5 times the normal spacing. It is a convenient way to increase or decrease the amount of space between lines without having to manually adjust the settings.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 20, 2023
Quiz Edited by
ProProfs Editorial Team
• Mar 06, 2020
Quiz Created by
PHULBANIOCA

Related Topics