Basic Computer & MS Office MCQs C) Storage device

with Answers D) None

Preparation With Mushtaque | 7. Hard disk is a:

03233079098 A) Primary storage
B) Secondary storage
C) Cache memory
HARDWARE D) ROM
1. The brain of the computer is 8. CU in CPU stands for:
called: A) Central Unit
A) Monitor B) Control Unit
B) CPU C) Cache Unit
C) RAM D) Computing Unit
D) Keyboard
9. Mouse is a:
2. ALU stands for: A) Output device
A) Arithmetic Logic Unit B) Storage device
B) Advanced Logic Unit C) Input/Pointing device
C) Arithmetic Language Unit D) Processing device
D) None
10. Plotter is used for:
3. Monitor is a/an: A) Typing text
A) Input device B) Scanning images
B) Storage device C) Printing large graphics
C) Output device D) Storing data
D) Processing device
MEMORY & STORAGE
4. Keyboard is a/an:
11. RAM stands for:
A) Output device
A) Read Access Memory
B) Input device
B) Random Access Memory
C) Storage device
C) Read All Memory
D) Processing device
D) Random All Memory
5. Printer is a/an:
12. ROM stands for:
A) Input device
B) Storage device A) Read Only Memory
C) Output device B) Random Only Memory
C) Read Output Memory
D) Processing device
D) None
6. Scanner is a/an:
13. RAM is a:
A) Output device
A) Non-volatile memory
B) Input device
B) Volatile memory
 C) Permanent memory C) Permanent ROM
D) Secondary memory D) Primary ROM

14. 1 KB is equal to: 21. 1 TB is equal to:

A) 1000 Bytes A) 1024 MB
B) 1024 Bytes B) 1024 GB
C) 512 Bytes C) 1000 GB
D) 2048 Bytes D) 512 GB

15. 1 MB is equal to: 22. A Nibble equals:

A) 1024 Bytes A) 8 Bits
B) 1000 KB B) 2 Bits
C) 1024 KB C) 16 Bits
D) 512 KB D) 4 Bits

16. 1 GB is equal to: NUMBER SYSTEMS

A) 1024 MB
23. Binary number system has base:
B) 1000 MB
A) 8
C) 512 MB
B) 10
D) 2048 MB
C) 2
17. 1 Byte is equal to: D) 16
A) 4 Bits
24. Hexadecimal number system
B) 16 Bits
has base:
C) 8 Bits
A) 2
D) 2 Bits
B) 8
18. Smallest unit of data in a C) 10
computer is: D) 16
A) Byte
25. Octal number system has base:
B) Nibble
A) 2
C) Bit
B) 8
D) KB
C) 10
19. Cache memory is: D) 16
A) Slowest memory
26. Binary digits are:
B) Fastest memory closest to
A) 0–9
CPU
B) 0 and 1
C) Secondary storage
C) A–F
D) ROM type
D) 0–7
20. PROM stands for:
27. 1010 in binary equals in decimal:
A) Programmable ROM
A) 8
B) Protected ROM
 B) 12 System
C) 10 D) None
D) 14 34. Booting means:
28. FF in hexadecimal equals in A) Shutting down the computer
decimal: B) Loading OS into RAM
A) 128 C) Formatting the hard drive
B) 200 D) Installing software
C) 255
35. Cold boot means:
D) 256
A) Restarting without power off
29. ASCII stands for: B) Starting from completely off
A) American Standard Code for state
Information Interchange C) Running antivirus
B) American System Code for D) None
Input
36. Warm boot means:
C) Advanced Standard Code
A) Starting from off state
D) None B) Restarting without turning off
30. 10 in binary equals in decimal:
A) 1 C) Installing OS
B) 2 D) Formatting
C) 4 37. Linux is a:
D) 10 A) Paid operating system
OPERATING SYSTEM B) Open-source operating
system
31. OS stands for:
C) Hardware
A) Output System
D) Application software
B) Operating System
C) Open System 38. Which is an example of an
D) Optical System operating system?
A) MS Word
32. GUI stands for:
B) Excel
A) Graphical User Interface
C) Windows
B) General User Interface
D) Photoshop
C) Global Unique Interface
D) None 39. Multitasking OS can:
A) Run one program at a time
33. BIOS stands for:
B) Run multiple programs
A) Basic Input Output System
simultaneously
B) Binary Input Output System
C) Only process text
C) Basic Internal Operating
D) None
 40. OS is a type of: replicates and damages files
