Universal IT Computer Education
MS-CIT |Advanced Tally Prime With GST |Advanced.Excel |Desktop Publishing |Graphic Designing | Web Design |Photo Editing |Hardware&Networking

Basic Computer Fundamentals

Basic Computer Fundamentals Questions and Answers

MS Word – Multiple Choice Questions

1. MS Word is a ______ software.
A) Spreadsheet
B) Presentation
C) Word Processing
D) Database

2. Default file extension of MS Word is:
A) .xls
B) .pptx
C) .docx
D) .txt

3. Which feature is used to check spelling errors?
A) Grammar
B) Spell Check
C) Word Count
D) Track Changes

4. Shortcut key to save a document is:
A) Ctrl + P
B) Ctrl + S
C) Ctrl + N
D) Ctrl + O

5. Which option is used to change page orientation?
A) Margins
B) Size
C) Orientation
D) Columns

6. Header and Footer are found under which tab?
A) Insert
B) View
C) Layout
D) Home

7. Which shortcut is used to select all text?
A) Ctrl + A
B) Ctrl + C
C) Ctrl + X
D) Ctrl + V

8. Which view shows the document as it will appear when printed?
A) Draft View
B) Outline View
C) Print Layout
D) Web Layout

9. Which feature is used to combine letters with addresses?
A) Mail Merge
B) Macros
C) Templates
D) References

10. Which tab contains Font and Paragraph groups?
A) Insert
B) Design
C) Home
D) Review

11. Which key is used to move to the next line?
A) Shift
B) Ctrl
C) Enter
D) Tab

12. Bullets and numbering option is found under:
A) Insert
B) Home
C) Layout
D) Review

13. Which option is used to find a word in a document?
A) Replace
B) Find
C) Select
D) Zoom

14. Shortcut key to copy text is:
A) Ctrl + V
B) Ctrl + X
C) Ctrl + C
D) Ctrl + Z

15. Which feature tracks changes made to a document?
A) Track Changes
B) Comments
C) Compare
D) Protect

16. Which tab is used to insert tables?
A) Home
B) Insert
C) Layout
D) References

17. Which option is used to add page numbers?
A) Header
B) Footer
C) Page Number
D) Symbol

18. Which alignment centers the text?
A) Left
B) Right
C) Justify
D) Center

19. Which shortcut key is used to undo an action?
A) Ctrl + Y
B) Ctrl + Z
C) Ctrl + A
D) Ctrl + D

20. Which feature inserts pre-designed documents?
A) Macros
B) Templates
C) Styles
D) Themes

21. Which tab contains spelling and grammar tools?
A) Home
B) Insert
C) Review
D) View

22. Which option is used to change font size?
A) Font Color
B) Grow Font
C) Shrink Font
D) Font Size

23. Which key deletes text to the right of cursor?
A) Backspace
B) Delete
C) Enter
D) Shift

24. Which feature protects a document from editing?
A) Encrypt
B) Protect Document
C) Restrict Access
D) Track Changes

25. Which view is best for reading documents?
A) Draft
B) Read Mode
C) Outline
D) Web Layout

26. Which option changes line spacing?
A) Indent
B) Spacing
C) Line & Paragraph Spacing
D) Margins

27. Which tool highlights selected text?
A) Font Color
B) Text Highlight Color
C) Bold
D) Italic

28. Which option inserts symbols?
A) Insert → Symbol
B) Home → Font
C) View → Zoom
D) Layout → Size

29. Which key combination prints a document?
A) Ctrl + S
B) Ctrl + O
C) Ctrl + P
D) Ctrl + N

30. Which feature checks word count?
A) Review
B) Word Count
C) Spelling
D) Translate

31. Which option is used to insert images?
A) Insert → Pictures
B) Home → Paste
C) View → Image
D) Layout → Picture

32. Which formatting makes text slanted?
A) Bold
B) Underline
C) Italic
D) Highlight

33. Which option creates columns in a document?
A) Margins
B) Columns
C) Breaks
D) Indent

34. Which feature adds comments to a document?
A) Track Changes
B) New Comment
C) Compare
D) Protect

35. Which tab is used to insert citations?
A) References
B) Review
C) Insert
D) Design

36. Which option removes formatting?
A) Clear Formatting
B) Styles
C) Themes
D) Font Color

37. Which shortcut key opens a new document?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + W

38. Which option zooms the document view?
A) Scale
B) Zoom
C) View Size
D) Layout

39. Which option inserts a table of contents?
A) Insert
B) References
C) Review
D) View

