Computer Fundamentals Practice MCQ Question and Answer

Computer Knowledge MCQ Quiz

Computer Fundamental Miscellaneous

1. What does CPU stand for?

Central Power Unit Central Processing Unit Computer Personal Unit Central Peripheral Unit

2. Which of the following is an input device?

Monitor Keyboard Printer Speaker

3. What is the smallest unit of data in a computer?

Byte Bit Kilobyte Megabyte

4. Which of these is a volatile memory?

Hard Disk Drive SSD RAM ROM

5. What is the full form of ALU?

Application Logic Unit Arithmetic Logic Unit Array Logic Unit Automatic Logic Unit

6. A collection of 8 bits is called a:

Nibble Byte Word Record

7. Which component is known as the 'brain' of the computer?

Monitor Keyboard CPU RAM

8. What is the purpose of a Motherboard?

To display output To connect all components of a computer To store data permanently To process calculations

9. Which of these is an output device?

Mouse Scanner Printer Joystick

10. What is firmware?

Software that runs on a server Software permanently programmed into a hardware device A type of antivirus software Temporary data stored in RAM

11. What is the function of a cache memory?

To store large amounts of data To speed up data access by storing frequently used data To perform arithmetic operations To manage network connections

12. Which generation of computers used vacuum tubes?

First Generation Second Generation Third Generation Fourth Generation

13. What is a GUI?

General User Interface Graphical User Interface Global User Interaction Graphic Utility Interface

Operating System

14. What is the primary function of an Operating System?

To write documents To manage hardware and software resources To browse the internet To play games

15. Which of these is NOT an operating system?

Linux Windows Microsoft Office macOS

16. What is multitasking in an OS?

Running one program at a time Running multiple programs simultaneously Connecting to multiple networks Managing multiple users

17. Which part of the OS manages memory?

File System Scheduler Memory Manager Device Driver

18. What is a kernel in an Operating System?

A type of application software The core component of an operating system A user interface element A hardware component

19. Which of these is an open-source operating system?

Windows 10 macOS Ventura Ubuntu iOS

20. What is the purpose of a device driver?

To install new software To allow the OS to communicate with hardware devices To protect against viruses To manage network connections

21. What is virtual memory?

RAM that is not physically present A technique that allows the OS to compensate for physical memory shortages by temporarily transferring data from RAM to disk storage Memory used by virtual machines Memory that is only accessible over a network

22. Which of these is a mobile operating system?

Windows Linux Android Unix

23. What is a process in the context of an OS?

A file stored on the hard drive An instance of a computer program that is being executed A network connection A user account

24. Which OS is known for its command-line interface (CLI) and multi-user capabilities?

Windows macOS Unix Android

25. What is the purpose of a firewall in an OS?

To speed up internet browsing To monitor and control incoming and outgoing network traffic To manage disk space To compress files

MS Word

26. Which tab in MS Word is used to change font and paragraph settings?

Insert Home Page Layout View

27. What is the shortcut key to 'Save' a document in MS Word?

Ctrl + X Ctrl + C Ctrl + V Ctrl + S

28. Which feature is used to check the spelling and grammar in MS Word?

Thesaurus Spelling & Grammar Word Count AutoCorrect

29. What is the default file extension for a Word document?

.txt .docx .pdf .xlsx

30. Which view shows how your document will look when printed?

Draft View Web Layout View Print Layout View Outline View

31. To apply a hanging indent, you can use which shortcut key?

Ctrl + T Ctrl + T Ctrl + M Ctrl + H

32. Which option is used to change the case of selected text in MS Word?

Font Style Change Case Text Effects Highlight

33. Mail Merge feature is available under which tab?

Review Mailings Design View

34. What is a "Header" and "Footer" in MS Word?

Text at the beginning and end of a document Text or graphics that appear at the top and bottom of every page Special effects for text Sections for footnotes and endnotes

35. Which shortcut key is used to Undo the last action?

Ctrl + X Ctrl + Z Ctrl + Y Ctrl + A

36. To create a new paragraph in MS Word, you press:

Shift + Enter Enter Ctrl + Enter Alt + Enter

37. Which ribbon tab is used to insert pictures, shapes, and charts?

Home Design Insert Layout

38. What is the purpose of 'Page Break' in MS Word?

To break a sentence into two lines To force the text after the break to start on a new page To insert a blank page To create a new section

MS Excel

39. In MS Excel, what does 'SUM' function do?

Calculates average Adds up numbers in a range Finds maximum value Counts cells

40. A cell in Excel is identified by its:

Name Row and Column label Formula Value

41. Which symbol must all formulas in Excel begin with?

# + = @

42. What is a "Workbook" in Excel?

A single sheet A collection of worksheets A table of data A chart

43. Which function is used to find the largest value in a range?

MIN() MAX() AVERAGE() COUNT()

44. What does "Merge & Center" do in Excel?

Merges rows and aligns left Combines selected cells into one and centers the content Centers text in a single cell Merges columns and aligns right

45. The intersection of a row and a column is called a:

Table Cell Range Worksheet

46. What is a "PivotTable" used for in Excel?

Creating simple charts Summarizing, analyzing, exploring, and presenting summary data Performing complex calculations Sorting data alphabetically

47. Which tab contains the "Conditional Formatting" option?

Insert Home Data Formulas

48. What is the purpose of the "Fill Handle" in Excel?

To resize columns To copy data or formulas to adjacent cells To move cells To change cell formatting

49. How do you select an entire column in Excel?

Click on any cell in the column Click on the column header (letter) Drag the mouse across the column Press Ctrl + C

50. Which chart type is best for showing trends over time?

Pie Chart Line Chart Bar Chart Scatter Plot

51. What is the shortcut to insert a new worksheet?

Ctrl + N Shift + F11 Ctrl + W Alt + N

Power Point

52. Which view in PowerPoint displays slides as miniatures?

Normal View Slide Show View Slide Sorter View Notes Page View

53. What is a "Theme" in PowerPoint?

A specific font style A set of predesigned formats for slides A type of animation A sound effect

54. Which tab is used to add animations to objects on a slide?

Insert Animations Transitions Design

55. What is a "Slide Master" in PowerPoint?

The first slide of a presentation A top-level slide that controls the layout and formatting of all slides in a presentation A slide that contains only images A template for creating new presentations

56. Which shortcut key is used to start a slide show from the beginning?

F2 F5 F7 F12

57. What is a "Transition" in PowerPoint?

A movement of an object on a slide The visual effect that occurs when you move from one slide to the next during a presentation A change in font style A way to insert video

58. Which tab allows you to add sound or video clips to your presentation?

Home Insert Review View

59. What is the purpose of "Presenter View"?

To edit slides during a presentation To view notes, upcoming slides, and a timer while the audience sees only the current slide To rearrange slides quickly To print handouts

60. Which type of file can be directly opened in PowerPoint?

.docx .pptx .xlsx .pdf

61. How do you duplicate a slide in PowerPoint?

Ctrl + C, then Ctrl + V Right-click on the slide in the thumbnail pane and select "Duplicate Slide" Press Ctrl + D Both B and C

62. Which option allows you to set the timing for each slide in a presentation?

Slide Show Setup Rehearse Timings Custom Animation Slide Master

63. What is the primary purpose of a PowerPoint presentation?

To create complex spreadsheets To create visual aids for presentations To manage databases To write long documents

64. Which tab would you use to change the background style of your slides?

Home Design Insert View

MS Access

65. In MS Access, what is a "Table"?

A report A collection of related data organized in rows and columns A form for data entry A query result

66. Which of the following is used to retrieve specific data from a database in Access?

Form Report Query Macro

67. What is a "Primary Key" in Access?

A field that links two tables A field that uniquely identifies each record in a table A field used for sorting data A field that stores text data

68. Which object in Access is used for data entry and viewing?

Table Form Query Report

69. What is the purpose of a "Report" in MS Access?

To store data To present data from tables or queries in a printable format To enter new data To perform calculations

70. Which data type is used to store large amounts of text in Access?

Short Text Long Text (Memo) Number Date/Time

71. What is a "Relationship" in Access?

A connection between forms A link between two or more tables based on common fields A way to filter data A type of query

72. Which view allows you to design the structure of a table in Access?