A) Application software C) A network device
B) Hardware D) An OS
C) System software
47. Application software is:
D) Network device
A) OS
SOFTWARE B) Programs for end-user tasks
like Word and Excel
41. Compiler converts:
C) Firmware
A) Machine code to assembly
D) BIOS
B) High-level language to
machine language all at once 48. System software manages:
C) Line by line A) Only documents
D) Assembly to high level B) Computer hardware and
resources
42. Interpreter converts:
C) Internet connection
A) All code at once
D) Printing only
B) High-level to machine
language line by line NETWORKING
C) Assembly to machine
49. LAN stands for:
D) None
A) Large Area Network
43. Assembler converts: B) Local Area Network
A) High-level to machine C) Long Area Network
B) Assembly language to D) None
machine language
50. WAN stands for:
C) Machine to high-level
A) Wide Area Network
D) None
B) Wireless Area Network
44. Example of high-level language: C) Web Area Network
A) Assembly D) None
B) Machine code
51. MAN stands for:
C) Python
A) Main Area Network
D) Binary
B) Metropolitan Area Network
45. Machine language uses: C) Multiple Access Network
A) English words D) None
B) Assembly codes
52. PAN stands for:
C) Binary (0s and 1s)
A) Private Area Network
D) Hexadecimal only
B) Personal Area Network
46. A computer virus is: C) Public Area Network
A) A hardware fault D) None
B) Malicious software that
53. IP stands for: B) Broadcasts data to all
A) Internal Protocol connected devices
B) Internet Protocol C) Connects two networks
C) Input Protocol D) None
D) None
60. MAC address is:
54. TCP stands for: A) Software address
A) Transfer Control Protocol B) Unique hardware address of a
B) Transmission Control Protocol network device
C) IP address
C) Technical Control Protocol D) None
D) None
INTERNET
55. DNS stands for:
61. WWW stands for:
A) Domain Name System
A) World Wide Web
B) Data Network System
B) Wide World Web
C) Digital Name Service
C) World Web Wide
D) None
D) None
56. Router is used to:
62. URL stands for:
A) Connect devices within one
A) Universal Resource Locator
LAN
B) Uniform Resource Locator
B) Connect different networks
C) Unique Resource Link
together
D) None
C) Scan documents
D) Print files 63. HTML stands for:
A) Hyper Text Markup Language
57. Modem converts:
A) Data to images
B) High Transfer Markup
B) Digital signal to analog and
Language
vice versa
C) Hyper Transfer Markup
C) Text to binary
Language
D) None
D) None
58. Switch in networking:
64. HTTP stands for:
A) Broadcasts to all devices
A) Hyper Text Transfer Protocol
B) Sends data to specific device
in LAN
B) High Text Transfer Protocol
C) Connects to internet
C) Hyper Transfer Text Protocol
D) None
D) None
59. Hub in networking:
65. FTP stands for:
A) Sends to specific device
A) Fast Transfer Protocol
 B) File Transfer Protocol C) Data Backup Management
C) File Text Protocol System
D) None D) None

66. ISP stands for: 72. SQL stands for:

A) Internet Software Provider A) Simple Query Language
B) Internet Service Provider B) Structured Query Language
C) Internal Service Protocol
D) None C) Standard Query Logic
D) None
67. Bandwidth means:
A) Width of cable 73. A database is:
B) Data transfer capacity of a A) Random text
network B) An organized collection of data
C) Internet speed only
D) None C) A type of virus
D) Hardware
68. Wi-Fi uses:
A) Wired cables 74. File extension .exe is:
B) Wireless radio signals A) Image file
C) Optical fiber B) Executable/program file
D) Satellite only C) Word document
D) Video file
69. Bluetooth is used for:
A) Long-range communication 75. File extension .docx is:
B) Short-range wireless A) Excel file
communication B) PDF file
C) Internet access C) Microsoft Word document
D) Printing D) Image file

70. Cloud computing means: 76. File extension .pdf is:

A) Weather forecasting A) Word file
B) Storing and accessing data B) Portable Document Format
over the internet
C) Local storage C) Program file
D) None D) None

DATABASE & FILES 77. Backup means:

A) Deleting files
71. DBMS stands for: B) Copying data to protect
A) Data Base Management
against loss
System
C) Formatting drive
B) Database Management
D) None
System
 78. Encryption means: 84. Hacking means:
A) Deleting data A) Legal access to computer
B) Converting data to unreadable B) Unauthorized access to a
code for security computer system
C) Copying files C) Installing software
D) None D) None

79. Excel is used for: 85. Spyware secretly:

A) Web browsing A) Speeds up computer
B) Video editing B) Monitors and collects user
C) Spreadsheet data information
management C) Deletes viruses
D) None D) None

80. Data processing means: 86. Ransomware:

A) Storing raw data A) Improves performance
B) Converting raw data into B) Locks files and demands
useful information money to unlock
C) Deleting files C) Protects data
D) None D) None

CYBERSECURITY 87. Two-factor authentication:

A) Slows login
81. Firewall is:
B) Adds extra layer of login
A) Physical wall for servers
security
B) Security system that filters
C) Removes password
network traffic
D) None
C) Antivirus software
D) None 88. CAPTCHA is used to:
A) Encrypt data
82. Antivirus software is used to:
B) Distinguish humans from bots
A) Speed up internet
online
B) Detect and remove malicious
C) Speed up internet
software
D) None
C) Create backups
D) None 89. SSL/TLS ensures:
A) Faster internet
83. Phishing is:
B) Secure encrypted
A) A type of virus
communication over internet
B) Fraud to steal personal info via
C) Offline storage
fake emails/sites
D) None
C) Network cable
D) None
 90. A strong password should: B) Charles Babbage
A) Be your name C) Alan Turing
B) Be short and simple D) Steve Jobs
C) Mix letters, numbers, and
97. A pixel is:
symbols
A) A type of virus
D) None
B) Smallest unit of a digital image
MIXED / GENERAL
C) A storage device
91. The full form of CD-ROM is:
D) None
A) Compact Disc Read Only
Memory 98. PDF was developed by:
B) Central Disk ROM A) Microsoft
C) Computer Disk Read Only B) Apple
Memory C) Adobe
D) None D) Google
92. USB stands for: 99. Which key is used to undo in
A) Universal System Bus Windows?
B) Universal Serial Bus A) Ctrl + Z
C) Unified Serial Bus B) Ctrl + X
D) None C) Ctrl + Y
D) Ctrl + S
93. Which generation of computers
used transistors? 100. Ctrl + S is used to:
A) First A) Select all
B) Second B) Save a file
C) Third C) Cut text
D) Fourth D) Undo
94. First generation computers used: MS WORD
A) Transistors
1. MS Word is a:
B) Integrated circuits
A) Spreadsheet program
C) Vacuum tubes
B) Word processing program
D) Microprocessors
C) Presentation software
95. ENIAC was: D) Database software
A) First programming language
2. The file extension of MS Word
B) First electronic computer
2007 and later is:
C) First OS
A) .doc
D) None
B) .txt
96. The father of computers is: C) .docx
A) Bill Gates D) .ppt
3. The default file extension of older 10. Ctrl + A is used to:
MS Word 2003 is: A) Align text
A) .docx B) Select all text
B) .doc C) Add image
C) .txt D) None
D) .rtf
11. Ctrl + C is used to:
4. Ctrl + S in MS Word is used to: A) Cut
A) Select all B) Close
B) Save the document C) Copy
C) Close the file D) Create
D) Print
12. Ctrl + X is used to:
5. Ctrl + Z is used to: A) Copy
A) Redo B) Cut
B) Cut C) Exit
C) Undo D) None
D) Zoom
13. Ctrl + V is used to:
6. Ctrl + Y is used to: A) View
A) Undo B) Paste
B) Redo C) Save
C) Copy D) None
D) Paste
14. Ctrl + P is used to:
7. Ctrl + B is used to: A) Paste
A) Bookmark B) Print
B) Bold the text C) Preview
C) Break page D) None
D) None
15. Ctrl + F is used to:
8. Ctrl + I is used to: A) Format
A) Insert image B) Find text
B) Italic the text C) Font
C) Indent D) None
D) None
16. Ctrl + H is used to:
9. Ctrl + U is used to: A) Hide text
A) Undo B) Find and Replace
B) Update C) Header
C) Underline the text D) None
D) None
17. Ctrl + Home moves cursor to:
A) End of document
 B) Beginning of document 24. The default page orientation in
C) Next page MS Word is:
D) None A) Landscape
B) Portrait
18. Ctrl + End moves cursor to:
C) Horizontal
A) Beginning
D) None
B) End of document
C) Top of page 25. To change page orientation in MS
D) None Word, go to:
A) Home tab
19. To insert a page break in MS
B) Insert tab
Word, press:
C) Page Layout/Layout tab
A) Ctrl + Enter
D) View tab
B) Ctrl + B
C) Ctrl + P 26. Header appears at the:
D) Alt + Enter A) Bottom of page
B) Top of every page
20. The ruler in MS Word is used to:
C) Middle of page
A) Draw lines
D) None
B) Set margins and indents
C) Insert tables 27. Footer appears at the:
D) None A) Top of page
B) Middle of page
21. Word wrap means:
C) Bottom of every page
A) Text moves to next line
D) None
automatically
B) Text is wrapped in a box 28. Thesaurus in MS Word is used to
C) Bold text find:
D) None A) Spelling
B) Synonyms and antonyms
22. Spelling and grammar check
C) Grammar
shortcut in MS Word is:
D) None
A) F5
B) F7 29. To insert a table in MS Word, go
C) F3 to:
D) F9 A) Home tab
B) Insert tab
23. Mail Merge is used to:
C) View tab
A) Merge two files
D) Review tab
B) Send personalized letters to
many people 30. Superscript example is:
C) Format text A) H₂O
D) None B) X²
 C) Bold text C) Presentation software