40. Which key combination closes MS Word?
A) Ctrl + Q
B) Alt + F4
C) Ctrl + W
D) Alt + Tab

MS Excel – Multiple Choice Questions

01.MS Excel is a ______ software.
A) Word Processing
B) Spreadsheet
C) Presentation
D) Database

02.Default file extension of MS Excel is:
A) .docx
B) .pptx
C) .xlsx
D) .txt

03.What is the intersection of a row and a column called?
A) Cell
B) Range
C) Worksheet
D) Workbook

04.Which symbol is used to start a formula in Excel?
A) +
B) =
C) –
D) *

05.Shortcut key to save a workbook is:
A) Ctrl + P
B) Ctrl + S
C) Ctrl + N
D) Ctrl + O

06.Which function is used to find the average?
A) SUM()
B) COUNT()
C) AVERAGE()
D) MAX()

07.Which function returns the largest value?
A) MIN()
B) MAX()
C) COUNT()
D) SUM()

08.Which tool separates data into multiple columns instantly?
A) Fill Handle
B) Text to Columns
C) Filtering
D) Sorting

09.How many rows are there in Excel (modern versions)?
A) 65,536
B) 1,048,576
C) 10,000
D) 1,000,000

10.How many columns are there in Excel (modern versions)?
A) 256
B) 1,024
C) 16,384
D) 8,192

11.Which function counts numeric values?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) SUM()

12.Which function counts non-empty cells?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) SUM()

13.Which key is used to edit a cell?
A) F1
B) F2
C) F5
D) F12

14.Which chart shows data as parts of a whole?
A) Bar Chart
B) Line Chart
C) Pie Chart
D) Area Chart

15.Which feature keeps row headings visible while scrolling?
A) Freeze Panes
B) Split
C) Hide
D) Group

16.Which function is used to count based on a condition?
A) COUNT()
B) COUNTIF()
C) SUM()
D) IF()

17.Which option is used to sort data alphabetically?
A) Filter
B) Sort
C) Format
D) Validate

18.Which function is used to perform logical tests?
A) SUM()
B) IF()
C) AND()
D) OR()

19.Which key combination selects the entire worksheet?
A) Ctrl + A
B) Ctrl + C
C) Ctrl + X
D) Ctrl + Z

20.Which feature prevents others from editing cells?
A) Hide
B) Protect Sheet
C) Filter
D) Validate

21.Which function returns the smallest value?
A) MAX()
B) MIN()
C) COUNT()
D) AVERAGE()

22.Which feature allows conditional formatting?
A) Format Painter
B) Cell Styles
C) Conditional Formatting
D) Themes

23.Which function combines text from multiple cells?
A) JOIN()
B) MERGE()
C) CONCAT()
D) TEXT()

24.Which option is used to insert a new worksheet?
A) Insert Sheet
B) Add Sheet
C) New Sheet
D) Worksheet

25.Which shortcut key opens the Find dialog box?
A) Ctrl + F
B) Ctrl + H
C) Ctrl + G
D) Ctrl + R

26.Which feature displays data graphically?
A) Table
B) Chart
C) Formula
D) Filter

27.Which function rounds a number?
A) ROUND()
B) FIX()
C) TRUNC()
D) INT()

28.Which key deletes selected cells?
A) Backspace
B) Delete
C) Esc
D) Enter

29.Which option is used to apply borders to cells?
A) Fill Color
B) Font Color
C) Borders
D) Styles

30.Which tab contains formulas in Excel?
A) Home
B) Insert
C) Formulas
D) Data

31.Which function returns today’s date?
A) NOW()
B) DATE()
C) TODAY()
D) TIME()

32.Which feature allows data validation?
A) Filter
B) Sort
C) Data Validation
D) Protect

33.Which shortcut key copies selected cells?
A) Ctrl + X
B) Ctrl + V
C) Ctrl + C
D) Ctrl + Z

34.Which function is used to sum selected cells?
A) ADD()
B) SUM()
C) TOTAL()
D) PLUS()

35.Which feature groups rows or columns?
A) Freeze
B) Group
C) Sort
D) Filter

36.Which option hides rows or columns?
A) Delete
B) Hide
C) Protect
D) Group

37.Which tab is used to import external data?
A) Home
B) Insert
C) Data
D) View

38.Which function converts text to lowercase?
A) LOWER()
B) UPPER()
C) PROPER()
D) TEXT()

39.Which shortcut key opens Save As dialog?
A) F2
B) F5
C) F12
D) F1

40.Which feature removes duplicate values?
A) Filter
B) Sort
C) Remove Duplicates
D) Validate

MS Power Point – Multiple Choice Questions

01.MS PowerPoint is a ______ software.
A) Spreadsheet
B) Word Processing
C) Presentation
D) Database

02.Default file extension of MS PowerPoint is:
A) .docx
B) .xlsx
C) .pptx
D) .txt

03.Which view is used to deliver a presentation?
A) Normal View
B) Slide Sorter View
C) Reading View
D) Slide Show View

04.Which shortcut key starts a slide show from the beginning?
A) F2
B) F5
C) F7
D) Ctrl + F5

05.Which option is used to insert a new slide?
A) New Slide
B) Duplicate Slide
C) Layout
D) Section

06.Which tab contains animation effects?
A) Home
B) Insert
C) Animations
D) Slide Show

07.Which view shows all slides as thumbnails?
A) Normal View
B) Slide Sorter View
C) Reading View
D) Notes View

08.Which feature applies design to all slides?
A) Theme
B) Layout
C) Transition
D) Animation

09.Which option adds movement between slides?
A) Animation
B) Transition
C) Theme
D) Layout

10.Which key ends a slide show?
A) Enter
B) Esc
C) Backspace
D) Delete

11.Which tab is used to insert pictures?
A) Home
B) Insert
C) Design
D) View

12.Which feature controls the order of animations?
A) Animation Pane
B) Selection Pane
C) Slide Sorter
D) Rehearse Timings

13.Which view is used to rearrange slides easily?
A) Normal View
B) Notes View
C) Slide Sorter View
D) Reading View

14.Which option inserts speaker notes?
A) Notes Pane
B) Comments
C) Header & Footer
D) Text Box

15.Which shortcut duplicates a slide?
A) Ctrl + D
B) Ctrl + C
C) Ctrl + V
D) Ctrl + N

16.Which feature adds sound to a slide?
A) Insert → Audio
B) Design → Audio
C) View → Sound
D) Home → Audio

17.Which tab contains slide size settings?
A) Home
B) Insert
C) Design
D) View

18.Which object is used to add text?
A) Picture
B) Shape
C) Text Box
D) SmartArt

19.Which option runs the slide show from current slide?
A) F5
B) Shift + F5
C) Ctrl + F5
D) Alt + F5

20.Which feature aligns objects on a slide?
A) Arrange
B) Align
C) Group
D) Order

21.Which option inserts charts?
A) Insert → Chart
B) Design → Chart
C) Home → Chart
D) View → Chart

22.Which tab is used to rehearse timings?
A) Review
B) Slide Show
C) View
D) Animations

23.Which feature records narration?
A) Record Slide Show
B) Rehearse Timings
C) Animation Pane
D) Notes

24.Which option changes background color?
A) Format Background
B) Theme
C) Layout
D) Design Ideas

25.Which feature groups multiple objects?
A) Align
B) Group
C) Order
D) Arrange

26.Which shortcut saves a presentation?
A) Ctrl + P
B) Ctrl + S
C) Ctrl + N
D) Ctrl + O

27.Which option inserts video?
A) Insert → Video
B) Home → Video
C) Design → Video
D) View → Video

28.Which feature adds visual hierarchy diagrams?
A) Shapes
B) SmartArt
C) Charts
D) Icons

29.Which option hides a slide during presentation?
A) Delete Slide
B) Hide Slide
C) Skip Slide
D) Remove Slide

30.Which view allows editing slide notes?
A) Normal View
B) Notes View
C) Reading View
D) Slide Sorter

31.Which feature changes text direction?
A) Rotate
B) Text Direction
C) Align
D) Format Painter

32.Which option applies animation to text or objects?
A) Transitions
B) Animations
C) Themes
D) Layouts

33.Which key moves to the next slide in slide show?
A) Esc
B) Enter
C) Ctrl
D) Shift

34.Which feature checks spelling errors?
A) Spell Check
B) Review Pane
C) Translate
D) Comments

35.Which tab contains comments?
A) Home
B) Insert
C) Review
D) View

36.Which feature removes animation?
A) Clear Animation
B) Remove Effect
C) None
D) Delete

37.Which option changes slide layout?
A) Design
B) Layout
C) Theme
D) Transition

38.Which feature adds icons?
A) Insert → Icons
B) Design → Icons
C) Home → Icons
D) View → Icons

39.Which option zooms slides during presentation?
A) Slide Zoom
B) Zoom Tool
C) Magnifier
D) Scale

