Computer MCQs for Competitive Exams

The Format Painter tool in MS Word allows users to quickly copy and apply the exact formatting from one selected text to another.

All Caps is a text formatting feature in Microsoft Word that converts all selected lowercase letters into uppercase letters without changing the actual text content. It is commonly used for headings, titles, document labels, certificates, notices, and other text that needs to stand out. The feature is available through the Font dialog box or by using the Change Case (Aa) option on the Home tab. Users can also apply the keyboard shortcut Shift + F3 repeatedly to cycle through lowercase, UPPERCASE, and Capitalize Each Word. Using the All Caps feature improves the visual emphasis of important text while preserving the original characters.

It is important to distinguish between typing in uppercase using the Caps Lock key and applying the All Caps formatting effect. Caps Lock affects new text as it is typed, whereas the All Caps feature changes the appearance of existing selected text. Since it is a formatting effect, the original lowercase letters remain unchanged in the document's underlying text and can be reverted by removing the formatting. This feature is widely used in professional documents to create consistent and prominent headings without manually retyping the text.

Why the other options are incorrect:

• Adds captions to images is incorrect because image captions are inserted using the Insert Caption feature, not the All Caps option.
• Displays all image captions is incorrect because the All Caps feature only changes the capitalization of text and has no relation to image captions.
• Changes the font size is incorrect because font size is controlled separately through the Font Size settings and is unrelated to the All Caps formatting feature.

The Hanging Indent Marker controls the indentation of all lines in a paragraph except for the very first line, creating a distinct visual effect.

The Page Down key in Microsoft Word moves the cursor and the document view one full screen down, facilitating quicker navigation through content.

The Column command in Microsoft Word, used for formatting text into multiple columns, is found within the Page Layout tab on the ribbon interface.

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.