D) None D) Database

31. Subscript example is: 37. The file extension of MS Excel

A) X² 2007 and later is:
B) H₂O A) .xls
C) Italic B) .xlsx
D) None C) .ppt
D) .csv
32. AutoCorrect in MS Word:
A) Deletes text 38. The intersection of a row and
B) Automatically fixes spelling column in Excel is called:
mistakes A) Table
C) Changes font B) Field
D) None C) Cell
D) Range
33. The Format Painter tool is used
to: 39. The cell address A1 means:
A) Paint images A) Row A, Column 1
B) Copy formatting from one text B) Column A, Row 1
to another C) First sheet
C) Change background D) None
D) None
40. In Excel, every formula starts
34. Word Count in MS Word is found with:
under: A) #
A) Home tab B) $
B) Insert tab C) =
C) Review tab D) @
D) View tab
41. Formula to add values in cells A1
35. To protect a Word document with to A5 is:
a password, go to: A) =ADD(A1:A5)
A) Home → Password B) =TOTAL(A1:A5)
B) File → Info → Protect Document C) =SUM(A1:A5)
D) =PLUS(A1:A5)
C) Insert → Password
42. Formula to find average of A1 to
D) None
A5 is:
MS EXCEL A) =MEAN(A1:A5)
B) =AVERAGE(A1:A5)
36. MS Excel is a:
A) Word processor C) =AVG(A1:A5)
D) None
B) Spreadsheet program
43. Formula to find maximum value C) =IFELSE(condition)
is: D) None
A) =HIGH(A1:A5)
50. VLOOKUP stands for:
B) =MAXIMUM(A1:A5)
A) Virtual Lookup
C) =MAX(A1:A5)
B) Vertical Lookup
D) None
C) Value Lookup
44. Formula to find minimum value D) None
is:
51. Charts in Excel are used to:
A) =LOW(A1:A5)
A) Format cells
B) =MIN(A1:A5)
B) Represent data visually
C) =MINIMUM(A1:A5)
C) Sort data
D) None
D) None
45. =COUNT(A1:A5) counts:
52. To freeze panes in Excel, go to:
A) Text values
A) Home tab
B) Numeric values only
B) Insert tab
C) All cells
C) View tab
D) Empty cells
D) Data tab
46. =COUNTA counts:
53. Filter in Excel is used to:
A) Only numbers
A) Format data
B) Only text
B) Display only selected rows
C) All non-empty cells
based on criteria
D) Empty cells
C) Delete rows
47. The $ sign in a cell reference like D) None
$A$1 means:
54. Sorting data in Excel means:
A) Dollar currency
A) Deleting data
B) Absolute cell reference
B) Arranging data in order A–Z or
C) Relative reference
Z–A
D) None
C) Hiding data
48. Relative cell reference means: D) None
A) Reference stays fixed
55. Pivot Table in Excel is used to:
B) Reference changes when
A) Create charts
formula is copied
B) Summarize and analyze large
C) Currency symbol
data
D) None
C) Format cells
49. IF function syntax in Excel is: D) None
A) =IF(condition, true, false)
56. Shortcut to insert a new sheet in
B) =IF(true, false) Excel:
 A) Ctrl + N 63. =UPPER("hello") returns:
B) Shift + F11 A) hello
C) Ctrl + T B) Hello
D) Alt + N C) HELLO
D) None
57. The default number of sheets in
older Excel is: 64. =LOWER("HELLO") returns:
A) 1 A) HELLO
B) 2 B) Hello
C) 3 C) hello
D) 5 D) None

58. To merge cells in Excel: 65. =CONCATENATE("MS","Excel")

A) Home → Merge & Center returns:
B) Insert → Merge A) MS Excel
C) View → Merge B) MSExcel
D) None C) MS+Excel
D) None
59. Conditional formatting in Excel is
used to: 66. #DIV/0! error in Excel means:
A) Print conditionally A) Wrong formula
B) Format cells based on their B) Division by zero
values C) Missing value
C) Hide data D) None
D) None
67. #VALUE! error in Excel means:
60. =NOW() function returns: A) Cell is empty
A) Current date only B) Wrong type of argument in
B) Current time only formula
C) Current date and time C) Division error
D) None D) None

