Download NCERT MCQs for Computer Science: Miscellaneous
Review structured MCQ sets for Computer Science Miscellaneous. Built according to official NCERT guidelines, these downloadable questions support daily revision and core concept reinforcement.
Chapter-wise Objective Questions: Miscellaneous
Navigate directly to the 50 objective questions for Miscellaneous using the digital viewer below. Each practice set includes verified answer keys, allowing students to instantly cross-check their work and identify areas requiring further revision.
Computer questions from the Delhi Police Head Constable AWO TPO exam held on 27 and 28 October 2022, six shifts of ten questions each with answers and explanations. They cover MS-Word 2010 and MS-Excel 2010 features and shortcuts, e-mail addresses, web browsers, search engines and Internet basics.
27 October 2022, Shift 1
(a) New
(b) Save As
(c) Open
(d) Save
Show Answer & Explanation
Answer: (a) New
Explanation:
1. The New option in the File tab creates a fresh workbook.
2. Open is for an existing file and Save As stores a copy under another name.
Teacher's Note:
1. File tab: New = create, Open = existing.
(a) Print Purview
(b) Print Review
(c) Print Balance
(d) Print Preview
Show Answer & Explanation
Answer: (d) Print Preview
Explanation:
1. Print Preview shows how the page will look when printed so settings can be corrected first.
2. The other three names do not exist.
Teacher's Note:
1. Preview before you print.
(a) World Wide Web
(b) World Web Wide
(c) Web Wide World
(d) World Word Web
Show Answer & Explanation
Answer: (a) World Wide Web
Explanation:
1. WWW is the World Wide Web, the system of linked pages on the Internet.
Teacher's Note:
1. Only one sensible order: World Wide Web.
(a) Page Size
(b) Collated
(c) Orientation
(d) Copies
Show Answer & Explanation
Answer: (d) Copies
Explanation:
1. The Copies box in the Print pane sets how many copies are printed.
2. Collated, orientation and page size control arrangement, not number.
Teacher's Note:
1. Copies = count.
(a) Sheets
(b) Gmail
(c) Twitter
(d) Chrome
Show Answer & Explanation
Answer: (d) Chrome
Explanation:
1. Chrome is a web browser used to open websites.
2. Sheets is a spreadsheet app, Gmail is a mail service and Twitter is a social site.
Teacher's Note:
1. Browsers: Chrome, Firefox, Edge, Safari, Opera.
(a) Find
(b) Conditional formatting
(c) Format
(d) Cut
Show Answer & Explanation
Answer: (b) Conditional formatting
Explanation:
1. Conditional formatting changes the look of cells automatically when conditions are met.
Teacher's Note:
1. Condition + format = conditional formatting.
(a) Alt + Ctrl + T
(b) Shift + T
(c) Ctrl + T
(d) Alt + Shift + T
Show Answer & Explanation
Answer: (c) Ctrl + T
Explanation:
1. Ctrl + T (or Ctrl + L) opens the Create Table dialog box for the selected range.
Teacher's Note:
1. T for Table.
(a) Formula bar
(b) Column headings
(c) Row headings
(d) Name box
Show Answer & Explanation
Answer: (d) Name box
Explanation:
1. The Name box, at the left of the formula bar, shows the address of the active cell.
2. The formula bar shows the cell's content.
Teacher's Note:
1. Name box = address, Formula bar = content.
(a) Abc.gmail@com
(b) abc@gmail.com
(c) abc@gmail@com
(d) abc.gmail.com
Show Answer & Explanation
Answer: (b) abc@gmail.com
Explanation:
1. A valid address has exactly one @ with a user name before it and a domain after it, such as abc@gmail.com.
Teacher's Note:
1. User name @ domain name.
(a) Eraser
(b) Split Cells
(c) Merge Cells
(d) Delete
Show Answer & Explanation
Answer: (a) Eraser
Explanation:
1. The Eraser tool in the Draw Borders group deletes a chosen border line, which merges the cells on either side.
Teacher's Note:
1. Eraser = rubs out borders.
27 October 2022, Shift 2
(a) Ctrl + C
(b) Ctrl + X
(c) Ctrl + V
(d) Ctrl + Z
Show Answer & Explanation
Answer: (d) Ctrl + Z
Explanation:
1. Ctrl + Z reverses the last action.
2. C copies, X cuts and V pastes.
Teacher's Note:
1. Z = zap the last change.
(a) H,J
(b) H::J
(c) H:J
(d) H-J
Show Answer & Explanation
Answer: (c) H:J
Explanation:
1. A colon creates a range, so H:J covers every cell in columns H, I and J.
Teacher's Note:
1. Colon = range.
(a) Ctrl + Z
(b) Ctrl + V
(c) Ctrl + O
(d) Ctrl + X
Show Answer & Explanation
Answer: (d) Ctrl + X
Explanation:
1. Ctrl + X removes the selection and keeps it on the clipboard.
Teacher's Note:
1. X looks like scissors.
(a) Ctrl + Alt + V then press V
(b) Shift + V then press V
(c) Ctrl + Shift + V then press V
(d) Alt + V then press V
Show Answer & Explanation
Answer: (a) Ctrl + Alt + V then press V
Explanation:
1. Ctrl + Alt + V opens Paste Special, and pressing V then selects Values.
Teacher's Note:
1. Paste Special = Ctrl + Alt + V.
(a) AVRG
(b) AVG
(c) MEAN
(d) AVERAGE
Show Answer & Explanation
Answer: (d) AVERAGE
Explanation:
1. AVERAGE is the built-in function, as in =AVERAGE(A1:A5).
Teacher's Note:
1. Excel uses the full word AVERAGE.
(a) Webpage
(b) Web browser
(c) Web server
(d) Search engine
Show Answer & Explanation
Answer: (c) Web server
Explanation:
1. A web server stores website files and delivers them to browsers.
Teacher's Note:
1. Server hosts, browser displays.
(a) Access providers
(b) Mailbox provider
(c) Virtual ISPs
(d) Hosting ISPs
Show Answer & Explanation
Answer: (a) Access providers
Explanation:
1. Access providers give users the connection to the Internet through such media.
Teacher's Note:
1. Access = connection.
(a) mixed column
(b) relative
(c) mixed row
(d) absolute
Show Answer & Explanation
Answer: (d) absolute
Explanation:
1. $ fixes the column and row of a reference, making it absolute.
Teacher's Note:
1. $ locks the reference.
(a) Subject
(b) Add text
(c) Bcc
(d) Cc
Show Answer & Explanation
Answer: (c) Bcc
Explanation:
1. Bcc (blind carbon copy) hides the other recipients' addresses.
2. Cc shows all addresses.
Teacher's Note:
1. Bcc = blind.
(a) sheet
(b) table
(c) graph
(d) cell
Show Answer & Explanation
Answer: (c) graph
Explanation:
1. A graph (chart) shows worksheet data visually.
Teacher's Note:
1. Chart/graph = picture of data.
27 October 2022, Shift 3
(a) WWW
(b) blog
(c) magazine
(d) website
Show Answer & Explanation
Answer: (b) blog
Explanation:
1. A blog is an informal, regularly updated web page.
Teacher's Note:
1. Blog = web log.
(a) .com
(b) .co.in
(c) .ac.in
(d) .in
Show Answer & Explanation
Answer: (a) .com
Explanation:
1. The .com domain is open to everyone and is used worldwide.
2. The others are tied to India.
Teacher's Note:
1. com = commercial, global.
(a) The prefix appears to the left of the @ symbol.
(b) The domain appears to the right of the @ symbol.
(c) A valid e-mail address consists of an e-mail prefix and an e-mail domain, both in acceptable formats.
(d) The domain appears to the left of the @ symbol.
Show Answer & Explanation
Answer: (d) The domain appears to the left of the @ symbol.
Explanation:
1. The domain comes after the @ sign, so saying it appears on the left is wrong.
Teacher's Note:
1. Prefix @ domain.
(a) CONCATENATE
(b) CON
(c) STRING
(d) ADD
Show Answer & Explanation
Answer: (a) CONCATENATE
Explanation:
1. CONCATENATE joins text strings together.
Teacher's Note:
1. Concatenate = join.
(a) Delete All Formatting
(b) Clear Selection
(c) Clear All Formatting
(d) Remove Selection
Show Answer & Explanation
Answer: (c) Clear All Formatting
Explanation:
1. Clear All Formatting in the Font group removes the formatting from the selected text.
Teacher's Note:
1. Clear All Formatting = plain text.
(a) Save
(b) Paste
(c) Filter
(d) Table
Show Answer & Explanation
Answer: (c) Filter
Explanation:
1. Sort and Filter are found in the Data tab.
2. Paste is in Home and Table is in Insert.
Teacher's Note:
1. Data tab: sort, filter, remove duplicates.
(a) Circular clockwise arrow
(b) Paintbrush
(c) Clipboard
(d) Curved arrow pointing left
Show Answer & Explanation
Answer: (d) Curved arrow pointing left
Explanation:
1. Undo is shown as a curved arrow pointing to the left; redo points to the right.
2. The paintbrush is Format Painter and the clipboard is Paste.
Teacher's Note:
1. Undo goes back, so the arrow points back.
(a) Filter
(b) Add
(c) Find
(d) Sort
Show Answer & Explanation
Answer: (d) Sort
Explanation:
1. The SORT function returns the sorted contents of a range or array.
Teacher's Note:
1. SORT sorts.
(a) Taskbar
(b) Status bar
(c) Scroll bar
(d) Quick Access toolbar
Show Answer & Explanation
Answer: (d) Quick Access toolbar
Explanation:
1. The Quick Access Toolbar sits at the top left and holds shortcuts such as Save and Undo.
Teacher's Note:
1. QAT = quick shortcuts.
(a) Alt + F2
(b) Shift + F3
(c) Alt + F3
(d) Ctrl + F2
Show Answer & Explanation
Answer: (d) Ctrl + F2
Explanation:
1. Ctrl + F2 opens the print preview.
Teacher's Note:
1. Ctrl + P and Ctrl + F2 both show print preview.
28 October 2022, Shift 1
(a) Yahoo
(b) Google
(c) Amazon
(d) Microsoft
Show Answer & Explanation
Answer: (d) Microsoft
Explanation:
1. Bing is the search engine of Microsoft.
Teacher's Note:
1. Bing = Microsoft.
(a) Ctrl + Spacebar
(b) Alt + Spacebar
(c) Shift + Spacebar
(d) Ctrl + Alt + Spacebar
Show Answer & Explanation
Answer: (c) Shift + Spacebar
Explanation:
1. Shift + Spacebar selects the whole row and Ctrl + Spacebar selects the whole column.
Teacher's Note:
1. Shift = row, Ctrl = column.
(a) F4
(b) Alt + '-'
(c) Shift + '-'
(d) Ctrl + '-'
Show Answer & Explanation
Answer: (d) Ctrl + '-'
Explanation:
1. Ctrl + minus opens the Delete dialog box.
Teacher's Note:
1. Ctrl + - delete, Ctrl + + insert.
(a) Yandex
(b) Bing
(c) Google
(d) Gmail
Show Answer & Explanation
Answer: (d) Gmail
Explanation:
1. Gmail is an e-mail service, not a search engine.
Teacher's Note:
1. Search engines find web pages.
(a) Column Copy
(b) Copy Column
(c) Copy Carbon
(d) Carbon Copy
Show Answer & Explanation
Answer: (d) Carbon Copy
Explanation:
1. Cc means Carbon Copy.
Teacher's Note:
1. Cc = carbon copy, Bcc = blind carbon copy.
(a) Align Left
(b) Justify
(c) Align Center
(d) Align Right
Show Answer & Explanation
Answer: (c) Align Center
Explanation:
1. Ctrl + E centres the paragraph.
2. Left is Ctrl + L, right is Ctrl + R and justify is Ctrl + J.
Teacher's Note:
1. E for centrE.
(a) Ctrl + O
(b) Ctrl + Z
(c) Ctrl + X
(d) Ctrl + V
Show Answer & Explanation
Answer: (b) Ctrl + Z
Explanation:
1. Ctrl + Z undoes the last action.
Teacher's Note:
1. Z = undo.
(a) 290
(b) 297
(c) 292
(d) 291
Show Answer & Explanation
Answer: (d) 291
Explanation:
1. Sum = 300 + 225 + 180 + 350 + 400 = 1455 and 1455 / 5 = 291.
Teacher's Note:
1. Average = sum / count.
(a) CREATE
(b) GENERATE
(c) RAND
(d) RANDOM
Show Answer & Explanation
Answer: (c) RAND
Explanation:
1. Typing =rand() and pressing Enter fills the document with sample text.
Teacher's Note:
1. =rand() gives dummy text, =lorem() gives Latin text.
(a) Task bar
(b) Status bar
(c) Title bar
(d) Tool bar
Show Answer & Explanation
Answer: (b) Status bar
Explanation:
1. The status bar at the bottom shows mode such as Ready or Edit and key states like Caps Lock.
Teacher's Note:
1. Status bar = status.
28 October 2022, Shift 2
(a) A10-E20
(b) A10:E20
(c) 10A-20E
(d) 10A:30E
Show Answer & Explanation
Answer: (b) A10:E20
Explanation:
1. A range is written as the top-left cell, a colon, and the bottom-right cell: A10:E20.
Teacher's Note:
1. Cell format is column letter then row number.
(a) Layout
(b) Help
(c) Home
(d) File
Show Answer & Explanation
Answer: (d) File
Explanation:
1. Open is in the File tab (Backstage view).
Teacher's Note:
1. File tab = New, Open, Save, Print.
(a) United Resource Locator
(b) Uniform Resource Locator
(c) United Resource Logo
(d) Uniform Resource Logo
Show Answer & Explanation
Answer: (b) Uniform Resource Locator
Explanation:
1. URL = Uniform Resource Locator.
Teacher's Note:
1. U-R-L: Uniform Resource Locator.
(a) Alt + Shift + F
(b) Ctrl + Alt + F
(c) Ctrl + Shift + F
(d) Ctrl + F
Show Answer & Explanation
Answer: (c) Ctrl + Shift + F
Explanation:
1. Ctrl + Shift + F opens the Format Cells dialog box (Ctrl + 1 also does).
2. Ctrl + F opens Find.
Teacher's Note:
1. Format Cells: Ctrl + 1 or Ctrl + Shift + F.
(a) httss
(b) https
(c) httsp
(d) http
Show Answer & Explanation
Answer: (b) https
Explanation:
1. https shows that the connection is secure (HTTP with SSL/TLS).
Teacher's Note:
1. S in https = secure.
(a) Review
(b) View
(c) Insert
(d) Data
Show Answer & Explanation
Answer: (d) Data
Explanation:
1. Remove Duplicates is in the Data Tools group of the Data tab.
Teacher's Note:
1. Data tab handles data cleaning.
(a) PROPER case
(b) TITLE case
(c) LOWER case
(d) UPPER case
Show Answer & Explanation
Answer: (a) PROPER case
Explanation:
1. PROPER capitalises the first letter of every word.
Teacher's Note:
1. PROPER = Title Case.
(a) Ctrl + O
(b) Ctrl + N
(c) Ctrl + H
(d) Ctrl + S
Show Answer & Explanation
Answer: (b) Ctrl + N
Explanation:
1. Ctrl + N opens a new blank workbook.
Teacher's Note:
1. N = new.
(a) 9a9b9e@yahoo.com
(b) 989bcd@yahoo.com
(c) abc123@yahoo.com
(d) abc123@$yahoo.com
Show Answer & Explanation
Answer: (d) abc123@$yahoo.com
Explanation:
1. A $ sign is not allowed in a domain name, so the last address is invalid.
Teacher's Note:
1. Domains use letters, digits and hyphens only.
(a) document
(b) spreadsheet
(c) Text
(d) slide
Show Answer & Explanation
Answer: (b) spreadsheet
Explanation:
1. A spreadsheet is a grid of rows and columns of cells.
Teacher's Note:
1. Rows and columns = spreadsheet.
28 October 2022, Shift 3
(a) File Type Protocol
(b) File Transfer Protocol
(c) File Transit Protocol
(d) File Telnet Protocol
Show Answer & Explanation
Answer: (b) File Transfer Protocol
Explanation:
1. FTP = File Transfer Protocol.
Teacher's Note:
1. FTP moves files between computers.
(a) Status bar
(b) Task bar
(c) Title bar
(d) Tool bar
Show Answer & Explanation
Answer: (c) Title bar
Explanation:
1. The title bar at the top shows the file name.
Teacher's Note:
1. Title bar = name.
(a) Ctrl + B
(b) Ctrl + U
(c) Ctrl + X
(d) Ctrl + I
Show Answer & Explanation
Answer: (a) Ctrl + B
Explanation:
1. Ctrl + B applies bold.
2. U is underline and I is italic.
Teacher's Note:
1. B = bold.
(a) F4
(b) F3
(c) F1
(d) F2
Show Answer & Explanation
Answer: (d) F2
Explanation:
1. F2 enters edit mode with the cursor at the end of the contents.
Teacher's Note:
1. F2 = edit.
(a) PROPER
(b) TEXT
(c) LOWER
(d) UPPER
Show Answer & Explanation
Answer: (c) LOWER
Explanation:
1. LOWER converts every letter to lowercase.
Teacher's Note:
1. LOWER, UPPER, PROPER.
(a) Coolspots
(b) Hotspots
(c) Wireless connection
(d) Broadband
Show Answer & Explanation
Answer: (a) Coolspots
Explanation:
1. Hotspots, wireless connections and broadband are ways to get online; 'Coolspots' is not an access method.
Teacher's Note:
1. Access methods: dial-up, broadband, Wi-Fi hotspot, mobile data.
(a) Open
(b) Save As
(c) Save
(d) New
Show Answer & Explanation
Answer: (b) Save As
Explanation:
1. Save As stores the work under a new name or location, leaving the original unchanged.
Teacher's Note:
1. Save As = new copy.
(a) NPER
(b) NOW
(c) NPV
(d) NOT
Show Answer & Explanation
Answer: (b) NOW
Explanation:
1. NOW returns the current date and time.
Teacher's Note:
1. NOW = now.
(a) Paste Special
(b) Paste Control
(c) Paste Details
(d) Paste Design
Show Answer & Explanation
Answer: (a) Paste Special
Explanation:
1. Paste Special lets you choose the format in which the clipboard content is pasted.
Teacher's Note:
1. Paste Special = choose the paste type.
(a) Body
(b) Signature
(c) subject line
(d) meta data
Show Answer & Explanation
Answer: (c) subject line
Explanation:
1. The subject line is the one-line summary shown in the inbox list.
Teacher's Note:
1. Subject line = title of the mail.
Free study material for Computer Science
Miscellaneous Objective Questions & Solutions for Computer Science
Chapter MCQs with Answers for Computer Science
Test your conceptual understanding of Miscellaneous with these targeted multiple-choice questions. Designed in alignment with the latest NCERT curriculum for Computer Science, these problem sets build accuracy and prepare students for objective exams.
Expert Practice Material for Computer Science
Cross-reference your completed choices with comprehensive NCERT solutions for Computer Science to ensure absolute clarity across all sub-topics in this chapter.
Complete Your Chapter Revision
Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.
FAQs
You can get most exhaustive Computer Awareness Delhi Police Head Constable AWO TPO MCQs Set 01 for free on StudiesToday.com. These MCQs for Computer Science are updated for the 2026-27 academic session as per examination standards.
Yes, our Computer Awareness Delhi Police Head Constable AWO TPO MCQs Set 01 include the latest type of questions, such as Assertion-Reasoning and Case-based MCQs. 50% of the paper is now competency-based.
By solving our Computer Awareness Delhi Police Head Constable AWO TPO MCQs Set 01, students can improve their accuracy and speed which is important as objective questions provide a chance to secure 100% marks in the Computer Science.
Yes, Computer Science MCQs for have answer key and brief explanations to help students understand logic behind the correct option as its important for 2026 competency-focused exams.
Yes, you can also access online interactive tests for Computer Awareness Delhi Police Head Constable AWO TPO MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.