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.61 Which Excel feature lets you display only rows that meet specific conditions without deleting data?
A AutoFilter
B Sort
C Data Validation
D Remove Duplicates
Discuss / Board
Q.62 Which conditional formatting rule highlights the top 10% of values in a range?
A Top/Bottom Rules
B Data Bars
C Color Scales
D Icon Sets
Discuss / Board
Q.63 In a PivotTable, what does the 'Rows' area determine?
A The unique items displayed as row labels
B The numeric values to be summarized
C The filter applied to the entire report
D The column orientation
Discuss / Board
Q.64 Which Excel feature prevents duplicate entries in a column?
A Data Validation using custom formula =COUNTIF(A:A,A1)=1
B Remove Duplicates
C Conditional Formatting to highlight duplicates
D Protect Sheet
Discuss / Board
Q.65 Which lookup function searches the first column of a table and returns a value from any specified column to the left or right?
A XLOOKUP
B VLOOKUP
C HLOOKUP
D INDEX/MATCH
Discuss / Board
Q.66 In Excel, what is the default file extension of a workbook that contains macros?
A .xlsm
B .xlsx
C .xls
D .csv
Discuss / Board
Q.67 What is the shortcut to insert a new worksheet in Excel?
A Shift + F11
B Ctrl + N
C Alt + I, W
D Ctrl + Shift + N
Discuss / Board
Q.68 Which Excel tool helps you analyze how changes in one or two variables affect a formula's result?
A Data Table (What-If Analysis)
B Goal Seek
C Solver
D Scenario Manager
Discuss / Board
Q.69 What is the function of the 'Quick Analysis' tool in Excel?
A Provides instant access to formatting, charting, totals, and table options based on selected data
B Checks for formula errors
C Optimizes workbook size
D Imports data from the web
Discuss / Board
Q.70 Which type of RAM is used as main memory in modern PCs?
A DDR SDRAM
B SRAM
C ROM
D EEPROM
Discuss / Board
Q.71 What does 'DDR' in DDR4 RAM stand for?
A Double Data Rate
B Dual Data Ring
C Direct Dynamic RAM
D Digitally Defined Rate
Discuss / Board
Q.72 Which type of ROM can be erased by exposure to ultraviolet light?
A EPROM
B EEPROM
C Flash ROM
D Mask ROM
Discuss / Board
Q.73 In an operating system, what is the purpose of a 'page file' or 'swap space'?
A Acts as an overflow for physical RAM by using disk storage
B Stores the operating system kernel
C Holds firmware settings
D Caches internet data
Discuss / Board
Q.74 Which interface is commonly used to connect SSDs directly to the motherboard?
A SATA or NVMe (M.2)
B USB
C HDMI
D Ethernet
Discuss / Board
Q.75 What is the storage capacity of a standard single-layer Blu-ray disc?
A 25 GB
B 4.7 GB
C 8.5 GB
D 50 GB
Discuss / Board
Q.76 In Linux, what does the file system ext4 provide that ext3 does not?
A Better performance, larger file sizes, and extents
B Journaling
C Support for Windows
D Graphical user interface
Discuss / Board
Q.77 Which operating system function manages the allocation of CPU time among processes?
A Process scheduling
B Memory management
C File management
D Device management
Discuss / Board
Q.78 What is the advantage of a multi-core processor?
A Can execute multiple threads simultaneously, improving multitasking
B Consumes less power than a single core
C Eliminates the need for RAM
D Increases hard disk speed
Discuss / Board
Q.79 In Windows, what is the 'Task Scheduler' used for?
A Automating tasks to run at specific times or events
B Monitoring network traffic
C Uninstalling software
D Configuring firewalls
Discuss / Board
Q.80 In Linux, which command displays the manual (help) for a command?
A man
B help
C info
D whatis
Discuss / Board
Q.81 Which mobile operating system is developed by Apple?
A iOS
B Android
C Windows Phone
D Symbian
Discuss / Board
Q.82 What is the primary purpose of an antivirus program?
A Detect, prevent, and remove malicious software
B Block spam emails
C Encrypt files
D Manage passwords
Discuss / Board
Q.83 In cybersecurity, what does the term 'honeypot' refer to?
A A decoy system set up to attract and analyze cyber attacks
B A secure password vault
C A type of firewall
D An encryption algorithm
Discuss / Board
Q.84 What type of malware monitors and logs keystrokes?
A Keylogger
B Worm
C Ransomware
D Adware
Discuss / Board
Q.85 Which type of cyber attack encrypts data and demands payment?
A Ransomware
B Phishing
C DDoS
D Spoofing
Discuss / Board
Q.86 What is the safest way to store passwords?
A Using a reputable password manager
B Writing them on paper under the keyboard
C Using the same password everywhere
D Saving in a text file on the desktop
Discuss / Board
Q.87 What is two-factor authentication (2FA) also known as?
A Multi-factor authentication
B Single sign-on
C Biometric scanning
D CAPTCHA
Discuss / Board
Q.88 What does encryption do to data?
A Converts readable data into an unreadable coded form
B Deletes data permanently
C Compresses data to save space
D Creates a backup
Discuss / Board
Q.89 Which of the following is a digital signature used for?
A Verifying the authenticity and integrity of a digital message
B Encrypting emails
C Scanning for viruses
D Filtering spam
Discuss / Board
Q.90 What does the term 'privacy policy' on a website explain?
A How the website collects, uses, and protects user data
B The website's copyright information
C The terms of service for purchases
D The site map
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.

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: