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.241 In Excel, what does the 'Evaluate Formula' tool do?
A Steps through a formula calculation to show how Excel computes the result
B Checks if the formula is valid
C Converts the formula to a constant value
D Traces errors in the formula
Discuss / Board
Q.242 Which Excel feature automatically expands a range when data is added, creating dynamic ranges?
A Table (Ctrl+T)
B Defined Name with OFFSET
C Dynamic Array formulas
D Both A and B
Discuss / Board
Q.243 What is the keyboard shortcut to toggle absolute and relative references in a formula in Excel?
A F4
B F2
C Ctrl + R
D Alt + Enter
Discuss / Board
Q.244 In Excel, which function would you use to count unique values in a range?
A COUNTA(UNIQUE(range))
B COUNTIF
C COUNTUNIQUE
D SUM(1/COUNTIF(range,range))
Discuss / Board
Q.245 What does a 'green triangle' in an Excel cell signify?
A A potential error like number stored as text
B The cell has a comment
C The cell is password protected
D The formula uses volatile functions
Discuss / Board
Q.246 Which Excel function returns the internal rate of return for a series of cash flows?
A IRR
B NPV
C RATE
D PMT
Discuss / Board
Q.247 What is the primary use of 'Scenario Manager' in Excel?
A Create and save different sets of input values that produce different results
B Record macros
C Apply conditional formatting
D Create pivot charts
Discuss / Board
Q.248 In computer architecture, what is the Harvard architecture characterized by?
A Separate storage and buses for instructions and data
B Single memory for both instructions and data
C Use of vacuum tubes
D Microprogrammed control unit
Discuss / Board
Q.249 Which component in a CPU is responsible for fetching instructions?
A Control Unit (CU)
B ALU
C FPU
D Registers
Discuss / Board
Q.250 What is 'overclocking' a CPU?
A Running the processor at a higher clock speed than specified by the manufacturer
B Adding more cores to the CPU
C Increasing the RAM size
D Upgrading the cooling system only
Discuss / Board
Q.251 Which number system does the computer use for storage and processing?
A Binary (base-2)
B Decimal (base-10)
C Octal (base-8)
D Hexadecimal (base-16)
Discuss / Board
Q.252 What is the hexadecimal equivalent of binary 11111111?
A FF
B 100
C 255
D 1A
Discuss / Board
Q.253 Which input device is used in CAD applications for precise drawing?
A Digitizer tablet
B Barcode scanner
C Joystick
D Light pen
Discuss / Board
Q.254 What does the 'Ctrl + Shift + F' shortcut do in MS Word?
A Opens the Font dialog box
B Applies bold formatting
C Changes the font size
D Opens the Find and Replace dialog
Discuss / Board
Q.255 In Excel, how can you restrict a cell to only allow a date between two dates?
A Data Validation > Date, set start and end
B Protect Sheet
C Conditional Formatting
D Custom Number Format
Discuss / Board
Q.256 What is the function of the 'F5' key in PowerPoint?
A Start the slideshow from the beginning
B Insert a new slide
C Open the spell checker
D Save the presentation
Discuss / Board
Q.257 Which network command displays the route packets take to a destination?
A tracert (Windows) / traceroute (Linux)
B ping
C ipconfig
D nslookup
Discuss / Board
Q.258 What is the purpose of the 'hosts' file in Windows/Linux?
A Maps hostnames to IP addresses locally, bypassing DNS
B Stores passwords
C Contains firewall rules
D Logs system events
Discuss / Board
Q.259 Which cryptographic algorithm is an example of an asymmetric algorithm?
A RSA
B AES
C DES
D Blowfish
Discuss / Board
Q.260 In the CIA triad, what does 'integrity' ensure?
A Data is accurate and unaltered by unauthorized parties
B Data is kept secret
C Data is available when needed
D Data is backed up regularly
Discuss / Board
Q.261 What is a 'honeynet'?
A A network of honeypots designed to attract and analyze cyber attackers
B A secure wireless network
C A type of firewall
D An encrypted email service
Discuss / Board
Q.262 Which technique is used to protect against buffer overflow attacks?
A Address Space Layout Randomization (ASLR)
B Antivirus scanning
C Spam filtering
D Disk encryption
Discuss / Board
Q.263 In MS Excel, which function returns the serial number of a specific date?
A DATE
B TODAY
C DATEVALUE
D TIME
Discuss / Board
Q.264 Which of the following is a volatile function in Excel that recalculates every time the sheet changes?
A NOW()
B SUM()
C IF()
D VLOOKUP()
Discuss / Board
Q.265 What is a 'macro' virus?
A A virus written in a macro language, often embedded in documents
B A virus that targets network routers
C A large virus that consumes disk space
D A virus that attacks BIOS
Discuss / Board
Q.266 In Linux, which symbol represents the root directory?
A /
B \
C ~
D .
Discuss / Board
Q.267 Which MS Word feature checks for readability statistics like Flesch-Kincaid grade level?
A Spelling & Grammar (when enabled to show readability)
B Word Count
C Thesaurus
D Smart Lookup
Discuss / Board
Q.268 What is the function of the 'Ctrl + Shift + F9' shortcut in Excel?
A Recalculates all formulas in all open workbooks
B Inspects formula dependencies
C Opens the VBA editor
D Applies the currency format
Discuss / Board
Q.269 In Excel, what does the function =OFFSET(A1,2,3) return?
A The value in the cell 2 rows down and 3 columns right from A1
B The value in A1 shifted by 2 and 3
C A reference to D3
D Both A and C
Discuss / Board
Q.270 Which protocol is used to assign IP addresses automatically and what port does it use?
A DHCP, port 67 (server) / 68 (client)
B DNS, port 53
C SMTP, port 25
D HTTP, port 80
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: