Computer Awareness Delhi Police Constable Executive 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

View or download the dedicated Miscellaneous MCQ resource below. Practicing these 50 objective questions regularly builds familiarity with standard exam patterns and helps secure higher marks in final Computer Science evaluations.

Delhi Police Constable Executive computer questions from the 11 and 14 December 2020 shifts with answers. You will find questions on Word and Excel ribbon tabs, keyboard shortcuts, TCP/IP, SMTP and date and time functions.

9 December 2020, Shift 2

Question 1: Which of the following functions in MS-Excel 2007 returns an absolute value of a number, that is, a number without a sign?
(a) ASIN
(b) ACOS
(c) AND
(d) ABS
Show Answer & Explanation

Answer: (d) ABS

Explanation:
1. ABS returns the absolute value of a number.

Teacher's Note:
1. ABS(-5) = 5.

Question 2: Which of the following is the keyboard shortcut to cut the selected text or graphics, storing them on the clipboard in an MS-Word document?
(a) Ctrl + V
(b) Ctrl + S
(c) Ctrl + X
(d) Ctrl + C
Show Answer & Explanation

Answer: (c) Ctrl + X

Explanation:
1. Ctrl + X cuts the selection to the clipboard.

Teacher's Note:
1. X = cut.

Question 3: Which of the following sequences is used in MS-Word 2007 to go to the print preview option?
(a) Home > print > print preview
(b) Office button > print > print preview
(c) Office button > print preview > print
(d) Home > print preview > print
Show Answer & Explanation

Answer: (b) Office button > print > print preview

Explanation:
1. In Word 2007 the path is Office Button, then Print, then Print Preview.

Teacher's Note:
1. Word 2007 uses the Office Button, not the File tab.

Question 4: Which of the following options is generally used to view and manage e-mails received?
(a) Inbox
(b) Sent items
(c) Compose
(d) Attachment
Show Answer & Explanation

Answer: (a) Inbox

Explanation:
1. The Inbox holds incoming mail.

Teacher's Note:
1. Inbox = incoming.

Question 5: Which of the following services is most commonly used with mobile phones to access the Internet?
(a) DSL
(b) 3G-4G
(c) Dial up
(d) Cable
Show Answer & Explanation

Answer: (b) 3G-4G

Explanation:
1. Mobile phones mainly connect through 3G, 4G (and now 5G) data networks.

Teacher's Note:
1. Mobile = 3G/4G.

Question 6: Which of the following cell references is default in MS-Excel?
(a) Relative
(b) Active
(c) Absolute
(d) Mixed
Show Answer & Explanation

Answer: (a) Relative

Explanation:
1. New references are relative by default, and they change when copied.

Teacher's Note:
1. $ makes it absolute.

Question 7: Which of the following belongs to the 'Effects' category with reference to text formatting in MS-Word?
(a) Bold
(b) Regular
(c) Italic
(d) Strike through
Show Answer & Explanation

Answer: (d) Strike through

Explanation:
1. Strikethrough is an effect in the Font dialog box, while bold, regular and italic are font styles.

Teacher's Note:
1. Effects: strikethrough, superscript, subscript, small caps.

Question 8: What is the full form of HTTP with reference to Internet protocols?
(a) Hyper Track Transfer Protocol
(b) Higher Text Transfer Protocol
(c) Hyper Text Transitive Protocol
(d) Hyper Text Transfer Protocol
Show Answer & Explanation

Answer: (d) Hyper Text Transfer Protocol

Explanation:
1. HTTP = Hyper Text Transfer Protocol.

Teacher's Note:
1. HTTP carries web pages.

Question 9: Which of the following is used to separate a workbook into specific worksheets in MS-Excel?
(a) Formula bar
(b) Navigation buttons
(c) Name box
(d) Sheet tabs
Show Answer & Explanation

Answer: (d) Sheet tabs

Explanation:
1. Sheet tabs at the bottom let you work with the separate worksheets of a workbook.

Teacher's Note:
1. Sheet tabs = sheets.

Question 10: Which of the following features in MS-Word is used to create a link to a picture, program, web page or e-mail address?
(a) SmartArt
(b) Bookmark
(c) Hyperlink
(d) Cross-reference
Show Answer & Explanation

Answer: (c) Hyperlink

Explanation:
1. A hyperlink links to another file, web page or e-mail address.

Teacher's Note:
1. Ctrl + K inserts a hyperlink.

9 December 2020, Shift 3

Question 11: Match the following domain name extensions with their respective definitions. 1) .gov 2) .org 3) .edu 4) .net. A) Government agencies B) Network organisations C) Non-profit organisations D) Educational organisations
(a) 1-A, 2-D, 3-C, 4-B
(b) 1-A, 2-C, 3-D, 4-B
(c) 1-C, 2-A, 3-D, 4-B
(d) 1-D, 2-C, 3-A, 4-B
Show Answer & Explanation

Answer: (b) 1-A, 2-C, 3-D, 4-B

Explanation:
1. .gov is for government, .org for non-profit organisations, .edu for education and .net for network organisations.

Teacher's Note:
1. gov = government, edu = education.

Question 12: What is the maximum height of a row in MS-Excel 2010?
(a) 128 points
(b) 409 points
(c) 255 points
(d) 100 points
Show Answer & Explanation

Answer: (b) 409 points

Explanation:
1. A row can be up to 409 points high.

Teacher's Note:
1. Row height max 409, column width max 255.

Question 13: In MS-Excel 2010, a cell may display '______' if that cell contains a number or a date and the width of its column cannot display all the characters that its format requires.
(a) **###
(b) #####
(c) $$$$$
(d) *****
Show Answer & Explanation

Answer: (b) #####

Explanation:
1. A row of hash signs (#####) means the column is too narrow.

Teacher's Note:
1. Widen the column to fix #####.

Question 14: In MS-Word, Ctrl + R is used to align the text to the ______ of the screen.
(a) right
(b) bottom
(c) top
(d) left
Show Answer & Explanation

Answer: (a) right

Explanation:
1. Ctrl + R right-aligns the paragraph.

Teacher's Note:
1. L, E, R, J = left, centre, right, justify.

Question 15: To add a watermark in an MS-Word 2010 document, one has to click on the '______' tab and then select the 'Watermark' option provided in the '______' group.
(a) Page Layout, Page Background
(b) Layout, Page Background
(c) Insert, Page Background
(d) View, Page Background
Show Answer & Explanation

Answer: (a) Page Layout, Page Background

Explanation:
1. Watermark is in the Page Background group of the Page Layout tab in Word 2010.

Teacher's Note:
1. Page Layout > Page Background > Watermark.

Question 16: What is the value of the following MS-Excel formula? =SUMSQ(1, 2, 3, 4)
(a) 30
(b) 10
(c) 34
(d) 24
Show Answer & Explanation

Answer: (a) 30

Explanation:
1. SUMSQ adds the squares: 1 + 4 + 9 + 16 = 30.

Teacher's Note:
1. SUMSQ = sum of squares.

Question 17: Which of the following keyboard shortcuts is used to run Spelling and Grammar Check in MS-Word 2010?
(a) F1
(b) F2
(c) F7
(d) F9
Show Answer & Explanation

Answer: (c) F7

Explanation:
1. F7 starts Spelling and Grammar.

Teacher's Note:
1. F7 = spelling.

Question 18: The option of Spell Check can be selected from the ______ tab in MS-Excel 2007.
(a) Formula
(b) File
(c) Review
(d) Help
Show Answer & Explanation

Answer: (c) Review

Explanation:
1. Spelling is in the Proofing group of the Review tab.

Teacher's Note:
1. Review = proofing.

Question 19: Which of the following keyboard shortcuts is used for closing an MS-Word 2010 document?
(a) Ctrl + N
(b) Ctrl + W
(c) Ctrl + E
(d) Ctrl + O
Show Answer & Explanation

Answer: (b) Ctrl + W

Explanation:
1. Ctrl + W closes the document.

Teacher's Note:
1. W closes the window.

Question 20: Pick the odd one out.
(a) Mozilla
(b) Safari
(c) Internet Explorer
(d) File Explorer
Show Answer & Explanation

Answer: (d) File Explorer

Explanation:
1. Mozilla, Safari and Internet Explorer are web browsers, while File Explorer manages files on the computer.

Teacher's Note:
1. File Explorer is not a web browser.

10 December 2020, Shift 2

Question 21: Which of the following categories of functions does NOT exist in MS-Excel?
(a) Logical
(b) Text
(c) Scientific
(d) Financial
Show Answer & Explanation

Answer: (c) Scientific

Explanation:
1. Excel has Logical, Text, Financial and other categories, but no Scientific category.

Teacher's Note:
1. Categories: Financial, Logical, Text, Date and Time, Math & Trig...

Question 22: Which of the following tabs in MS-Word has the 'Table' option that is used to insert a table?
(a) Page Layout
(b) Home
(c) References
(d) Insert
Show Answer & Explanation

Answer: (d) Insert

Explanation:
1. Tables are inserted from the Insert tab.

Teacher's Note:
1. Insert = table, picture, shapes.

Question 23: Which of the following keyboard shortcuts is used to open the Print option in MS-Word?
(a) Ctrl + F
(b) Ctrl + S
(c) Ctrl + N
(d) Ctrl + P
Show Answer & Explanation

Answer: (d) Ctrl + P

Explanation:
1. Ctrl + P opens the print options.

Teacher's Note:
1. P = print.

Question 24: Which of the following keys on a QWERTY keyboard is/are used to move the cursor up or down one screen at a time in MS-Excel?
(a) Insert
(b) Home and End
(c) Shift
(d) Page Up and Page Down
Show Answer & Explanation

Answer: (d) Page Up and Page Down

Explanation:
1. Page Up and Page Down scroll the worksheet one screen up or down.

Teacher's Note:
1. Page Up/Down = screen scroll.

Question 25: Which of the following was the first ever search engine to be developed?
(a) Archie
(b) Bing
(c) Yahoo
(d) Google
Show Answer & Explanation

Answer: (a) Archie

Explanation:
1. Archie (1990) was the first Internet search tool.

Teacher's Note:
1. Archie came first.

Question 26: The computer or server on the Internet is also known as ______.
(a) IP address
(b) host
(c) URL address
(d) Address
Show Answer & Explanation

Answer: (b) host

Explanation:
1. A computer connected to the Internet is called a host.

Teacher's Note:
1. Host = computer on a network.

Question 27: Which of the following e-mail address fields contains a brief summary of the content of the e-mail but is not mandatory while composing the e-mail?
(a) Content
(b) Subject
(c) From
(d) To
Show Answer & Explanation

Answer: (b) Subject

Explanation:
1. The subject line summarises the mail and can be left blank.

Teacher's Note:
1. Subject = summary.

Question 28: Which of the following is a temporary storage area for data that a user wants to copy from one place to another in MS-Word?
(a) Task bar
(b) System tray
(c) Clipboard
(d) Word document
Show Answer & Explanation

Answer: (c) Clipboard

Explanation:
1. The clipboard holds cut or copied data until it is pasted.

Teacher's Note:
1. Clipboard = temporary holder.

Question 29: The process of making the worksheet data look more presentable and attractive by changing its appearance in MS-Excel is called ______.
(a) modifying
(b) editing
(c) formatting
(d) Decorating
Show Answer & Explanation

Answer: (c) formatting

Explanation:
1. Changing the appearance of data is formatting.

Teacher's Note:
1. Formatting = appearance.

Question 30: What is the maximum font size that can be selected from the font size drop-down list in MS-Word 2007?
(a) 78
(b) 56
(c) 72
(d) 36
Show Answer & Explanation

Answer: (c) 72

Explanation:
1. The list runs up to 72 points.

Teacher's Note:
1. Drop-down list: 8 to 72.

11 December 2020, Shift 1

Question 31: What is the maximum number of rows in an MS-Excel 2010 worksheet?
(a) 1,048,576
(b) 16,384
(c) 16,000
(d) 1,048,500
Show Answer & Explanation

Answer: (a) 1,048,576

Explanation:
1. Excel 2007 and later have 1,048,576 rows (220) and 16,384 columns.

Teacher's Note:
1. Rows 2^20, columns 2^14.

Question 32: Match the following keyboard shortcuts of MS-Word 2010 with their functions. (a) Italic, (b) Decrease font size by 1 point, (c) Increase font size by 1 point; (x) Ctrl + [, (y) Ctrl + ], (z) Ctrl + I
(a) a-y, b-z, c-x
(b) a-x, b-y, c-z
(c) a-z, b-x, c-y
(d) a-z, b-y, c-x
Show Answer & Explanation

Answer: (c) a-z, b-x, c-y

Explanation:
1. Ctrl + I gives italic, Ctrl + [ decreases the size by 1 point and Ctrl + ] increases it by 1 point.

Teacher's Note:
1. Left bracket = smaller, right bracket = larger.

Question 33: Which of the following buttons CANNOT be found in the Clipboard pane in MS-Word 2010?
(a) Clear All
(b) Options
(c) Ok
(d) Paste All
Show Answer & Explanation

Answer: (c) Ok

Explanation:
1. The Clipboard pane has Paste All, Clear All and Options, but no Ok button.

Teacher's Note:
1. Clipboard pane: Paste All, Clear All, Options.

Question 34: Match the following protocols with their descriptions. 1. HTTP 2. FTP 3. Telnet. A. Used to log in over a TCP/IP connection. B. This protocol is used for transferring files in the Internet and within private networks. C. It is the application protocol for distributed and collaborative hypermedia information systems.
(a) 1-B, 2-A, 3-C
(b) 1-A, 2-C, 3-B
(c) 1-C, 2-B, 3-A
(d) 1-A, 2-B, 3-C
Show Answer & Explanation

Answer: (c) 1-C, 2-B, 3-A

Explanation:
1. HTTP is the hypermedia protocol (C), FTP transfers files (B) and Telnet is used to log in remotely (A).

Teacher's Note:
1. HTTP = web, FTP = files, Telnet = remote login.

Question 35: When you right-click and select the 'Format Cells' option in MS-Excel 2010, which of the following tabs is NOT visible?
(a) Font
(b) Border
(c) Alignment
(d) Sheet
Show Answer & Explanation

Answer: (d) Sheet

Explanation:
1. The Format Cells dialog box has Number, Alignment, Font, Border, Fill and Protection tabs, but no Sheet tab.

Teacher's Note:
1. Sheet tab belongs to Page Setup.

Question 36: What will be the value of the following MS-Excel formula? =AVERAGEA(5, 4, 4>3, 6)
(a) 5
(b) ERROR
(c) 3.72
(d) 4
Show Answer & Explanation

Answer: (d) 4

Explanation:
1. AVERAGEA counts TRUE as 1, so (5 + 4 + 1 + 6) / 4 = 16 / 4 = 4.

Teacher's Note:
1. AVERAGEA counts logical values: TRUE = 1.

Question 37: What do you call the distance between written text and the edge of a paper?
(a) Indent Stop
(b) Alignment
(c) Ruler Line
(d) Margin
Show Answer & Explanation

Answer: (d) Margin

Explanation:
1. The margin is the blank space between the text and the page edge.

Teacher's Note:
1. Margin = border space.

Question 38: Which of the following tabs is used to enable the 'Ruler' option in MS-Word 2010?
(a) Page Layout
(b) View
(c) Design
(d) Review
Show Answer & Explanation

Answer: (b) View

Explanation:
1. The Ruler check box is in the Show group of the View tab.

Teacher's Note:
1. View = ruler, gridlines, navigation pane.

Question 39: The electronic pages seen on the Internet are known as ______.
(a) printed pages
(b) colour pages
(c) web pages
(d) hard copy
Show Answer & Explanation

Answer: (c) web pages

Explanation:
1. Pages displayed on the Internet are web pages.

Teacher's Note:
1. Web pages form websites.

Question 40: Which of the following is mandatory for sending an e-mail?
(a) Sender mail ID
(b) Subject
(c) Attachment
(d) Body
Show Answer & Explanation

Answer: (a) Sender mail ID

Explanation:
1. A message cannot be sent without an address, whereas subject, attachment and body can be left empty.

Teacher's Note:
1. Subject, body and attachment are optional.

11 December 2020, Shift 2

Question 41: Which of the following is used to move the active cell to the first column of the current row?
(a) Page up
(b) Ctrl + Home
(c) Page down
(d) Home
Show Answer & Explanation

Answer: (d) Home

Explanation:
1. The Home key moves to column A of the current row, while Ctrl + Home goes to cell A1.

Teacher's Note:
1. Home = row start, Ctrl + Home = A1.

Question 42: Which of the following icons is used to add an attachment to an e-mail?
(a) GIF icon
(b) Stationery icon
(c) Paper clip icon
(d) Emoji icon
Show Answer & Explanation

Answer: (c) Paper clip icon

Explanation:
1. The paper clip icon attaches a file.

Teacher's Note:
1. Paper clip = attachment.

Question 43: ______ is NOT a valid option of the Office button in MS-Word 2007.
(a) Presentation
(b) Save As
(c) Save
(d) Print
Show Answer & Explanation

Answer: (a) Presentation

Explanation:
1. The Office button menu has New, Open, Save, Save As, Print, Prepare, Send, Publish and Close, but no Presentation.

Teacher's Note:
1. Presentation is PowerPoint.

Question 44: Which of the following is the slowest type of Internet service?
(a) Dial-up
(b) 3G and 4G
(c) Digital Subscriber Line
(d) Satellite
Show Answer & Explanation

Answer: (a) Dial-up

Explanation:
1. Dial-up over a telephone line is the slowest of the listed services.

Teacher's Note:
1. Dial-up is up to 56 kbps.

Question 45: Which of the following options can be used to change the column width of a table in MS-Word?
(a) Scroll bar
(b) Ruler
(c) Alignment
(d) Title bar
Show Answer & Explanation

Answer: (b) Ruler

Explanation:
1. Dragging the column markers on the ruler changes column widths.

Teacher's Note:
1. Ruler shows column markers.

Question 46: ______ was the first web browser to implement the omnibox.
(a) Safari
(b) Google Chrome
(c) Mozilla Firefox
(d) Lynx
Show Answer & Explanation

Answer: (b) Google Chrome

Explanation:
1. Google Chrome introduced the omnibox, a single box for both addresses and searches.

Teacher's Note:
1. Omnibox = address + search.

Question 47: In an MS-Excel sheet, a cell address is composed of the ______.
(a) cell's row
(b) cell's column and row
(c) cell's column
(d) worksheet number
Show Answer & Explanation

Answer: (b) cell's column and row

Explanation:
1. The address uses the column letter and row number, like C5.

Teacher's Note:
1. Column + row.

Question 48: Which of the following keyboard shortcuts is used to insert a hyperlink in an MS-Word 2007 document?
(a) Alt + K
(b) Ctrl + K
(c) Ctrl + Return
(d) Alt + =
Show Answer & Explanation

Answer: (b) Ctrl + K

Explanation:
1. Ctrl + K opens the Insert Hyperlink dialog box.

Teacher's Note:
1. K = linK.

Question 49: Which of the following is used to change the text colour in an MS-Word document?
(a) Text highlight colour
(b) Font colour
(c) Shading
(d) Styles
Show Answer & Explanation

Answer: (b) Font colour

Explanation:
1. Font Colour changes the colour of the letters themselves.

Teacher's Note:
1. Highlight colours the background.

Question 50: Which of the following is NOT a valid MS-Excel 2007 formula?
(a) SUMIF
(b) SUM
(c) SUMPRODUCT
(d) SUMADD
Show Answer & Explanation

Answer: (d) SUMADD

Explanation:
1. SUMIF, SUM and SUMPRODUCT are Excel functions, but SUMADD does not exist.

Teacher's Note:
1. Learn the SUM family: SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ.

Download Chapter MCQs: Computer Science Miscellaneous

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

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

Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.

FAQs

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

You can get most exhaustive Computer Awareness Delhi Police Constable Executive 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 Constable Executive 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 Constable Executive 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 Constable Executive 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 Constable Executive MCQs Set 04 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.