Datasheet View Design View Layout View Print Preview

73. What is a "Foreign Key"?

A key that is not a primary key A field in one table that refers to the primary key in another table A key used for encryption A unique identifier for a database

74. Which type of query is used to add new records to a table?

Select Query Append Query Update Query Delete Query

75. What is "Referential Integrity" in Access?

Ensuring data is accurate A system of rules that Access uses to ensure that relationships between records in related tables are valid Protecting data from unauthorized access Optimizing database performance

76. The default view for a table in Access is:

Design View Datasheet View Layout View Print Preview

77. Which of these is NOT a valid data type in MS Access?

Number Paragraph Currency Yes/No

Microsoft Windows

78. What is the main screen of Windows called?

Control Panel Desktop Taskbar Start Menu

79. Which utility is used to manage files and folders in Windows?

Control Panel Device Manager File Explorer Task Manager

80. What is the purpose of the Recycle Bin?

To store temporary files To temporarily store deleted files and folders To store system backups To optimize disk space

81. Which shortcut key is used to open the Run dialog box in Windows?

Ctrl + R Windows Key + R Alt + R Shift + R

82. What is the "Taskbar" in Windows?

A bar at the top of the screen A bar typically at the bottom of the screen that displays open applications and shortcuts A menu for system settings A tool for searching files

83. Which option allows you to safely remove external hardware devices?

Unplug device Safely Remove Hardware and Eject Media Device Manager Disk Management

84. What is the function of "Control Panel" in Windows?

To browse the internet To configure system settings and manage hardware/software To create documents To play media files

85. Which shortcut key is used to lock your computer screen?

Ctrl + Alt + Del Windows Key + L Alt + F4 Ctrl + Shift + Esc

86. What is "User Account Control" (UAC) in Windows?

A feature for managing user passwords A security feature that helps prevent unauthorized changes to your computer A tool for creating new user accounts A setting for parental controls

87. Which application is used to browse the web in Windows by default?

Microsoft Word Microsoft Edge File Explorer Calculator

88. What is the purpose of "Disk Cleanup"?

To defragment the hard drive To free up disk space by removing unnecessary files To check for disk errors To create disk partitions

89. Which of these is a way to shut down Windows?

Press the power button on the computer Click Start -> Power -> Shut down Unplug the power cord Close all open applications

90. What is "Windows Update"?

A tool for changing desktop background A service that provides software updates for the operating system and other Microsoft products A feature for creating system restore points A program for managing network connections

Internet and Web Technology

91. What does HTML stand for?

High Tech Modern Language Hyper Text Markup Language Hyperlink and Text Markup Language Home Tool Markup Language

92. Which protocol is used for sending emails?

HTTP FTP SMTP TCP/IP

93. What does URL stand for?

Universal Resource Link Uniform Resource Locator Uniform Remote Link Universal Remote Locator

94. Which of these is a web browser?

Microsoft Word Google Chrome Adobe Photoshop VLC Media Player

95. What is "HTTP" primarily used for?

File transfer Transferring hypertext over the Internet Sending emails Secure communication

96. What does "WWW" stand for?

World Wide Widgets World Wide Web Web Wide World Wireless Web World

97. What is a "Domain Name" in web technology?

The address of an email server A unique, easy-to-remember address used to access websites A type of internet connection A programming language for websites

98. Which of these is a search engine?

Facebook Bing Wikipedia Netflix

99. What is "IP Address" short for?

Internet Protocol Access Internet Protocol Address Internal Private Address Internet Personal Address

100. What is "Phishing"?

A method of online shopping A type of online fraud where attackers attempt to trick individuals into revealing sensitive information A technique for optimizing website speed A way to block unwanted emails

101. What does "HTTPS" indicate?

HyperText Transfer Protocol Standard HyperText Transfer Protocol Secure High Traffic Transfer Protocol Service Home Transfer Protocol System

102. What is a "Cookie" in web browsing?

A small program that runs on your computer A small piece of data sent from a website and stored on the user's computer by the web browser A type of web advertisement A security certificate

103. What is the purpose of a "DNS" server?

To store website content To translate domain names into IP addresses To secure web connections To send emails

Your Score: 0 / 0