Computer set 2 MCQs

Practice interactive objective questions for this topic. Select an option to instantly verify your answer and read detailed explanations.

Showing 525 questions
Q.211 In Excel, what is an array formula (legacy CSE formula) that uses Ctrl+Shift+Enter?
A A formula that performs multiple calculations on one or more items in an array
B A regular formula entered with Ctrl+Enter
C A formula that only works on Mac
D A formula that uses external data
Discuss / Board
Q.212 What does the 'Slicer' feature do in Excel PivotTables?
A Provides a visual way to filter data in a PivotTable
B Cuts a chart into multiple pieces
C Deletes duplicate rows
D Splits text into columns
Discuss / Board
Q.213 Which Excel function returns the number of periods for an investment based on periodic, constant payments and interest rate?
A NPER
B PMT
C PV
D FV
Discuss / Board
Q.214 What is the purpose of the 'Watch Window' in Excel?
A Monitor values of specific cells across different worksheets while working
B Track changes made by users
C Show all formulas in the workbook
D View all hidden rows and columns
Discuss / Board
Q.215 In Excel, what does the function =AGGREGATE(9,6,range) do?
A Applies a function like SUM while ignoring errors and hidden rows
B Returns the 9th largest value
C Aggregates data from multiple sheets
D Creates a pivot table
Discuss / Board
Q.216 Which Excel tool is used to import data from external databases like SQL Server?
A Power Query (Get & Transform Data)
B Goal Seek
C Solver
D PivotTable
Discuss / Board
Q.217 In MS Word, what does the 'Combine' feature (under Review) do?
A Merges revisions from multiple authors into a single document
B Joins two tables
C Combines several images into one
D Links Excel data to Word
Discuss / Board
Q.218 What is the shortcut to apply subscript in MS Word?
A Ctrl + =
B Ctrl + Shift + +
C Ctrl + Shift + =
D Ctrl + ]
Discuss / Board
Q.219 In MS Word, which feature helps you create a list of figures or tables with page numbers?
A Table of Figures (References tab)
B Table of Contents
C Index
D Bibliography
Discuss / Board
Q.220 What is the function of 'SmartArt' in MS Office?
A Create professional diagrams like processes, hierarchies, and cycles
B Apply artistic effects to pictures
C Check grammar
D Translate text
Discuss / Board
Q.221 In operating systems, what is a 'deadlock'?
A A situation where two or more processes are waiting indefinitely for resources held by each other
B A system crash due to memory overflow
C A hardware failure
D A frozen user interface
Discuss / Board
Q.222 Which CPU scheduling algorithm provides the shortest average waiting time?
A Shortest Job First (SJF)
B First-Come, First-Served (FCFS)
C Round Robin
D Priority Scheduling
Discuss / Board
Q.223 What is the function of the 'fork()' system call in Unix/Linux?
A Creates a new process by duplicating the calling process
B Kills a running process
C Renames a file
D Mounts a file system
Discuss / Board
Q.224 In memory management, what is 'internal fragmentation'?
A Wasted memory within an allocated block due to rounding up to the next allocation unit
B Unused memory between allocated blocks
C Memory corrupted by a virus
D Disk fragmentation
Discuss / Board
Q.225 Which page replacement algorithm replaces the page that will not be used for the longest time in the future?
A Optimal (OPT)
B FIFO
C LRU
D Clock
Discuss / Board
Q.226 What is the purpose of the 'init' process in Linux?
A It is the first process started by the kernel and the ancestor of all other processes
B It manages user logins
C It mounts file systems
D It compiles the kernel
Discuss / Board
Q.227 Which command in Linux changes the ownership of a file?
A chown
B chmod
C chgrp
D ls -l
Discuss / Board
Q.228 What is the function of the 'cron' daemon in Linux?
A Schedules tasks to run automatically at specified times
B Monitors network traffic
C Manages print jobs
D Scans for viruses
Discuss / Board
Q.229 In Windows, which tool is used to edit the registry?
A regedit
B msconfig
C taskmgr
D devmgmt.msc
Discuss / Board
Q.230 What is the purpose of the 'System Restore' feature in Windows?
A Reverts system files and settings to an earlier point in time without affecting personal files
B Creates a full backup of the hard drive
C Restores deleted emails
D Resets the BIOS password
Discuss / Board
Q.231 What does the 'msconfig' utility do?
A Configure startup programs, services, and boot options
B Monitor system performance
C Uninstall applications
D Edit the registry
Discuss / Board
Q.232 Which command in Linux displays disk usage of files and directories?
A du
B df
C ls -l
D fdisk
Discuss / Board
Q.233 What is a 'kernel panic' in Linux?
A A fatal error detected by the operating system kernel from which it cannot safely recover
B A high-priority process termination
C A disk full error
D A user login failure
Discuss / Board
Q.234 In OS process states, what is a 'zombie process'?
A A process that has completed execution but still has an entry in the process table
B A process waiting for user input
C A process that is sleeping
D A process infected by malware
Discuss / Board
Q.235 Which component of a computer uses 'pipelining' to improve performance?
A CPU
B Hard disk
C Power supply
D RAM
Discuss / Board
Q.236 What is the difference between RISC and CISC architectures?
A RISC uses simpler instructions that execute in one clock cycle; CISC has complex multi-cycle instructions
B RISC is only used in mainframes; CISC in microcontrollers
C RISC has more instructions than CISC
D RISC is slower than CISC
Discuss / Board
Q.237 Which type of memory is used in a 'solid-state drive' (SSD)?
A NAND flash memory
B DRAM
C SRAM
D Magnetic tape
Discuss / Board
Q.238 What does the 'IOPS' metric measure in storage devices?
A Input/Output Operations Per Second
B Internet Operations Per Second
C Internal Operating System Speed
D Integrated Output Processing System
Discuss / Board
Q.239 In MS Word, which field code would you insert to automatically display the file name in the document?
A FILENAME
B DOCPROPERTY
C FILESIZE
D PAGE
Discuss / Board
Q.240 Which option in MS Word allows you to embed fonts to ensure they display correctly on other computers?
A File > Options > Save > Embed fonts in the file
B Design > Fonts > Embed
C Insert > Text Box
D Page Layout > Fonts
Discuss / Board

Master Computer set 2 for All Competitive Exams 2026

Practicing Computer set 2 MCQs is one of the most effective ways to prepare for competitive examinations in 2026. This topic-wise question bank contains carefully selected multiple-choice questions designed to strengthen conceptual understanding, improve accuracy, and enhance problem-solving speed. Our collection includes beginner, intermediate, and advanced-level questions frequently asked in JKSSB, SSC, Banking, Railway, Police, Defence, State PSC, and various national-level examinations. Every question is structured to reflect real exam patterns and helps candidates become familiar with objective-type assessment formats. Instant answer verification enables students to identify mistakes immediately and learn the correct approach without wasting valuable preparation time. Regular practice of topic-wise MCQs improves retention, reinforces key concepts, and develops confidence required to perform well under exam pressure. Whether you are revising important concepts, preparing for an upcoming recruitment test, or strengthening weak areas, these practice questions provide a reliable platform for continuous improvement. Consistent participation in MCQ-based learning sessions can significantly increase your chances of achieving higher scores and better ranks in competitive examinations.

For additional MCQs, detailed question explanations, exam discussions, and doubt-solving support, candidates can also visit Ask JK Exam Library , the official Q&A and practice platform of JK Exam Library. The platform offers 50,000+ verified MCQs covering JKSSB, JKPSC, SSC, UPSC, Railway, Banking, Police, Defence, CUET, Teaching, and many other competitive examinations. Every question includes an instant answer with a detailed explanation, helping aspirants understand concepts quickly and improve accuracy. Students can also participate in Daily Quiz Challenges, ask doubts, discuss questions with fellow aspirants, and strengthen their exam preparation through one of the fastest-growing learning communities for competitive exams..

Frequently Asked Questions

Select individual options to trigger real-time validation matrix hooks. This evaluates your answers instantly and shows the correct methodology in the solution box.

Absolutely. Our content team regularly updates the question bank to reflect the latest JKSSB, SSC, Banking, Railways, Defence, and other competitive exam trends.

The number of questions varies by topic and is regularly expanded to provide comprehensive practice coverage for competitive examinations.

Yes, you can attempt the questions as many times as needed to improve accuracy, speed, and concept retention.

Yes, important questions are accompanied by explanations and solutions to help candidates understand the correct answers effectively.

Yes, this topic is frequently covered in various competitive examinations and forms an important part of exam preparation strategies.

Absolutely. The questions are suitable for both beginners and advanced learners preparing for competitive examinations.

Topic-wise practice helps identify weak areas, strengthen concepts, and build confidence before attempting full-length mock tests.

Yes, the question database is continuously updated with new MCQs to maintain relevance and align with changing exam patterns.

Regular practice with topic-wise MCQs helps candidates reduce mistakes, improve accuracy, and perform better in actual examinations.

Yes, topic-specific MCQs provide a quick and effective revision method for reinforcing important concepts before exams.

The question bank includes a mix of easy, moderate, and challenging questions designed to reflect real competitive exam standards.

Solution View

Correct Answer
Detailed Explanation: