Computer MCQs for Competitive Exams

In spreadsheet applications, a cell range from A3 through G3 is correctly represented using a colon, specifically keyed in as A3:G3.

CTRL+F10 is the keyboard shortcut commonly used in Windows to maximize or restore a selected window to its previous size.

User-developed instructions or automated sequences of commands in Excel are specifically known as Macros, simplifying repetitive tasks.

The correct answer is AVI.

In computer science and multimedia analytics, evaluating streaming technologies requires analyzing data types and container properties. The question asks for a format capable of transmitting streaming video data. Among the choices provided, AVI (Audio Video Interleave) is the only multimedia container format engineered to store both video and audio streams simultaneously. Developed by Microsoft, AVI structures files so that audio and video data segments alternate sequentially, allowing media players to decode and sync multimedia components dynamically during web playback or progressive downloads.

The alternative distractor options fail to satisfy the core requirement because they are strictly limited to audio architectures. For example, MP3 (MPEG-1 Audio Layer III) is a lossy compression format designed exclusively for acoustic data. Similarly, WMA (Windows Media Audio) and WAV (Waveform Audio File Format) are dedicated digital audio formats developed for sound reproduction and storage. None of these three options possess the technical capacity to encapsulate or transmit structural video frames. Therefore, AVI is the only logically viable option that satisfies the criteria of the prompt.

Mbps (Megabits per second) is the standard unit of measurement used to quantify the speed of an internet connection, representing data transfer rate.

Underlining is a text formatting option directly accessible via a dedicated button on most standard formatting toolbars in word processing software.

The "Edit" option is not typically associated with a spelling dialogue box, which primarily offers ignore, change, or add options for corrections.

The "Custom Slide Show" option enables users to select specific slides and arrange them in a unique order for a tailored presentation.

The kernel is the fundamental core of an operating system, responsible for managing system resources and facilitating communication between hardware and software.

In Ms PowerPoint, the "Format, Replace Fonts" option allows users to efficiently change a specific font across all slides simultaneously.

"Narrow" is a specific preset option for page margins, defining the amount of white space around the content on a document page.

Sans serif fonts are ideal for titles and headlines in Ms PowerPoint due to their clean lines, which enhance readability and visual impact.

Routers primarily operate at Layer 3, the Network Layer, of the OSI model, handling logical addressing and routing data packets between different networks.

VAB is an acronym that precisely stands for "Voice Answer Back," referring to systems capable of providing audio responses.

Multi-user systems save costs by linking several inexpensive dumb terminals to a single powerful processing unit, sharing resources efficiently.

Alt+Ctrl+S is the correct shortcut key in MS Word used to either split a window or remove an existing split view.

An embedded organization chart object can be edited by right-clicking it and selecting "Edit Object" or by simply double-clicking the object.

The Latin term "putare" directly translates to "to reckon" or "to compute," forming the root of words like "compute."

In Word 2016, margin settings are accessed by clicking the "Layout" tab on the menu bar, then navigating to "Page Margins."

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

PowerPoint supports adding sound effects using both .wav (Waveform Audio File Format) and .mid (Musical Instrument Digital Interface) file formats.

A quick way to exit Microsoft PowerPoint is to double-click the application control menu icon, which is located in the upper-left corner of the application window. In classic versions of Microsoft Windows and Microsoft Office, double-clicking this icon immediately closes the PowerPoint application without requiring the user to select the Exit command from the File menu. If there are unsaved changes in the presentation, PowerPoint displays a prompt asking whether the user wants to save the document before exiting. Although this method is less commonly used today, it has long been recognized as a valid shortcut for closing Windows applications and is frequently included in computer literacy examinations.

Modern versions of Microsoft PowerPoint also provide several other methods to exit the application, such as clicking the Close (X) button in the upper-right corner, pressing Alt + F4, or selecting File → Exit. However, for this specific multiple-choice question, the expected answer is "Double-click the application control menu icon", as it refers to a traditional Windows shortcut used to close the entire application quickly.

Why the other options are incorrect:

• Click the application minimize button is incorrect because minimizing only hides the PowerPoint window and does not close the application.
• Click the document close button (X) is incorrect in the context of this question because it closes the current presentation rather than serving as the traditional shortcut method being asked. In modern versions, the window's Close (X) exits the application if it is the last open presentation, but the expected exam answer is the application control menu method.
• None of the above is incorrect because Double-click the application control menu icon is the correct answer.

In Microsoft Word, you magnify your document by navigating to the "View" tab and then selecting the "Zoom" option.

The "Text tool box" allows users to insert custom text boxes anywhere on a slide, bypassing standard placeholders for flexible placement.

The "Slide View" in PowerPoint is used to display and edit individual slides, allowing for detailed content arrangement and modification.