Computer & Information Technology

434

Q110. Which Word Quick Access Toolbar claims are false?
P. Save, Undo, Redo appear by default.
Q. Cut, Undo, Redo appear by default.
R. More buttons can be added.
S. It cannot be displayed below the Ribbon.

[SSC CGL Tier-II 2022 (held 3 March 2023)]

1. Q and R only
2. Q and S only
3. P, Q and R
4. All P, Q, R and S

Answer: B. Q and S only

Explanation: The Quick Access Toolbar defaults to Save, Undo and Redo and can be customised with additional commands. It may also be shown below the Ribbon. Consequently, Q wrongly identifies the default buttons and S wrongly denies the positioning option.

Q109. Which is an Excel mathematical or trigonometric function?

[SSC CGL Tier-II 2022 (held 3 March 2023)]

1. TEXT
2. ABS
3. IF
4. PMT

Answer: B. ABS

Explanation: ABS returns the absolute value of a number, removing its negative sign without changing its magnitude. TEXT is a formatting-related function, IF is logical, and PMT is financial. Spreadsheet functions are grouped into categories based on their purposes.

Q108. Each Excel worksheet cell is identified using a cell ______.

[SSC CGL Tier-II 2022 (held 3 March 2023)]

1. colour
2. size
3. rounding
4. reference

Answer: D. reference

Explanation: A cell reference identifies its column and row, for example D12 for column D and row 12. References allow formulas to obtain values from other cells. They may be relative, absolute or mixed, depending on dollar-sign notation.

Q107. Which listed font effect is not provided by Word 2010’s Font dialog?

[SSC CGL Tier-II 2022 (held 3 March 2023)]

1. Superscript
2. Small caps
3. Double strikethrough
4. Equalize character height

Answer: D. Equalize character height

Explanation: Word offers effects including superscript, small caps and double strikethrough in its font settings. Equalize Character Height is not one of the standard options in that dialog. These effects modify appearance rather than changing the words stored in a document.

Q106. Which device is also known as a Visual Display Unit?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. Printer
2. Scanner
3. Trackball
4. Monitor

Answer: D. Monitor

Explanation: A monitor is commonly called a Visual Display Unit because it displays a computer’s images, text and graphical interface. Printers produce hard copy, scanners capture information, and trackballs control on-screen pointers. These are separate peripheral functions.

Q105. A Line Printer Port is a traditional name for which port type?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. Parallel port
2. VGA
3. HDMI
4. DisplayPort

Answer: A. Parallel port

Explanation: The traditional PC parallel printer interface, often labelled LPT, connected printers using multiple data lines. Modern printers more often use USB or networks. VGA, HDMI and DisplayPort are display interfaces, so they are unrelated to the old Line Printer Port designation.

Q104. Which description of secondary memory is false?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. It may serve for backup
2. It normally retains information without power
3. Some computers can run without local secondary storage
4. It is inherently volatile memory

Answer: D. It is inherently volatile memory

Explanation: Secondary storage such as hard disks, SSDs and flash memory is generally nonvolatile, retaining information when electricity is removed. RAM, by contrast, is typically volatile. Network-booted or specially configured computers may operate without a conventional local disk.

Q103. Which memory type accelerates processing by making recently needed data available rapidly to the CPU?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. Backup memory
2. Auxiliary memory
3. Main memory
4. Cache memory

Answer: D. Cache memory

Explanation: Cache memory is engineered for short access latency and normally retains useful copies of data already held elsewhere in the hierarchy. Keeping frequently accessed information close to the CPU reduces delays caused by repeated trips to relatively slower main memory.

Q102. Which processor category predates dual-core, triple-core and quad-core processors?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. Triple-core
2. Single-core
3. Dual-core
4. Quad-core

Answer: B. Single-core

Explanation: A single-core processor contains one main processing core, the standard design before consumer multi-core chips became common. Dual-, triple- and quad-core designs integrate multiple cores and can execute multiple threads more efficiently when the software can parallelise tasks.

Q101. Which storage appliance delivers shared file storage over an Ethernet local-area network?

[SSC CGL Tier-II 2022 cycle (held 3 March 2023)]

1. Standalone SSD
2. USB hard drive
3. USB memory stick
4. Network Attached Storage

Answer: D. Network Attached Storage

Explanation: Network Attached Storage devices expose files to network users through standard protocols over a LAN. They centralise storage and can provide access controls and redundancy. USB sticks and directly connected drives do not inherently deliver shared network file services.