Computer — All MCQs
4795 questions available
Q3801.In spreadsheet programs, what is the default menu path or keyboard shortcut used to insert comments into selected cells?
Correct Answer: C
You can insert comments by navigating to Insert > Comment, or by right-clicking a cell and selecting 'Insert Comment' (Shift + F2).
Q3802.In computer systems terminology, what does the word 'BOOT' or 'Booting' stand for?
Correct Answer: D
Booting is the startup sequence that runs diagnostics (POST) and loads the operating system kernel into main memory from storage.
Q3803.In word processing and printing, what is the empty margin space added specifically to the binding side of a page called?
Correct Answer: A
A Gutter margin is extra space added to the left or top margin of a document to ensure text is not hidden or cut off after binding.
Q3804.Which type of non-impact printer utilizes a print head containing thousands of microscopic nozzles to spray liquid ink onto paper?
Correct Answer: B
Inkjet printers are non-impact devices that spray micro-droplets of liquid ink through tiny print-head nozzles directly onto paper.
Q3805.To produce extremely high-quality hardcopy graphic drawings and precise blueprints in color, which device is preferred?
Correct Answer: C
Plotters are specialized output devices used to print large-format, high-resolution vector graphics, line drawings, and architectural blueprints.
Q3806.In Microsoft Word, what keyboard shortcut is used to quickly clear all character formatting (such as bold, italics, or custom fonts) from selected text?
Correct Answer: B
Ctrl + Spacebar resets selected text to its default font and removes manual character styles. Ctrl + Q clears paragraph-level formatting.
Q3807.Which category of programming languages is designed to be machine-independent, meaning the code can execute across different hardware types?
Correct Answer: A
High-level languages (like Python or Java) are abstract and machine-independent. They rely on compilers or interpreters to translate code for specific CPUs.
Q3808.Which device serves as both an input and output device by translating digital computer data into analog signals and vice versa?
Correct Answer: A
A Modem (Modulator-Demodulator) converts outgoing digital data to analog signals (modulation) and incoming analog signals to digital data (demodulation).
Q3809.Which of the following statements best defines the function of a Compiler?
Correct Answer: A
A compiler translates the entire high-level program code into an executable machine-language object file (.obj) before the program is executed.
Q3810.Which software category is Microsoft Excel universally associated with?
Correct Answer: D
Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and visualize numerical data in grids of rows and columns.
Q3811.Which specialized output device is used in engineering and CAD environments to print large-scale, continuous-line technical drawings?
Correct Answer: B
Plotters draw continuous lines using specialized pens or inkjet nozzles, making them ideal for precise, large-scale CAD maps and designs.
Q3812.At their lowest physical level, all modern computer processors store, process, and execute instructions using which number system?
Correct Answer: B
Computer processors are built from digital logic gates that recognize only two electrical states: ON (1) and OFF (0), which is the binary number system.
Q3813.Which function key is standard across Windows operating systems to refresh active folders, file explorers, or web pages?
Correct Answer: C
The F5 function key is the universal shortcut to refresh or reload the active window, folder view, or web page.
Q3814.Which application in the Microsoft Office productivity suite is designed specifically to handle complex calculations and mathematical formulas?
Correct Answer: A
MS Excel is the dedicated spreadsheet application used for data calculations, mathematical formulas, and statistical analysis.
Q3815.Which of the following is a programming language rather than a computer operating system?
Correct Answer: A
Python is a high-level interpreted programming language. Ubuntu and Windows are operating systems that manage hardware.
Q3816.A USB Flash Drive acts as which type of physical hardware component?
Correct Answer: C
A flash drive is a storage medium. It serves as input when reading files to a computer, and as output when writing files from a computer to the drive.
Q3817.Which type of computer memory is designed to permanently retain its stored data and instructions even when electrical power is completely removed?
Correct Answer: A
Non-volatile memory (e.g., ROM, flash drives, HDDs) retains data permanently without requiring a continuous power supply.
Q3818.In Microsoft Excel, which cell attributes can be selectively pasted using the Paste Special command?
Correct Answer: D
The Paste Special command (Ctrl + Alt + V) allows users to selectively paste only formulas, values, cell formats, validation rules, or comments.
Q3819.When is an active Smart Tag automatically removed from a cell in Microsoft Excel?
Correct Answer: B
Excel automatically deletes or clears a smart tag associated with a cell once the original data triggering that tag is modified or erased.
Q3820.Which of the following represents a valid absolute cell reference in Microsoft Excel?
Correct Answer: A
An absolute reference uses dollar signs before both the column letter and row number (e.g., $A$1) to lock the cell coordinate.