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
Access the complete set of multiple-choice questions for Miscellaneous below. This focused format allows students to isolate specific topics for thorough review and uninterrupted practice alongside official NCERT textbooks.
Solved computer questions from the Delhi Police Head Constable (Ministerial) shifts of 17 and 18 October 2022. You will find questions on Excel formulas and operator order, Word table limits, domain names, HTML statements and e-mail etiquette.
17 October 2022, Shift 1
(a) PROPER
(b) LOWER
(c) LEN
(d) UPPER
Show Answer & Explanation
Answer: (d) UPPER
Explanation:
1. UPPER converts all letters to capitals.
2. LOWER gives small letters and PROPER capitalises each word.
Teacher's Note:
1. UPPER, LOWER and PROPER change case.
2. LEN counts characters.
(a) Alt + G
(b) Alt + H
(c) Alt + C
(d) Alt + F
Show Answer & Explanation
Answer: (d) Alt + F
Explanation:
1. Alt + F opens the File tab with the Backstage view.
2. Alt + H opens the Home tab.
Teacher's Note:
1. F for File.
2. Backstage holds Save, Print and Options.
(a) Username
(b) User domain
(c) Email provider's domain
(d) @ Symbol
Show Answer & Explanation
Answer: (b) User domain
Explanation:
1. An email address has the username, the @ symbol and the provider's domain name.
2. User domain is not a separate part.
Teacher's Note:
1. Username at domain name.
2. There is no user domain part.
(a) Ctrl + Right arrow key
(b) Ctrl + Up arrow key
(c) Ctrl + Down arrow key
(d) Ctrl + Left arrow key
Show Answer & Explanation
Answer: (b) Ctrl + Up arrow key
Explanation:
1. Ctrl + Up arrow moves the cursor to the start of the previous paragraph.
2. Ctrl + Down arrow moves to the next paragraph.
Teacher's Note:
1. Ctrl with Left or Right moves by word, with Up or Down moves by paragraph.
2. Ctrl + Home goes to the document start.
(a) In MS-Excel 2010, we can insert a table from the insert tab
(b) In MS-Excel 2010, we can save the file by using F2
(c) In MS-Excel 2010, we can insert comments to a cell
(d) In MS-Excel 2010, to open an existing file Ctrl+O is used
Show Answer & Explanation
Answer: (b) In MS-Excel 2010, we can save the file by using F2
Explanation:
1. F2 puts a cell in edit mode and does not save.
2. Saving uses Ctrl + S, and F12 is Save As.
Teacher's Note:
1. F2 is edit.
2. The wrong statement is the one with the function key.
(a) Ask.com
(b) Google
(c) Yahoo
(d) Bing
Show Answer & Explanation
Answer: (b) Google
Explanation:
1. Google handles most of the world's web searches.
2. Bing and Yahoo have much smaller shares.
Teacher's Note:
1. Google leads search by a huge margin.
2. Bing is Microsoft's engine.
(a) Tab
(b) Esc
(c) Alt
(d) Ctrl
Show Answer & Explanation
Answer: (d) Ctrl
Explanation:
1. Ctrl lets you pick separate sheet tabs one by one.
2. Shift would select a continuous run of sheets.
Teacher's Note:
1. Ctrl for scattered, Shift for continuous.
2. The same rule works for files.
(a) Ctrl + Shift + >
(b) Ctrl + Shift + =
(c) Ctrl + Shift + +
(d) Ctrl + Shift + <
Show Answer & Explanation
Answer: (c) Ctrl + Shift + +
Explanation:
1. Superscript is applied with Ctrl + Shift + Plus (the plus sign key).
2. Subscript uses Ctrl + = and Ctrl + Shift + > changes font size.
Teacher's Note:
1. Super equals Ctrl + Shift + Plus, sub equals Ctrl + Equal.
2. The edited option 2 is now plain Ctrl + =.
(a) Size of attachments need to be small
(b) Including name at the bottom of mails
(c) Using abbreviations wisely
(d) Forwarding unwanted messages
Show Answer & Explanation
Answer: (d) Forwarding unwanted messages
Explanation:
1. Good etiquette keeps attachments small, signs the mail and uses abbreviations sensibly.
2. Forwarding unwanted messages is bad behaviour.
Teacher's Note:
1. Do not spread chain mails and spam.
2. Netiquette means polite online behaviour.
(a) DATEVALUE()
(b) NETWORKDAYS()
(c) EDATE()
(d) TODAY()
Show Answer & Explanation
Answer: (a) DATEVALUE()
Explanation:
1. DATEVALUE changes a date written as text into a serial number.
2. NETWORKDAYS counts working days and EDATE shifts months.
Teacher's Note:
1. DATEVALUE gives the date number, TIMEVALUE gives the time fraction.
2. Format the result as a date.
17 October 2022, Shift 2
(a) Create
(b) Back
(c) Save
(d) Forward
Show Answer & Explanation
Answer: (b) Back
Explanation:
1. Back returns to the page visited before.
2. Forward moves to the page after it.
Teacher's Note:
1. Back goes to the previous page.
2. Alt + Left arrow is the shortcut.
(a) Watermark
(b) Drop Cap
(c) Smart Art
(d) Header
Show Answer & Explanation
Answer: (b) Drop Cap
Explanation:
1. A drop cap is a large first letter dropping into the paragraph.
2. A watermark is faint text behind the page.
Teacher's Note:
1. Drop Cap is on the Insert tab.
2. Seen at the start of magazine articles.
(a) trash
(b) inbox
(c) spam
(d) draft
Show Answer & Explanation
Answer: (c) spam
Explanation:
1. Junk bulk mail is filtered into the Spam folder.
2. Trash holds deleted mails.
Teacher's Note:
1. Spam equals junk mail.
2. Do not click links in spam.
(a) E5
(b) $E5$
(c) $E$5
(d) 5E
Show Answer & Explanation
Answer: (a) E5
Explanation:
1. The fifth column is E and the fifth row is 5, so the cell is E5.
2. The other options are not the plain address.
Teacher's Note:
1. Column letter first, then row number.
2. Fifth column is E.
P: HTML was designed to store and transport data
Q: All HTML documents must start with a document type declaration: <!DOCTYPE html>
R: HTML is the standard markup language for Web pages.
Which of these statement(s) is/are correct?
(a) Only P and Q
(b) All P, Q, R
(c) Only Q
(d) Only Q and R
Show Answer & Explanation
Answer: (d) Only Q and R
Explanation:
1. HTML is the standard markup language for web pages, and documents start with the doctype declaration.
2. Storing and transporting data is the job of XML, so P is wrong.
Teacher's Note:
1. HTML displays data, XML transports data.
2. <!DOCTYPE html> opens an HTML5 page.
(a) status bar
(b) formula bar
(c) name box
(d) ribbon
Show Answer & Explanation
Answer: (c) 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 content.
Teacher's Note:
1. Name Box shows the address, formula bar shows the content.
2. You can type a cell name there to jump.
(a) cut + copy
(b) copy + paste
(c) paste + undo
(d) copy + undo
Show Answer & Explanation
Answer: (b) copy + paste
Explanation:
1. Copy then paste repeats the same text without typing it again.
2. Cut removes the original text.
Teacher's Note:
1. Copy plus paste duplicates.
2. Cut plus paste moves.
(a) ADD
(b) FORMULA
(c) SUM
(d) RANGE
Show Answer & Explanation
Answer: (c) SUM
Explanation:
1. SUM is a built-in function that adds numbers.
2. ADD, FORMULA and RANGE are not Excel functions.
Teacher's Note:
1. Functions are named formulas like SUM and AVERAGE.
2. There is no ADD function.
(a) move the cursor one line down.
(b) move the cursor one paragraph down.
(c) move the cursor in the last page when the document contains multiple pages.
(d) move the cursor one screen down.
Show Answer & Explanation
Answer: (d) move the cursor one screen down.
Explanation:
1. Page Down moves the cursor down by one screen.
2. Ctrl + Down arrow moves one paragraph.
Teacher's Note:
1. Page Down is a screen at a time.
2. Ctrl + End goes to the document end.
(a) =TIMEVALUE("9/7/2022 6:35 AM")
(b) =TIMEVALUE("22-Aug-2011 6:35 AM")
(c) =TIMEVALUE("2:24 AM")
(d) =TIMEVALUE("Wednesday, September 7,2022 6:35 AM")
Show Answer & Explanation
Answer: (d) =TIMEVALUE("Wednesday, September 7,2022 6:35 AM")
Explanation:
1. TIMEVALUE accepts a date and time text in a recognised format or time alone.
2. Text with the weekday name and no proper spacing is not recognised and gives #VALUE!.
Teacher's Note:
1. TIMEVALUE returns the time as a decimal between 0 and 1.
2. The date part is ignored.
17 October 2022, Shift 3
(a) Close the working window.
(b) Open next working window.
(c) Open the File Menu.
(d) Open the Save As dialog box.
Show Answer & Explanation
Answer: (d) Open the Save As dialog box.
Explanation:
1. F12 opens the Save As dialog box in Word.
2. Ctrl + W closes and Alt + F opens the File menu.
Teacher's Note:
1. F12 equals Save As.
2. Same key in Excel.
(a) 63
(b) 61
(c) 64
(d) 62
Show Answer & Explanation
Answer: (a) 63
Explanation:
1. A Word table can have up to 63 columns.
2. The number of rows is not limited.
Teacher's Note:
1. Word table: 63 columns.
2. Excel sheet has 16,384 columns.
= 22 - 12 / 3 / 2 + 4
(a) 8
(b) 26
(c) 20
(d) 24
Show Answer & Explanation
Answer: (d) 24
Explanation:
1. Division goes first, left to right: 12 / 3 = 4 and 4 / 2 = 2.
2. Then 22 - 2 + 4 = 24.
Teacher's Note:
1. Division comes before addition and subtraction.
2. Then work left to right.
(a) LibreOffice Writer
(b) Microsoft Word
(c) Notepad
(d) Chrome
Show Answer & Explanation
Answer: (d) Chrome
Explanation:
1. Writer and Word are word processors, and Notepad is a text editor.
2. Chrome is a web browser, so it is not a word processor at all.
Teacher's Note:
1. Chrome is a browser.
2. Word processors create formatted documents.
(a) Subject
(b) Formatting options
(c) Signature
(d) Attachments
Show Answer & Explanation
Answer: (c) Signature
Explanation:
1. A signature is text added automatically to the end of each outgoing mail.
2. Subject and attachments are set for each mail.
Teacher's Note:
1. Signature equals auto text at the end.
2. Usually name and contact details.
Domain Name: P. .net, Q. .edu, R. .org, S. .com
Meaning: 1. Non-profit organizations, 2. Commercial organizations, 3. Educational organizations, 4. Indicates state and national government agencies, 5. Department of Defense, 6. Network organization
(a) P-5, Q-1, R-2, S-4
(b) P-6, Q-3, R-1, S-2
(c) P-6, Q-2, R-4, S-2
(d) P-1, Q-3, R-4, S-2
Show Answer & Explanation
Answer: (b) P-6, Q-3, R-1, S-2
Explanation:
1. net means network organization (6), edu means educational (3), org means non-profit (1) and com means commercial (2).
2. So the match is P-6, Q-3, R-1, S-2.
Teacher's Note:
1. gov is government and mil is military.
2. org is non-profit, com is commercial.
(a) OPEN
(b) SAVE
(c) NEW
(d) SAVE AS
Show Answer & Explanation
Answer: (a) OPEN
Explanation:
1. Open loads a saved workbook.
2. New creates a blank workbook.
Teacher's Note:
1. Open is Ctrl + O.
2. Save As saves under a new name.
(a) Insert
(b) Data
(c) File
(d) View
Show Answer & Explanation
Answer: (a) Insert
Explanation:
1. Header and Footer is in the Text group of the Insert tab.
2. Data, File and View tabs do not hold it.
Teacher's Note:
1. Insert tab holds Header and Footer.
2. Page Layout has Print Titles instead.
(a) 5%
(b) 10%
(c) 15%
(d) 25%
Show Answer & Explanation
Answer: (b) 10%
Explanation:
1. Word 2010 zoom goes from 10% to 500%.
2. So the minimum is 10%.
Teacher's Note:
1. Word zoom 10% to 500%, Excel zoom 10% to 400%.
2. Both have the same minimum.
(a) Internet service provider
(b) Social network site
(c) Browser
(d) Search engine
Show Answer & Explanation
Answer: (d) Search engine
Explanation:
1. Bing is a search engine from Microsoft.
2. It is not a browser or an ISP.
Teacher's Note:
1. Bing equals Microsoft search.
2. Edge is the browser.
18 October 2022, Shift 1
(a) Social network site
(b) Internet service provider
(c) Search engine
(d) Browser
Show Answer & Explanation
Answer: (b) Internet service provider
Explanation:
1. Hathway is a company that provides broadband internet connections.
2. Hence it is an Internet service provider.
Teacher's Note:
1. ISP examples are Hathway, Airtel and Jio.
2. An ISP gives internet access.
(a) Government to Consumer
(b) Business to Government
(c) Government to Business
(d) Business to Consumer
Show Answer & Explanation
Answer: (d) Business to Consumer
Explanation:
1. Flipkart sells goods from businesses to ordinary customers.
2. That is the Business to Consumer (B2C) model.
Teacher's Note:
1. B2C equals shopping sites.
2. B2B is business to business.
(a) SAVE
(b) NEW
(c) SAVE AS
(d) OPEN
Show Answer & Explanation
Answer: (c) SAVE AS
Explanation:
1. Save As stores a copy under a new name or location.
2. Save updates the same file.
Teacher's Note:
1. Save As equals F12.
2. The original file stays unchanged.
(a) ALT + I
(b) ALT + A
(c) ALT + R
(d) ALT + N
Show Answer & Explanation
Answer: (c) ALT + R
Explanation:
1. Alt + R opens the Review tab.
2. Alt + A is Data and Alt + N is Insert.
Teacher's Note:
1. R for Review.
2. Alt + W is View.
P: Double-click the cell that contains the data that you want to edit.
Q: Click the cell that contains the data that you want to edit, and then press F2.
R: Click the cell that contains the data that you want to edit, and then press Shift Key.
S: Click the cell that contains the data that you want to edit, and then press Ctrl Key.
Which of the following statements are correct about starting to work in edit mode of MS-Excel 2010 worksheet?
(a) Only P
(b) Only P, Q, R
(c) All P, Q, R, S
(d) Only P, Q
Show Answer & Explanation
Answer: (d) Only P, Q
Explanation:
1. Double-clicking a cell or pressing F2 starts edit mode.
2. Pressing only Shift or Ctrl does not.
Teacher's Note:
1. Edit mode equals double-click or F2.
2. Modifier keys alone do nothing.
(a) FILE
(b) FORMULA
(c) REVIEW
(d) DATA
Show Answer & Explanation
Answer: (c) REVIEW
Explanation:
1. The Review tab has Proofing, Comments and Changes groups.
2. It lets you protect sheets and workbooks.
Teacher's Note:
1. Review equals proofing and comments.
2. Alt + R opens it.
(a) It is used for sharing a copy of the email with 100 primary recipients.
(b) It is used for sharing a copy of the email with all the primary recipients.
(c) It is used for sharing a copy of the email with 10 primary recipients.
(d) It is used for sharing a copy of the email with someone without letting the primary recipient know about it.
Show Answer & Explanation
Answer: (d) It is used for sharing a copy of the email with someone without letting the primary recipient know about it.
Explanation:
1. Bcc sends a copy to people whose addresses stay hidden from the other recipients.
2. Other options talk about numbers of recipients, which is not the point.
Teacher's Note:
1. Bcc is blind, so others cannot see it.
2. Cc is visible to everyone.
(a) Open Apply Style task pane
(b) Remove paragraph indentation
(c) Change the paragraph spacing to double line
(d) Remove paragraph formatting of highlighted paragraph.
Show Answer & Explanation
Answer: (d) Remove paragraph formatting of highlighted paragraph.
Explanation:
1. Ctrl + Q removes manual paragraph formatting and returns the paragraph to its style.
2. Ctrl + Shift + S opens the Apply Styles pane and Ctrl + 2 gives double spacing.
Teacher's Note:
1. Q for quit formatting.
2. Ctrl + Space clears character formatting.
(a) UPPER
(b) LOWER
(c) LEN
(d) PROPER
Show Answer & Explanation
Answer: (d) PROPER
Explanation:
1. PROPER makes the first letter of each word a capital and the rest small.
2. UPPER makes all letters capital.
Teacher's Note:
1. PROPER gives title case.
2. =PROPER("new delhi") gives New Delhi.
(a) VIEW
(b) REVIEW
(c) FORMULA
(d) HOME
Show Answer & Explanation
Answer: (a) VIEW
Explanation:
1. The View tab has Workbook Views, Zoom and Window groups.
2. Freeze Panes and Arrange All are under Window.
Teacher's Note:
1. View equals views, zoom and windows.
2. Alt + W opens it.
Free study material for Computer Science
Miscellaneous Objective Questions & Solutions for Computer Science
Chapter MCQs with Answers for Computer Science
Review structured objective questions for Computer Science Miscellaneous. Built according to official NCERT guidelines, these MCQ sets support daily revision and core concept reinforcement.
Expert Practice Material for Computer Science
Built using the official NCERT book for , these Computer Science objective sets provide reliable academic guidance. Pair your practice with our recommended NCERT solutions to master optimal problem-solving approaches.
Complete Your Chapter Revision
Explore our broader library of printable assignments, chapter notes, and mock tests designed to support continuous revision and secure higher marks in NCERT assessments.
FAQs
You can get most exhaustive Computer Awareness Delhi Police Head Constable Ministerial MCQs Set 04 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 Ministerial MCQs Set 04 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 Ministerial MCQs Set 04, 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 Ministerial MCQs Set 04 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.