Computer set 3 MCQs

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

Showing 470 questions
Q.391 In Excel, what does the function =TEXT(1234.567,"0.00") return?
A 1234.57
B 1234.56
C 1234.567
D 1235
Discuss / Board
Q.392 Which DNS record type is used to prevent email spoofing by specifying authorized mail servers?
A SPF (TXT record)
B MX record
C A record
D CNAME record
Discuss / Board
Q.393 What is the shortcut key to open the ‘Format Cells’ dialog in Excel?
A Ctrl + 1
B Ctrl + F
C Ctrl + Shift + F
D Both A and C
Discuss / Board
Q.394 In MS Word, the ‘Style Inspector’ pane can be opened from:
A The Styles pane dialog launcher or Shift+F1 (Reveal Formatting)
B Ctrl+Shift+S
C Alt+Ctrl+Shift+S
D F8
Discuss / Board
Q.395 Which Linux command displays free disk space?
A df
B du
C free
D lsblk
Discuss / Board
Q.396 In PowerPoint, which view allows you to see speaker notes while presenting?
A Presenter View
B Slide Show view
C Normal view
D Slide Sorter view
Discuss / Board
Q.397 Which network device regenerates and retimes signals to extend the distance of a network?
A Repeater
B Switch
C Router
D Bridge
Discuss / Board
Q.398 What is the purpose of the Windows ‘System File Checker’ tool?
A Repair corrupted operating system files
B Defragment hard drives
C Check for disk errors
D Back up system state
Discuss / Board
Q.399 In Excel, what does the ‘Goal Seek’ feature allow?
A Find the input value needed to achieve a desired formula result
B Optimize multiple variables with constraints
C Analyze data with PivotTables
D Filter data by criteria
Discuss / Board
Q.400 Which type of computer memory is used to store the BIOS settings and is powered by a small battery?
A CMOS RAM
B SRAM
C DRAM
D Virtual RAM
Discuss / Board
Q.401 In the OSI model, which layer manages dialog control and synchronization?
A Session layer
B Transport layer
C Presentation layer
D Application layer
Discuss / Board
Q.402 What is a ‘macro’ in MS Office?
A A recorded sequence of actions that can be replayed to automate tasks
B A large document
C A type of table
D A font style
Discuss / Board
Q.403 In Excel, which function returns the position of a value in a one-dimensional array?
A MATCH
B INDEX
C LOOKUP
D VLOOKUP
Discuss / Board
Q.404 What is the purpose of the ‘ipconfig /flushdns’ command?
A Clear the DNS resolver cache
B Release the IP address
C Renew the IP address
D Display DNS settings
Discuss / Board
Q.405 In MS Word, how can you convert text to a table?
A Insert tab > Table > Convert Text to Table
B Design tab > Table Styles
C Layout tab > Convert to Table
D Home tab > Convert
Discuss / Board
Q.406 Which encryption algorithm is used in WPA2 for wireless security?
A AES
B TKIP
C RC4
D DES
Discuss / Board
Q.407 In the TCP 3-way handshake, what is the sequence?
A SYN, SYN-ACK, ACK
B ACK, SYN, SYN-ACK
C SYN, ACK, FIN
D SYN-ACK, ACK, SYN
Discuss / Board
Q.408 Which type of backup only copies files that have changed since the last full backup?
A Differential backup
B Incremental backup
C Full backup
D Mirror backup
Discuss / Board
Q.409 In Excel, what does the ‘=FILTER()’ dynamic array function do?
A Extract rows meeting specified criteria
B Sort data in ascending order
C Remove duplicates
D Create a PivotTable
Discuss / Board
Q.410 What is the function of the ‘chkdsk’ command in Windows?
A Check and repair file system errors
B Create a new partition
C Format a disk
D Defragment a drive
Discuss / Board
Q.411 In MS Word, how do you change the default font for all new documents?
A Open the Font dialog, set desired font, click ‘Set As Default’ and apply to all documents based on Normal template
B Change font in the current document and save
C Modify the Normal style only for the current document
D File > Options > General
Discuss / Board
Q.412 Which Linux command shows the contents of a text file one page at a time?
A less
B cat
C more
D Both A and C
Discuss / Board
Q.413 In Excel, which function returns TRUE if a number is even?
A ISEVEN
B ISODD
C EVEN
D MOD(number,2)=0 gives TRUE but not direct
Discuss / Board
Q.414 What is the purpose of the Windows ‘Disk Cleanup’ utility?
A Delete temporary files, old system files, and free up disk space
B Defragment hard drive
C Format the disk
D Partition the drive
Discuss / Board
Q.415 In networking, what is the function of a ‘proxy server’?
A Acts as an intermediary for requests from clients seeking resources from other servers
B Assigns IP addresses
C Routes packets based on MAC addresses
D Boosts Wi-Fi signal
Discuss / Board
Q.416 Which Excel function returns the number of cells that meet multiple criteria?
A COUNTIFS
B SUMIFS
C AVERAGEIFS
D COUNTIF
Discuss / Board
Q.417 What is the default port for RDP (Remote Desktop Protocol)?
A 3389
B 22
C 23
D 443
Discuss / Board
Q.418 In MS Word, which option under ‘Paste’ allows pasting content and matching the destination formatting?
A Merge Formatting
B Keep Source Formatting
C Keep Text Only
D Paste Special
Discuss / Board
Q.419 Which Linux command displays the manual page for any command?
A man
B help
C info
D whatis
Discuss / Board
Q.420 In Excel, what does the error ‘#FIELD!’ indicate?
A A formula references a field that doesn’t exist in the data model (Power Pivot / DAX)
B Invalid column reference in a structured table formula
C A missing named range
D A division by zero
Discuss / Board

Master Computer set 3 for All Competitive Exams 2026

Practicing Computer set 3 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: