Computer Awareness Delhi Police Head Constable Ministerial MCQs Set 04

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

Question 1: ______ function In MS-Excel changes all the characters of the text To UpperCase.
(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.

Question 2: Which of the following command is used in MS-Word 2010 to open the file page to use backstage view?
(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.

Question 3: Which of the following is not a part of an email address?
(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.

Question 4: Which of the following keyboard shortcut is used to move the cursor up one paragraph in MS-Word 2010?
(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.

Question 5: Choose the wrong option with respect to MS-Excel 2010:
(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.

Question 6: Which of the following search engine is dominating market with maximum number of searches on it?
(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.

Question 7: In MS-Excel 2010, to select two or more non-adjacent worksheets, click the tab for first worksheet, then hold down the ______ key on your keyboard while you click the tabs of the other sheets you want to select.
(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.

Question 8: Which of the following shortcut key is used to apply superscript formatting in MS-Word 2010?
(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 + =.

Question 9: Which of the following is not an Internet etiquette?
(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.

Question 10: Which of the following MS-Excel 2010 function is used to converts a date that is stored as text to a serial number that Excel recognizes as a date?
(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

Question 1: ______ command in Web browser that helps to move to the previous page from the current page.
(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.

Question 2: In MS-Word 2010, creating a large capital letter used as a decorative element at the beginning of a paragraph or section refers to ______.
(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.

Question 3: Unsolicited and unwanted junk email sent out in bulk to an indiscriminate recipient list is stored in ______ folder.
(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.

Question 4: What is the address of the cell at the intersection of fifth row and fifth column in MS-Excel 2010?
(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.

Question 5: Consider the following statements about HTML
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.

Question 6: When contents of a cell in a worksheet of MS-Excel 2010 are being edited, the cell number is displayed in ______.
(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.

Question 7: Instead of retyping the same text in MS-Word 2010, we can use ______ to reduce time and effort.
(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.

Question 8: Which of the following is a function in MS-Excel 2010?
(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.

Question 9: In MS-Word 2010, the Page Down key is used to:
(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.

Question 10: Which one of the following is a wrong declaration in MS-Excel 2010?
(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

Question 1: In MS Word, the function key F12 is used to ______.
(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.

Question 2: A table in MS-Word 2010 can have unlimited rows and a maximum of ______ columns.
(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.

Question 3: What is the value of the following expression in MS-Excel 2010?
= 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.

Question 4: Which of the following is not a word processor?
(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.

Question 5: You can choose to create a ______ that will appear at the end of every email we send.
(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.

Question 6: Match the following list of domain names with their meanings
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.

Question 7: ______ is used in MS-Excel 2010 to open an already existing file.
(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.

Question 8: Header and Footer option is present in ______ tab in MS-Excel 2010 ribbon bar.
(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.

Question 9: What is the minimum Zoom Percentage in MS-Word 2010 application?
(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.

Question 10: Bing is a/an ______.
(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

Question 1: Hathway is an ______.
(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.

Question 2: Flipkart is one of the leading e-commerce marketplaces in India. It belongs to segment:
(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.

Question 3: In MS-Excel 2010, ______ operation is used to save an already saved file under a different name.
(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.

Question 4: ______ shortcut key is used in MS-Excel 2010 to open the review tab.
(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.

Question 5: Consider the following statements:
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.

Question 6: ______ tab in MS-Excel 2010 ribbon bar allows you to check spelling, track changes, add comments and notes, protect worksheets and workbooks.
(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.

Question 7: Which of the following statement is correct about the use of Blind Carbon Copy (BCC) in Gmail?
(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.

Question 8: In paragraph formatting of MS-Word 2010, Ctrl + Q is used for which of the following purpose?
(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.

Question 9: ______ function in MS-Excel 2010 capitalizes the first letter in each word of a text value.
(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.

Question 10: ______ tab in MS-Excel 2010 ribbon bar provides commands for switching between worksheet views, freezing panes, viewing and arranging multiple windows.
(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.

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

Where can I access latest Computer Awareness Delhi Police Head Constable Ministerial MCQs Set 04?

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.

Are Assertion-Reasoning and Case-Study MCQs included in the Computer Science [current-page:node:field_class] material?

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.

How do practicing Computer Science MCQs help in scoring full marks in [current-page:node:field_class] exams?

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.

Do you provide answers and explanations for Computer Awareness Delhi Police Head Constable Ministerial MCQs Set 04?

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.

Can I practice these Computer Science [current-page:node:field_class] MCQs online?

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.