40.Which option prints handouts?
A) Print Layout
B) Handout Master
C) Print → Handouts
D) Notes Master

Internet Multiple Choice Questions

01.The Internet is a ______.
A) Single network
B) Network of networks 
C) LAN
D) MAN

02.Which device connects a computer to the Internet?
A) Router
B) Modem 
C) Switch
D) Hub

03.Which protocol is used to access websites?
A) FTP
B) SMTP
C) HTTP 
D) POP3

04.What does WWW stand for?
A) World Wide Web 
B) Web World Wide
C) Wide World Web
D) World Web Wide

05.Which web browser is developed by Google?
A) Firefox
B) Edge
C) Chrome 
D) Safari

06.Which symbol is used in an email address?
A) #
B) @ 
C) $
D) %

07.Which service is used to send emails?
A) FTP
B) SMTP 
C) HTTP
D) DNS

08.Which protocol is used to receive emails?
A) SMTP
B) HTTP
C) POP3 
D) FTP

09.What is a URL?
A) Uniform Resource Locator 
B) Universal Resource Link
C) Uniform Record Locator
D) Universal Record Link

10.Which device forwards data packets between networks?
A) Hub
B) Switch
C) Router 
D) Repeater

11.Which search engine is most widely used?
A) Yahoo
B) Bing
C) DuckDuckGo
D) Google 

12.Which protocol translates domain names to IP addresses?
A) HTTP
B) FTP
C) DNS 
D) SMTP

13.What does ISP stand for?
A) Internet Service Provider 
B) International Service Provider
C) Internet System Protocol
D) Internal Service Program

14.Which of the following is a web browser?
A) Google
B) Yahoo
C) Chrome 
D) Gmail

15.Which extension represents a commercial website?
A) .gov
B) .edu
C) .com 
D) .org

16.Which is an example of a social networking site?
A) Wikipedia
B) Facebook 
C) Google
D) Yahoo

17.Which protocol is used to transfer files?
A) SMTP
B) FTP 
C) HTTP
D) POP3

18.Which type of malware displays unwanted ads?
A) Virus
B) Worm
C) Adware 
D) Spyware

19.Which term refers to online crime?
A) Cybercrime 
B) E-crime
C) Netcrime
D) Webcrime

20.Which device improves Wi-Fi coverage?
A) Repeater 
B) Router
C) Modem
D) Switch

21.Which browser is developed by Mozilla?
A) Chrome
B) Safari
C) Firefox 
D) Edge

22.Which email service is provided by Google?
A) Yahoo Mail
B) Outlook
C) Gmail 
D) Rediffmail

23.Which of these is a cloud storage service?
A) Google Drive 
B) Chrome
C) Gmail
D) YouTube

24.What does HTTPS indicate?
A) Fast website
B) Secure website 
C) Free website
D) Private website

25.Which key refreshes a web page?
A) F2
B) F5 
C) F7
D) F12

26.Which symbol is used to refresh a web page?
A) ↻ 
B) ✖
C) ★
D) ☰

27.Which is NOT a web browser?
A) Chrome
B) Firefox
C) Opera
D) Google 

28.Which service allows video sharing?
A) Facebook
B) YouTube
C) Instagram
D) All of these 

29.Which term means copying data without permission?
A) Hacking 
B) Phishing
C) Spamming
D) Browsing

30.Which of these is used for online chatting?
A) Email
B) Instant Messaging 
C) FTP
D) DNS

31.Which site is used for online shopping?
A) Amazon 
B) Wikipedia
C) Google
D) YouTube

32.Which term refers to junk emails?
A) Spam 
B) Trash
C) Virus
D) Malware

33.Which protocol is used for secure file transfer?
A) FTP
B) SFTP 
C) HTTP
D) POP3

34.Which feature blocks unwanted websites?
A) Firewall 
B) Antivirus
C) Router
D) Browser

35.Which is a video conferencing application?
A) Zoom 
B) Chrome
C) Google
D) Yahoo

36.Which technology allows wireless Internet access?
A) LAN
B) WAN
C) Wi-Fi 
D) Ethernet

37.Which is an example of an IP address?
A) www.google.com
B) 192.168.1.1 
C) google@com
D) http://

38.Which Internet service is used to download files?
A) Email
B) FTP 
C) Chat
D) DNS

39.Which extension is used for government websites?
A) .edu
B) .org
C) .gov 
D) .com

40.Which term means protecting data from unauthorized access?
A) Encryption 
B) Hacking
C) Spamming
D) Browsing

Comments are closed, but trackbacks and pingbacks are open.