Practice MCQs for Computer Science Miscellaneous
Access targeted multiple-choice questions for Miscellaneous designed to align with the latest NCERT academic syllabus for Computer Science. These objective practice sets help students evaluate their conceptual understanding and improve exam readiness.
Access Miscellaneous Questions and Solutions
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.
Computer awareness questions asked in the Delhi Police Head Constable (Ministerial) computer-based exam on 10 and 12 October 2022, each with the correct answer and a short explanation. The questions cover MS Excel shortcuts and functions, MS Word, e-mail, browsers and IP addresses.
10 October 2022, Shift 1
(a) Ctrl + 9
(b) Alt + 0
(c) Alt + 9
(d) Ctrl + 0
Show Answer & Explanation
Answer: (d) Ctrl + 0
Explanation:
1. Ctrl + 0 hides the selected columns.
2. Ctrl + 9 hides rows, and Alt + 0 or Alt + 9 are not hide shortcuts.
Teacher's Note:
1. Zero hides columns, nine hides rows.
2. Ctrl + Shift + 0 and Ctrl + Shift + 9 bring them back.
(a) Title bar
(b) Task bar
(c) Status bar
(d) Ribbon
Show Answer & Explanation
Answer: (c) Status bar
Explanation:
1. The status bar sits at the bottom of the Excel window.
2. It shows the cell mode, zoom slider, view buttons and quick calculations such as sum and average.
Teacher's Note:
1. Title bar is at the top, status bar is at the bottom.
2. Right-click the status bar to choose what it displays.
(a) Insert
(b) View
(c) File
(d) Data
Show Answer & Explanation
Answer: (b) View
Explanation:
1. The View tab has a Window group with Hide and Unhide buttons.
2. Insert, File and Data tabs have no Hide command for windows.
Teacher's Note:
1. Hide and Unhide for windows belong to the View tab.
2. Hiding rows or columns is also found under Home, Format.
(a) Notepad
(b) Microsoft Word
(c) Open Office Impress
(d) WordPad
Show Answer & Explanation
Answer: (c) Open Office Impress
Explanation:
1. Impress is the presentation program of OpenOffice and is used to make slides.
2. Word and WordPad process documents, and Notepad is a plain text editor.
Teacher's Note:
1. Impress equals slides, Writer equals documents.
2. Compare PowerPoint with Impress, and Word with Writer.
(a) 2002
(b) 2003
(c) 2001
(d) 2000
Show Answer & Explanation
Answer: (a) 2002
Explanation:
1. The browser project that became Firefox was first released in 2002 under the name Phoenix.
2. It was renamed Firebird and then Firefox, and version 1.0 appeared in 2004.
Teacher's Note:
1. Firefox began in 2002, Chrome in 2008, Internet Explorer in 1995.
2. Remember the browser birth years as a short list.
(a) columns, rows
(b) table, pivot table
(c) rows, columns
(d) chart, graph
Show Answer & Explanation
Answer: (a) columns, rows
Explanation:
1. Excel columns carry letters A, B, C and so on.
2. Rows carry numbers 1, 2, 3 and so on.
Teacher's Note:
1. Columns are lettered, rows are numbered.
2. A cell address always combines both, such as B3.
(a) XML
(b) HTML
(c) EML
(d) SGML
Show Answer & Explanation
Answer: (a) XML
Explanation:
1. XML (Extensible Markup Language) is designed to store and transport arbitrary data.
2. HTML is meant to display web pages.
Teacher's Note:
1. XML carries data, HTML shows data.
2. XML tags are user defined.
(a) %
(b) #
(c) $
(d) @
Show Answer & Explanation
Answer: (d) @
Explanation:
1. An email address has the form username@domain.
2. The at-sign separates the user name from the domain name.
Teacher's Note:
1. No @ means no valid email address.
2. The part after @ is the domain.
(a) NOW
(b) YEAR
(c) TODAY
(d) CURRENT
Show Answer & Explanation
Answer: (c) TODAY
Explanation:
1. TODAY() returns only the current date.
2. NOW() returns date and time, and YEAR() extracts a year from a date.
Teacher's Note:
1. TODAY gives date, NOW gives date and time.
2. CURRENT is not an Excel function.
(a) COUNTIF
(b) SUM
(c) LEN
(d) COUNTA
Show Answer & Explanation
Answer: (c) LEN
Explanation:
1. LEN(text) counts all characters in a text string, including spaces.
2. COUNTIF and COUNTA count cells, and SUM adds numbers.
Teacher's Note:
1. LEN stands for length.
2. =LEN("Excel") gives 5.
10 October 2022, Shift 2
(a) Center
(b) Justify
(c) Left
(d) Right
Show Answer & Explanation
Answer: (d) Right
Explanation:
1. Excel right-aligns numbers and dates by default.
2. Text is left-aligned by default.
Teacher's Note:
1. Numbers go right, text goes left.
2. A left-aligned number is usually stored as text.
(a) CTLR+F2
(b) ALT+F1
(c) CTLR+F1
(d) ALT+F2
Show Answer & Explanation
Answer: (c) CTLR+F1
Explanation:
1. Ctrl + F1 collapses or expands the ribbon.
2. Right-click and choosing Collapse the Ribbon does the same.
Teacher's Note:
1. Ctrl + F1 toggles the ribbon.
2. Double-clicking an active tab also collapses it.
I. gmail.com
II. outlook.com
III. yahoo.com
(a) I and II
(b) I and III
(c) II and III
(d) All I, II and III
Show Answer & Explanation
Answer: (d) All I, II and III
Explanation:
1. The domain is the part after @ in an email address.
2. gmail.com, outlook.com and yahoo.com are all valid domain names.
Teacher's Note:
1. Any registered web mail provider name works as a domain.
2. Look at the text after the @ sign.
(a) Save
(b) Downloading
(c) Uploading
(d) Create
Show Answer & Explanation
Answer: (c) Uploading
Explanation:
1. Sending a file from your computer to a server is uploading.
2. Downloading is the opposite, from server to computer.
Teacher's Note:
1. Up goes to the server, down comes to you.
2. Publishing a web page means uploading it.
(a) Delete
(b) Alt+Backspace
(c) Ctrl+Delete
(d) Ctrl+Backspace
Show Answer & Explanation
Answer: (c) Ctrl+Delete
Explanation:
1. Ctrl + Delete removes the word to the right of the cursor.
2. Ctrl + Backspace removes the word to the left.
Teacher's Note:
1. Ctrl makes Delete and Backspace work word by word.
2. Delete goes right, Backspace goes left.
(a) BLOG
(b) Instant messenger
(c) EMAIL
(d) VIRUS
Show Answer & Explanation
Answer: (a) BLOG
Explanation:
1. A blog (weblog) is a website of personal or group writing in dated posts.
2. The other options are a chat tool, a mail service and malware.
Teacher's Note:
1. Blog comes from web log.
2. A video blog is called a vlog.
(a) NOW
(b) YEAR
(c) TODAY
(d) CURRENT
Show Answer & Explanation
Answer: (a) NOW
Explanation:
1. NOW() returns the current date together with the time.
2. TODAY() gives only the date.
Teacher's Note:
1. NOW has both, TODAY has date only.
2. Both update when the sheet recalculates.
(a) In MS-Excel 2010, we can save the file by using F3.
(b) In MS-Excel 2010, Ctrl+F is used in finding text within the sheet.
(c) Alt+Enter shortcut key is used in MS-Excel 2010 to start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell.
(d) In MS-Excel 2010 Home Tab in ribbon bar contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc.
Show Answer & Explanation
Answer: (a) In MS-Excel 2010, we can save the file by using F3.
Explanation:
1. Saving is done with Ctrl + S, and F12 opens Save As; F3 does not save a file.
2. The other three statements are correct.
Teacher's Note:
1. F12 is Save As, F2 is edit cell, F4 repeats or toggles reference type.
2. Read every option before marking a wrong-option question.
(a) IF
(b) SUM
(c) COUNT
(d) AVERAGE
Show Answer & Explanation
Answer: (b) SUM
Explanation:
1. SUM adds the numbers in the given cells or range.
2. COUNT counts numeric cells and AVERAGE finds the mean.
Teacher's Note:
1. SUM adds, COUNT counts, AVERAGE finds the mean.
2. AutoSum on the ribbon inserts SUM.
10 October 2022, Shift 3
(a) four
(b) three
(c) two
(d) five
Show Answer & Explanation
Answer: (b) three
Explanation:
1. An IPv4 address has four decimal numbers (octets) such as 192.168.1.1.
2. Four numbers are separated by exactly three dots.
Teacher's Note:
1. Four parts, three dots.
2. Each part is between 0 and 255.
(a) 1024
(b) 16384
(c) 256
(d) 32767
Show Answer & Explanation
Answer: (d) 32767
Explanation:
1. A cell can hold at most 32,767 characters.
2. Only the first 1,024 appear in the cell itself, but the formula bar shows all of them.
Teacher's Note:
1. Cell limit is 32,767 characters.
2. Do not confuse it with 16,384 columns.
(a) Alt+Enter shortcut key is used in MS-Excel 2010 to enter a new line in the text of a particular cell.
(b) In MS-Excel 2010, home tab in ribbon bar contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting, etc
(c) In MS-Excel 2010, Ctrl+R is used in replacing text within the sheet.
(d) In MS-Excel 2010, Ctrl+H is used in replacing text within the sheet.
Show Answer & Explanation
Answer: (c) In MS-Excel 2010, Ctrl+R is used in replacing text within the sheet.
Explanation:
1. Replace is opened with Ctrl + H, not Ctrl + R.
2. Ctrl + R is Fill Right; the other statements are correct.
Teacher's Note:
1. H for replace, F for find.
2. Ctrl + R fills the left cell content to the right.
(a) SORT
(b) TABLE
(c) CHART
(d) FILTER
Show Answer & Explanation
Answer: (a) SORT
Explanation:
1. Sort arranges data in ascending or descending order.
2. Filter only hides rows that do not match.
Teacher's Note:
1. Sort arranges, filter hides.
2. Sort is on the Data tab and Home tab.
(a) Backspace
(b) Ctrl + Backspace
(c) Ctrl + Delete
(d) Shift + Delete
Show Answer & Explanation
Answer: (a) Backspace
Explanation:
1. Backspace deletes the character before the cursor.
2. Ctrl + Backspace deletes a whole word to the left.
Teacher's Note:
1. Backspace goes left one character.
2. Delete goes right one character.
(a) Click File > Options > Customized Ribbon and select the Allow editing directly in cells check box
(b) Click File > Options > Advanced and under Editing options select the Allow editing directly in cells check box
(c) Click File > Options > Customized Ribbon and under Editing options select the Allow editing directly in cells check box
(d) Click File > Options > Trust Center and select the Allow editing directly in cells check box
Show Answer & Explanation
Answer: (b) Click File > Options > Advanced and under Editing options select the Allow editing directly in cells check box
Explanation:
1. The setting is on the Advanced page of Excel Options.
2. It is listed under Editing options as Allow editing directly in cells.
Teacher's Note:
1. Path: File, Options, Advanced, Editing options.
2. Pressing F2 also enters edit mode.
(a) ALT + I
(b) ALT + N
(c) ALT + A
(d) ALT + W
Show Answer & Explanation
Answer: (d) ALT + W
Explanation:
1. Alt + W opens the View tab through its key tip.
2. Alt + N is Insert and Alt + A is Data.
Teacher's Note:
1. W for window or view.
2. N for iNsert, A for dAta, R for Review.
(a) Trash
(b) Sent
(c) Spam
(d) Drafts
Show Answer & Explanation
Answer: (d) Drafts
Explanation:
1. Drafts keeps messages that were written but not sent.
2. Sent holds delivered mail, Trash holds deleted mail and Spam holds junk.
Teacher's Note:
1. Draft means not finished.
2. Mail autosaves into Drafts while you type.
(a) VIRUS
(b) Website
(c) EMAIL
(d) Instant messenger
Show Answer & Explanation
Answer: (b) Website
Explanation:
1. A website is a set of linked web pages under one domain name.
2. A virus is malware and email and messenger are communication services.
Teacher's Note:
1. Many web pages under one domain is a website.
2. The first page is called the home page.
(a) B9
(b) B3
(c) G9
(d) G3
Show Answer & Explanation
Answer: (b) B3
Explanation:
1. The Name Box shows the active cell.
2. Selecting from B3 makes B3 the active cell, and it stays shown while the range is selected.
Teacher's Note:
1. Name Box shows the first cell of the selection.
2. The selection ends at G9 but the active cell is B3.
12 October 2022, Shift 1
(a) 400%
(b) 500%
(c) 200%
(d) 300%
Show Answer & Explanation
Answer: (a) 400%
Explanation:
1. Excel 2010 zoom ranges from 10% to 400%.
2. The slider on the status bar stops at 400%.
Teacher's Note:
1. Excel zoom 10% to 400%.
2. Word 2010 zoom is 10% to 500%.
(a) Filter
(b) Rows
(c) Column
(d) Cell
Show Answer & Explanation
Answer: (c) Column
Explanation:
1. Each column header of a table gets a drop-down filter.
2. Choosing values from the column hides the rows that do not match.
Teacher's Note:
1. Table headers carry filter arrows for each column.
2. Insert, Table, creates the table.
(a) Apple
(b) Google
(c) Mozilla
(d) Microsoft
Show Answer & Explanation
Answer: (a) Apple
Explanation:
1. Safari is the web browser from Apple.
2. Google makes Chrome, Mozilla makes Firefox and Microsoft makes Edge.
Teacher's Note:
1. Safari is Apple, Chrome is Google.
2. Firefox is Mozilla, Edge is Microsoft.
(a) F3
(b) F1
(c) F4
(d) F2
Show Answer & Explanation
Answer: (d) F2
Explanation:
1. F2 puts the active cell in edit mode.
2. F1 is Help, F3 pastes a name and F4 repeats the last action.
Teacher's Note:
1. F2 is edit, F1 is help.
2. Double-click also edits a cell.
(a) Alt + Page down
(b) Alt + Left arrow
(c) Ctrl + Right arrow
(d) Ctrl + Page up
Show Answer & Explanation
Answer: (d) Ctrl + Page up
Explanation:
1. Ctrl + Page Up moves to the previous tab on the left.
2. Ctrl + Page Down moves to the tab on the right.
Teacher's Note:
1. Page Up goes left, Page Down goes right in tabs.
2. Alt + Left arrow goes back one page, not tab.
(a) Alt+R
(b) Alt+F
(c) Ctrl+H
(d) Ctrl+F
Show Answer & Explanation
Answer: (c) Ctrl+H
Explanation:
1. Ctrl + H opens the Replace dialog.
2. Ctrl + F opens Find.
Teacher's Note:
1. H replaces, F finds.
2. The same keys work in Word.
(a) sent
(b) trash
(c) inbox
(d) draft
Show Answer & Explanation
Answer: (d) draft
Explanation:
1. Draft stores messages that were saved but not sent.
2. Sent holds mail already sent, inbox holds received mail.
Teacher's Note:
1. Draft means unsent.
2. Trash holds deleted mail.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | A | B | C | D |
| 2 | 15 | 10 | 5 | |
| 3 | 25 | 15 | 1 | |
| 4 | 100 | 120 | 140 |
(b) $B$2
(c) &B2&
(d) B2$
Show Answer & Explanation
Answer: (b) $B$2
Explanation:
1. The value 10 is in column B, row 2, so the cell is B2.
2. An absolute reference puts $ before both column and row, that is $B$2.
Teacher's Note:
1. Absolute means a $ on both parts.
2. $B2 or B$2 are mixed references.
(a) Shift+F11
(b) Shift+Ctrl+F10
(c) Shift+F10
(d) Shift+Ctrl+F11
Show Answer & Explanation
Answer: (a) Shift+F11
Explanation:
1. Shift + F11 inserts a new worksheet before the current one.
2. The plus sign tab at the bottom does the same.
Teacher's Note:
1. Shift + F11 means new sheet.
2. Shift + F10 opens the right-click menu.
(a) IF
(b) SUM
(c) COUNTIF
(d) COUNT
Show Answer & Explanation
Answer: (c) COUNTIF
Explanation:
1. COUNTIF counts the cells in a range that meet a given condition.
2. COUNT only counts numeric cells without any condition.
Teacher's Note:
1. COUNTIF equals count with a condition.
2. Example: =COUNTIF(A1:A10, ">5").
Free study material for Computer Science
Multiple Choice Questions (MCQs) for Computer Science Miscellaneous
Computer Science Miscellaneous Objective Test Questions
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.
NCERT-Aligned Objective Questions and Solutions
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.
Next Steps in Your Exam Preparation
Follow up your worksheet practice by attempting the interactive online Computer Science MCQ test for this chapter to evaluate your execution speed. All platform resources are free to access.
FAQs
You can get most exhaustive Computer Awareness Delhi Police Head Constable Ministerial 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 Ministerial 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 Ministerial 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 Ministerial MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.