Computers and IT – GK Questions and Answers (MCQs)
In today’s tech-driven world, basic computer knowledge is no longer optional — it’s essential. From sending emails to using digital banking or filling out online applications, computers play a major role in everyday life. That’s why questions on Computers and Information Technology (IT) have become a regular part of competitive exams and government job interviews.
This section is specially designed to help you build your computer awareness through topic-wise MCQs that are useful for students, job aspirants, and professionals preparing for exams like SSC, IBPS, SBI, UPSC, CDS, NDA, Railways, Teaching, and more. Whether you're from a technical background or just brushing up on basics, practicing these questions will help you score better and stay updated.
What you will learn in Computer GK:
Computer’s basic parts consist of input, output, storage and processing. In the basic Computer GK test section, you will learn the conceptual questions on number systems, different generations of computer, computer’s hardware and software, I/O devices, computer memory etc.
Start preparing for your upcoming government exams with Computer & IT GK and boost your confidence one quiz at a time!
Practice Computers and IT by Category
| C Programming MCQs |
| Computer Fundamentals MCQ |
| Computer Networking MCQs |
| Data Structures & Algorithms MCQs |
| Database MCQs |
| MS Excel MCQs |
| MS Word MCQs |
| Operating System MCQs |
Computers and IT Practice MCQ Question and Answer
362
Arrange according to the size
363
What type of relationship exists between a Student table and Fees table?
364
Identify the relationship between a Movie table and Stars table:
365
What type of relationship exists between a Teacher table and Class table?
366
Which of following relationship type is not possible to realize in Access Database directly?
367
For which kind of relationship you need a junction table to reflect real world situation?
368
What do you need if you should enforce many-to-many relationship between two tables?
369
You can display data from multiple tables by using
370
Which database model organizes data in tree-like structure?
371
Which Excel function is used to combine text from multiple cells with a delimiter?
372
What does the SORTBY function do?
373
Which function returns a dynamic array of random numbers between 0 and 1?
374
Which function helps link to another workbook in Excel?
375
Which tab in Excel contains the 'Get & Transform Data' tools?
376
Which new Excel chart is ideal for showing hierarchical data?
377
What is the use of the LET function in Excel?
378
What feature in Excel 365 auto-fills formulas using AI?
379
Which Excel function extracts a value based on multiple conditions?
380
Which Excel 365 feature allows filtering a range with multiple conditions?
381
What does the SEQUENCE() function return?
382
Which function can generate a list of distinct values?
383
Which feature in Excel helps audit formulas using arrows?
384
What is the use of XLOOKUP in Excel 365?
385
Which shortcut creates a new worksheet in Excel?
386
Which function is used to look up a value horizontally in Excel?
387
Which new Excel function replaces the need for VLOOKUP in many cases?
388
What does the UNIQUE() function do in Excel?
389
Which function filters data based on criteria?
390
Which function helps to spill array results across cells?
Benefits of Practicing Computer & IT GK MCQs
- Frequently Asked in Exams: Computer awareness questions are commonly seen in Banking, SSC, Railways, Teaching, and other government exams.
- Score-Boosting Section: A well-prepared computer section can help you improve your overall score with less effort.
- Helpful in Interviews: Demonstrating digital knowledge is an advantage in interviews and group discussions, especially for roles requiring basic computer skills.
- Builds Strong Fundamentals: Practicing MCQs regularly helps strengthen your understanding of key computer and IT concepts.
- Easy to Remember: Repeated quiz practice improves memory retention, especially for definitions, shortcuts, and abbreviations.