Computer MCQs for Competitive Exams

To find synonyms and antonyms for a selected word, one would typically use the Thesaurus feature, often accessed through the "Tools, Language" menu option.

The keyboard shortcut "Window key + Shift + M" is specifically designed to un-minimize or restore all previously minimized application windows on your desktop.

Ctrl + Shift + 1 in Microsoft Excel is a keyboard shortcut used to apply the Number format with two decimal places, a thousands separator (if applicable), and negative numbers displayed with a minus sign. This formatting makes numerical data easier to read and analyze, especially in financial statements, budgets, sales reports, and statistical worksheets. Unlike the General format, the Number format provides a consistent appearance for numeric values by automatically displaying two decimal places. This shortcut is one of several built-in formatting shortcuts in Excel that help users quickly format data without opening the Format Cells dialog box.

Microsoft Excel includes many useful formatting shortcuts for different types of data. For example, Ctrl + Shift + ~ applies the General format, Ctrl + Shift + 4 applies the Currency format, Ctrl + Shift + 5 applies the Percentage format, and Ctrl + Shift + 2 applies the Time format. Learning these shortcuts increases productivity and enables users to prepare professional spreadsheets efficiently. Since Ctrl + Shift + 1 specifically applies the Number format with two decimal places, it is a frequently tested shortcut in computer literacy and competitive examinations.

Why the other options are incorrect:

• Format number in General format is incorrect because the General format is applied using Ctrl + Shift + ~, not Ctrl + Shift + 1.
• Format number in currency format is incorrect because the Currency format is applied using Ctrl + Shift + 4.
• Format number in time format is incorrect because the Time format is applied using Ctrl + Shift + 2.

Slide Master in Microsoft PowerPoint is a feature that controls the overall design, formatting, and appearance of all slides in a presentation. It allows users to apply a consistent theme by defining fonts, colors, backgrounds, placeholders, logos, headers, footers, and other formatting elements in one central location. Any changes made to the Slide Master are automatically reflected on all slides that use its associated layouts, ensuring a uniform and professional appearance throughout the presentation. This feature is especially useful for business presentations, educational lectures, and corporate templates where consistency is essential.

The Slide Master can be accessed from the View tab by selecting Slide Master. Instead of formatting each slide individually, users can edit the master slide once to save time and maintain consistency across the entire presentation. Multiple slide layouts can also be customized under the same master to accommodate title slides, content slides, comparison slides, and other layouts while preserving the overall theme. Using the Slide Master is considered one of the best practices for creating well-organized and visually appealing PowerPoint presentations.

Why the other options are incorrect:

• Add a slide simply inserts a new slide into the presentation and does not control the overall design or formatting.
• Outline view displays the presentation's text structure for easy editing but does not affect the visual appearance of the slides.
• Slide Transition controls the visual effects when moving from one slide to another during a presentation and does not determine the overall design or layout.

A mail merge main document contains the static information that remains consistent across all generated form letters, such as the letter's body text.

DMA (Direct Memory Access) is a hardware feature that allows peripheral devices to transfer data directly to and from the computer's main memory (RAM) without requiring continuous intervention from the Central Processing Unit (CPU). Instead of the CPU handling every data transfer operation, a dedicated DMA controller manages the transfer, allowing the processor to perform other tasks simultaneously. This improves overall system performance, increases data transfer speed, and reduces CPU workload. DMA is commonly used by high-speed devices such as hard disk drives, solid-state drives (SSDs), graphics cards, sound cards, and network interface cards.

DMA plays an important role in modern computer architecture because it enables efficient communication between hardware components and memory. During a DMA operation, the controller temporarily takes control of the system bus, transfers the required data, and then returns control to the CPU. Various transfer modes, including Burst Mode, Cycle Stealing, and Transparent Mode, are used depending on the system's performance requirements. The use of DMA significantly enhances multitasking capabilities and is an essential feature in modern operating systems and computer hardware.

Why the other options are incorrect:

• Direct Module Access is not the official expansion of DMA and is not a recognized term in computer science.
• Distinct Module Access is an incorrect variation and has no accepted meaning in computer architecture.
• Data Memory Access is not the standard expansion of DMA, although it sounds similar. The correct and universally accepted term is Direct Memory Access.

Micro Computers are commonly referred to as personal computers because they are designed for individual use, offering a balance of power and affordability.

LED is an acronym for Light Emitting Diode, a semiconductor light source that emits light when current flows through it.

Mosaic is widely recognized as the first graphical web browser, playing a crucial role in popularizing the World Wide Web for general public use.

The Outline view in PowerPoint specifically displays the presentation's structure, showing only titles and main text points for easy organization.

Microsoft Word allows users to insert a maximum of 63 columns in a single document, providing extensive layout flexibility for complex designs.

FORTRAN is an acronym for "Formula Translation," a high-level programming language primarily used for numerical and scientific computing applications.

MAC stands for Media Access Control, a unique identifier assigned to network interfaces for communications within a specific network segment.

A nibble is a unit of digital information consisting of four bits, which is precisely half of an eight-bit byte.

The keyboard shortcut Ctrl+1 in Excel is used to quickly open the Format Cells dialog box, allowing various formatting options.

The CPU, or Central Processing Unit, is the fundamental hardware component responsible for executing instructions and performing all data processing operations within a computer system.

The keyboard shortcut Alt+Shift+F1 in Excel is specifically used to insert a new worksheet into the current workbook.

The keyboard shortcut Ctrl+Shift+N is universally used on Windows operating systems to quickly create a new folder in the current directory.

XML (Extensible Markup Language) is a text-based markup language designed to store, organize, and transport data in a structured and human-readable format. It was developed by the World Wide Web Consortium (W3C) and is widely used for exchanging information between different computer systems and applications. Unlike HTML, which focuses on displaying data, XML is designed to describe and carry data using user-defined tags. Its platform-independent nature makes it suitable for data sharing across different operating systems, programming languages, and software applications.

XML is extensively used in web services, configuration files, office document formats, RSS feeds, and data interchange between databases and applications. Popular file formats such as Microsoft Office Open XML (.docx, .xlsx, .pptx) are based on XML. The language is both machine-readable and human-readable, making it easy to process, validate, and maintain. Although newer formats like JSON are often preferred for lightweight web applications, XML remains an essential technology in enterprise systems, APIs, and many industry-standard data exchange protocols due to its flexibility and structured design.

Why the other options are incorrect:

• Extensible Media Language is not the official expansion of XML and is not a recognized standard.
• Xtensible Markup Language is incorrect because the full form begins with Extensible, not "Xtensible."
• Extensible Markup Letters is not a valid expansion and does not represent any recognized computer technology term.

ISP (Internet Service Provider) is a company or organization that provides individuals, businesses, and institutions with access to the Internet. An ISP offers services such as broadband, fiber-optic, DSL, cable, wireless, and mobile Internet connections. In addition to Internet access, many ISPs also provide email accounts, web hosting, domain registration, cloud storage, and cybersecurity services. Users subscribe to an ISP and connect to the Internet through devices such as modems, routers, or fiber-optic terminals. Examples of ISPs include PTCL, Nayatel, StormFiber, Optix, and various mobile network operators that offer 4G and 5G Internet services.

An ISP acts as the gateway between a user's device and the global Internet by routing data packets across networks. The quality of an ISP is often measured by its download and upload speeds, reliability, coverage, customer support, and pricing. Modern ISPs use advanced networking technologies to ensure secure and high-speed connectivity for activities such as web browsing, online learning, video streaming, cloud computing, online gaming, and video conferencing. Choosing a reliable ISP is essential for maintaining a stable and efficient Internet connection.

Why the other options are incorrect:

• Internal Server Provider is not the official expansion of the acronym ISP and is not a recognized networking term.
• Internet Server Provider is an incorrect variation because ISPs provide Internet access rather than functioning solely as server providers.
• Insta Service Provider is not a valid or recognized expansion of ISP in computer networking.

In Excel, the keyboard shortcut Ctrl+Shift+2 is specifically used to apply the time format to selected cells, displaying numbers as hours and minutes.

John Vincent Atanasoff, along with Clifford Berry, is credited with inventing the Atanasoff–Berry Computer, an early electronic digital computer.

ALU stands for Arithmetic Logic Unit, a digital circuit within a CPU that performs arithmetic and bitwise logic operations.

The Melissa virus, which emerged in 1999, was a fast-spreading macro virus primarily disseminated through email attachments, making it an E-mail virus.

In presentation software like Microsoft PowerPoint, pressing Ctrl+M is the standard shortcut to insert a new blank slide into the current presentation.