61. =TODAY() function returns: 68. A workbook in Excel contains:

A) Current date A) One sheet only
B) Current time B) Multiple worksheets
C) Current year C) Only charts
D) None D) None

62. =LEN("HELLO") returns: 69. To protect an Excel sheet with a

A) 4 password, go to:
B) 5 A) Home → Protect
C) 6 B) Review → Protect Sheet
D) None
 C) File → Protect 76. To start a slideshow from the
D) None beginning, press:
A) F4
70. Ctrl + ; in Excel inserts:
B) F5
A) Current time
C) F7
B) Current date
D) F9
C) New row
D) None 77. To start slideshow from current
slide, press:
MS POWERPOINT
A) Shift + F5
71. MS PowerPoint is used for: B) Ctrl + F5
A) Word processing C) Alt + F5
B) Spreadsheets D) F5
C) Creating presentations
78. Slide Transition in PowerPoint
D) Database management
means:
72. The file extension of MS A) Changing slide color
PowerPoint 2007 and later is: B) Animation effect when moving
A) .ppt from one slide to next
B) .pptx C) Editing text
C) .doc D) None
D) .xls
79. Animation in PowerPoint is
73. Each page in a PowerPoint applied to:
presentation is called a: A) Entire presentation
A) Sheet B) Individual objects/text on a
B) Page slide
C) Slide C) Slide background
D) Frame D) None

74. The default view in PowerPoint is: 80. A slide layout defines:
A) Slide Sorter A) Slide color
B) Normal view B) The arrangement of
C) Reading view placeholders on a slide
D) Outline view C) Font size
D) None
75. Slide Sorter view is used to:
A) Edit individual slides 81. Slide Master in PowerPoint is
B) View and rearrange all slides used to:
at once A) Delete slides
C) Present slides B) Set a consistent design/layout
D) None for all slides
 C) Add animations B) Design
D) None C) Insert
D) View
82. To insert a new slide in
PowerPoint: 88. Slide orientation can be changed
A) Ctrl + M under:
B) Ctrl + N A) Home tab
C) Ctrl + S B) Insert tab
D) Ctrl + I C) Design tab
D) View tab
83. To duplicate a slide in
PowerPoint, right-click and 89. The Rehearse Timings feature in
select: PowerPoint is used to:
A) Copy Slide A) Set font size
B) Duplicate Slide B) Record time spent on each
C) Paste Slide slide
D) None C) Add animation
D) None
84. The Notes pane in PowerPoint is
used for: 90. To hide a slide in PowerPoint:
A) Adding slide content A) Delete it
B) Writing speaker notes B) Right-click → Hide Slide
C) Inserting images C) Move to trash
D) None D) None
85. SmartArt in PowerPoint is used 91. A theme in PowerPoint includes:
to: A) Only colors
A) Add videos B) Colors, fonts, and effects
B) Create visual diagrams and together
lists C) Only fonts
C) Draw shapes D) None
D) None
92. WordArt in PowerPoint is used to:
86. To add a hyperlink in PowerPoint, A) Add tables
press: B) Create decorative stylized text
A) Ctrl + H
B) Ctrl + K C) Insert charts
C) Ctrl + L D) None
D) Ctrl + U
93. To align objects in PowerPoint,
87. Which tab is used to insert use:
images in PowerPoint? A) Home → Align
A) Home B) Format → Align
 C) Insert → Align 99. Which key ends a slideshow in
D) None PowerPoint?
A) Enter
94. Grouping objects in PowerPoint
B) Spacebar
means:
C) Esc
A) Deleting multiple objects
D) Tab
B) Combining multiple objects to
move/resize together 100. To insert a video in
C) Hiding objects PowerPoint, go to:
D) None A) Home → Video
B) Insert → Video
95. Slide Show tab in PowerPoint
C) Design → Video
contains:
D) View → Video
A) Font options
B) Slideshow, rehearse timings,
and presenter settings
C) Insert options
D) None

96. The Outline view in PowerPoint

shows:
A) Only images
B) Text content of all slides in
outline form
C) Charts only
D) None

97. To save a presentation as PDF in

PowerPoint:
A) File → Save As → PDF
B) Insert → PDF
C) Design → Export
D) None

98. Presenter View in PowerPoint

shows:
A) Full screen to audience
B) Current slide, next slide, and
notes for presenter
C) Only notes
D) None