Computer Science Objective Questions and Answers: Miscellaneous
Explore reliable objective questions for Miscellaneous tailored for learners. Utilizing these Computer Science multiple-choice formats ensures thorough preparation and strengthens problem-solving speed for upcoming school assessments.
Download Miscellaneous MCQs with Answers
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.
A collection of computer fundamentals questions from the Delhi Police Head Constable (Ministerial) shifts held on 12 and 13 October 2022, with answers and explanations. Topics include Excel and Word shortcuts, e-mail fields, EDI, merging cells and pivot tables.
12 October 2022, Shift 2
(a) Format Painter
(b) Replace
(c) Eraser
(d) Strikethrough
Show Answer & Explanation
Answer: (d) Strikethrough
Explanation:
1. Strikethrough draws a line through the middle of selected text.
2. Format Painter copies formatting and Replace changes text.
Teacher's Note:
1. Strikethrough equals a line through the text.
2. It is in the Font group of the Home tab.
(a) Ctrl + 4
(b) Ctrl + 2
(c) Ctrl + 5
(d) Ctrl + 1
Show Answer & Explanation
Answer: (b) Ctrl + 2
Explanation:
1. Ctrl + 2 applies double line spacing.
2. Ctrl + 1 is single and Ctrl + 5 is 1.5 spacing.
Teacher's Note:
1. 1, 1.5 and 2 spacing use Ctrl + 1, 5 and 2.
2. Ctrl + 5 is the odd one.
(a) Data
(b) File
(c) Insert
(d) View
Show Answer & Explanation
Answer: (d) View
Explanation:
1. The Window group of the View tab has Hide and Unhide.
2. Data, File and Insert tabs do not contain it.
Teacher's Note:
1. Hide and Unhide are in the View tab.
2. Rows and columns can also be unhidden by right-click.
(a) abc@def@gmail.com
(b) mySchool@gmail.com
(c) John123@.net
(d) @domainname.com
Show Answer & Explanation
Answer: (b) mySchool@gmail.com
Explanation:
1. A valid address has a user name, one @ and a proper domain.
2. The others have two @ signs, a missing domain name or no user name.
Teacher's Note:
1. Exactly one @ with text on both sides.
2. A domain cannot start with a dot.
P: It compares two text strings and returns TRUE if they are exactly the same.
Q: It compares two text strings and returns 1 if they are not exactly the same.
R: It compares two text strings and returns FALSE if they are not exactly the same.
Which of the following statement(s) is/are true
(a) All P, Q, R
(b) Only P and R
(c) Only P and Q
(d) Only P
Show Answer & Explanation
Answer: (b) Only P and R
Explanation:
1. EXACT returns TRUE for identical text and FALSE otherwise.
2. It never returns the number 1, so Q is wrong.
Teacher's Note:
1. EXACT gives TRUE or FALSE only.
2. It is case sensitive.
(a) Data
(b) Line
(c) Cell
(d) Row
Show Answer & Explanation
Answer: (c) Cell
Explanation:
1. Tab moves the cursor to the next cell in the table.
2. Pressing Tab in the last cell adds a new row.
Teacher's Note:
1. Tab goes forward, Shift + Tab goes back.
2. The unit is a cell, not a row.
(a) CTRL + S
(b) ALT + S
(c) CTRL + U
(d) ALT + U
Show Answer & Explanation
Answer: (c) CTRL + U
Explanation:
1. Ctrl + U opens the page source in a new tab, where it can only be viewed.
2. Ctrl + S saves the page.
Teacher's Note:
1. U stands for source view.
2. F12 opens developer tools.
(a) Cable
(b) DSL
(c) Dial up
(d) Satellite
Show Answer & Explanation
Answer: (d) Satellite
Explanation:
1. Satellite internet uses a dish and radio signals from a satellite.
2. Cable needs a TV cable and DSL and dial-up need telephone lines.
Teacher's Note:
1. Satellite and mobile data are wireless.
2. Dial-up is the slowest.
(a) Fancy
(b) Subscript
(c) Bold
(d) Italic
Show Answer & Explanation
Answer: (a) Fancy
Explanation:
1. Subscript is an effect, and Bold and Italic are font styles in the dialog.
2. There is no effect called Fancy.
Teacher's Note:
1. Effects include strikethrough, superscript, subscript, small caps.
2. Fancy is not a Word font effect.
(a) Alt+ PageDown
(b) Ctrl + PageDown
(c) Ctrl + PageUp
(d) Alt+PageUp
Show Answer & Explanation
Answer: (c) Ctrl + PageUp
Explanation:
1. Ctrl + Page Up moves to the previous worksheet.
2. Ctrl + Page Down moves to the next worksheet.
Teacher's Note:
1. Up goes to the previous sheet, Down to the next.
2. Alt + Page Up scrolls one screen left.
12 October 2022, Shift 3
(a) Inbox
(b) From
(c) Bcc
(d) To
Show Answer & Explanation
Answer: (b) From
Explanation:
1. The From field shows who sent the message.
2. To holds the receiver, Bcc holds hidden receivers and Inbox is a folder.
Teacher's Note:
1. From is the sender, To is the receiver.
2. Subject is the purpose.
(a) Date()
(b) Time()
(c) Now()
(d) Timevalue()
Show Answer & Explanation
Answer: (c) Now()
Explanation:
1. NOW() returns the current date and time.
2. TIMEVALUE converts text to a time number.
Teacher's Note:
1. NOW has date plus time.
2. Press Ctrl + Shift + ; for the time only.
(a) Ctrl+D
(b) Ctrl+K
(c) Ctrl+H
(d) Ctrl+G
Show Answer & Explanation
Answer: (b) Ctrl+K
Explanation:
1. Ctrl + K opens the Insert Hyperlink dialog.
2. Ctrl + H is Replace and Ctrl + G is Go To.
Teacher's Note:
1. K links, as in Ctrl + K.
2. The same works in Word.
(a) Ctrl+R
(b) Ctrl+Shift+R
(c) Ctrl+J
(d) Ctrl+Shift+M
Show Answer & Explanation
Answer: (a) Ctrl+R
Explanation:
1. Ctrl + R aligns the paragraph to the right.
2. Ctrl + J justifies the paragraph.
Teacher's Note:
1. L, E, R, J give left, center, right, justify.
2. Ctrl + Shift + M is a different command.
(a) Ctrl + F5
(b) Shift + F5
(c) Shift + F12
(d) Ctrl + F12
Show Answer & Explanation
Answer: (c) Shift + F12
Explanation:
1. Shift + F12 also saves the document, like Ctrl + S.
2. Ctrl + F12 opens a document, and F12 alone is Save As.
Teacher's Note:
1. Save equals Ctrl + S or Shift + F12.
2. Save As equals F12.
(a) AutoFill
(b) AutoSum
(c) PivotTable
(d) Charts
Show Answer & Explanation
Answer: (b) AutoSum
Explanation:
1. AutoSum quickly adds the numbers in neighbouring cells with the SUM function.
2. AutoFill copies a series and PivotTable summarises data.
Teacher's Note:
1. AutoSum equals the sigma button.
2. Alt + = inserts AutoSum.
(a) Alt + D
(b) Ctrl + D
(c) Ctrl + J
(d) Alt + J
Show Answer & Explanation
Answer: (c) Ctrl + J
Explanation:
1. Ctrl + J opens the Downloads page in Chrome.
2. Ctrl + D bookmarks the page.
Teacher's Note:
1. J for downloads, H for history.
2. Ctrl + H opens History.
(a) Fiber optics
(b) Bluetooth Card
(c) Network Interface Card
(d) Wi-Fi card
Show Answer & Explanation
Answer: (c) Network Interface Card
Explanation:
1. An Ethernet card is the Network Interface Card (NIC) that connects a computer to a wired LAN.
2. Fibre optics is a cable type and Bluetooth and Wi-Fi are wireless.
Teacher's Note:
1. NIC equals LAN card.
2. It has a unique MAC address.
(a) Alt+ PageDown
(b) Ctrl + PageDown
(c) Alt+ PageUp
(d) Ctrl + PageUp
Show Answer & Explanation
Answer: (b) Ctrl + PageDown
Explanation:
1. Ctrl + Page Down moves to the next worksheet.
2. Ctrl + Page Up moves to the previous one.
Teacher's Note:
1. Down goes next, up goes previous.
2. Alt + Page keys scroll the screen sideways.
(a) HOME
(b) REVIEW
(c) FILE
(d) FORMULA
Show Answer & Explanation
Answer: (c) FILE
Explanation:
1. The File tab opens the Backstage view with Save, Open, Print and Options.
2. Other tabs hold editing commands.
Teacher's Note:
1. File tab equals backstage view.
2. Alt + F opens it.
13 October 2022, Shift 1
(a) Ctrl+Delete
(b) Alt+Backspace
(c) Delete
(d) Ctrl+Backspace
Show Answer & Explanation
Answer: (c) Delete
Explanation:
1. The Delete key removes the character after the cursor.
2. Ctrl + Delete removes a whole word.
Teacher's Note:
1. Delete goes right, Backspace goes left.
2. Add Ctrl to delete words.
(a) VIRUS
(b) CHAT
(c) SEARCH
(d) EMAIL
Show Answer & Explanation
Answer: (a) VIRUS
Explanation:
1. A virus is malicious code that spreads between computers and can damage data.
2. Chat, search and email are normal services.
Teacher's Note:
1. Spreads and damages equals virus.
2. Install antivirus and keep it updated.
(a) In MS-Excel 2010, to open a new file Ctrl+N is used.
(b) In MS-Excel 2010, we can save the file by using F12.
(c) In MS-Excel 2010, we can insert a table from insert tab.
(d) In MS-Excel 2010, we cannot insert comment to a cell.
Show Answer & Explanation
Answer: (d) In MS-Excel 2010, we cannot insert comment to a cell.
Explanation:
1. Comments can be added to a cell with Review, New Comment or Shift + F2.
2. The other three statements are correct.
Teacher's Note:
1. Shift + F2 adds a cell comment.
2. F12 opens Save As.
(a) F3
(b) F1
(c) F5
(d) F7
Show Answer & Explanation
Answer: (d) F7
Explanation:
1. F7 starts Spelling and Grammar check.
2. F1 is Help and F5 opens Find and Replace, Go To.
Teacher's Note:
1. F7 for spelling.
2. Shift + F7 opens the thesaurus.
(a) Ctrl + X
(b) Ctrl + N
(c) Ctrl + V
(d) Ctrl + Y
Show Answer & Explanation
Answer: (b) Ctrl + N
Explanation:
1. Ctrl + N creates a new blank document.
2. Ctrl + X is cut, Ctrl + V is paste and Ctrl + Y is redo.
Teacher's Note:
1. N for New, O for Open.
2. Works the same in Excel.
(a) NEW
(b) OPEN
(c) SAVE AS
(d) SAVE
Show Answer & Explanation
Answer: (b) OPEN
Explanation:
1. Open loads a saved file from the disk.
2. New creates a blank workbook, Save and Save As store files.
Teacher's Note:
1. Open is Ctrl + O.
2. Save As gives a new name or location.
(a) 128
(b) 16
(c) 32
(d) 64
Show Answer & Explanation
Answer: (c) 32
Explanation:
1. IPv4 addresses are 32 bits long, shown as four 8-bit numbers.
2. IPv6 addresses are 128 bits.
Teacher's Note:
1. IPv4 is 32 bits, IPv6 is 128 bits.
2. 32 bits give about 4.3 billion addresses.
(a) Tab + Enter
(b) Alt + Enter
(c) Ctrl + Enter
(d) Shift + Enter
Show Answer & Explanation
Answer: (b) Alt + Enter
Explanation:
1. Alt + Enter inserts a line break inside the same cell.
2. Plain Enter moves to the next cell.
Teacher's Note:
1. Alt + Enter equals a new line in a cell.
2. Turn on Wrap Text to see the lines.
(a) Bcc
(b) From
(c) Subject
(d) To
Show Answer & Explanation
Answer: (c) Subject
Explanation:
1. The Subject line tells in brief what the mail is about.
2. From, To and Bcc hold addresses.
Teacher's Note:
1. Subject equals topic of the mail.
2. Keep it short and clear.
(a) VLOOKUP
(b) COUNT
(c) MATCH
(d) SUM
Show Answer & Explanation
Answer: (c) MATCH
Explanation:
1. The Excel function list describes MATCH as looking up values in a reference or array.
2. It returns the relative position of the item.
Teacher's Note:
1. MATCH gives a position, VLOOKUP gives a value.
2. INDEX and MATCH are often used together.
13 October 2022, Shift 2
(a) Merging
(b) Formatting
(c) Splitting
(d) Editing
Show Answer & Explanation
Answer: (a) Merging
Explanation:
1. Merging combines two or more adjacent cells into one cell.
2. Splitting does the opposite.
Teacher's Note:
1. Merge joins, split divides.
2. Both are on the Layout tab of Table Tools.
(a) Email
(b) FTP
(c) World Wide Web
(d) Ethernet
Show Answer & Explanation
Answer: (d) Ethernet
Explanation:
1. Ethernet is a wired networking technology used in LANs, not an Internet service.
2. Email, FTP and the WWW are Internet services.
Teacher's Note:
1. Ethernet is a LAN technology.
2. FTP transfers files.
(a) Emergency data Interchange
(b) Electronic Data Information
(c) Electronic Data Interchange
(d) Electronic Data Instruction
Show Answer & Explanation
Answer: (c) Electronic Data Interchange
Explanation:
1. EDI stands for Electronic Data Interchange.
2. It exchanges business documents such as invoices between companies in a standard format.
Teacher's Note:
1. EDI equals Electronic Data Interchange.
2. It replaces paper orders and invoices.
(a) Align Right
(b) Center
(c) Align Left
(d) Justify
Show Answer & Explanation
Answer: (d) Justify
Explanation:
1. Justify spreads the text so both left and right edges are straight.
2. Other alignments leave one or both edges uneven.
Teacher's Note:
1. Justify equals Ctrl + J.
2. It adds space between words.
(a) Cells can contain text, such as letters, numbers, and dates.
(b) Cells can contain text, such as letters, numbers but not dates.
(c) Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed
(d) Any information you enter in a spreadsheet will be stored in a cell.
Show Answer & Explanation
Answer: (b) Cells can contain text, such as letters, numbers but not dates.
Explanation:
1. Cells can store dates as well as text and numbers.
2. So the statement saying not dates is wrong.
Teacher's Note:
1. A cell can hold text, numbers, dates and formulas.
2. Dates are stored as serial numbers.
(a) File tab
(b) Quick Access toolbar
(c) Title bar
(d) Ribbon
Show Answer & Explanation
Answer: (b) Quick Access toolbar
Explanation:
1. The Quick Access Toolbar holds Save, Undo and Redo by default.
2. It can be customised with more commands.
Teacher's Note:
1. QAT is at the top left.
2. You can place it below the ribbon.
= 9 / 6 * 4 + 3 - 1
(a) 12
(b) 10
(c) 6
(d) 8
Show Answer & Explanation
Answer: (d) 8
Explanation:
1. Division and multiplication go left to right: 9 / 6 = 1.5 and 1.5 * 4 = 6.
2. Then 6 + 3 - 1 = 8.
Teacher's Note:
1. Excel follows the BODMAS order.
2. Same-level operators go left to right.
(a) From
(b) Subject
(c) To
(d) Signature
Show Answer & Explanation
Answer: (c) To
Explanation:
1. The To field carries the address of the person who receives the mail.
2. From is the sender.
Teacher's Note:
1. To equals receiver.
2. Cc and Bcc are extra receivers.
(a) Italic
(b) Regular
(c) Superbold
(d) Bold
Show Answer & Explanation
Answer: (c) Superbold
Explanation:
1. The Font Style list has Regular, Italic, Bold and Bold Italic.
2. There is no Superbold style.
Teacher's Note:
1. Four styles: regular, italic, bold, bold italic.
2. Superbold is not a real option.
(a) Bar
(b) Spreadsheet
(c) Line
(d) Pivot table
Show Answer & Explanation
Answer: (d) Pivot table
Explanation:
1. A pivot table summarises a large table by grouping and aggregating its values.
2. Bar and line are chart types.
Teacher's Note:
1. Pivot table equals summary table.
2. Insert, PivotTable creates it.
Free study material for Computer Science
Miscellaneous Objective Questions & Solutions for Computer Science
Computer Science Miscellaneous Objective Test Questions
Explore reliable practice questions for Miscellaneous tailored for Computer Science learners. Use these multiple-choice formats to evaluate preparedness and strengthen problem-solving skills.
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 02 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 02 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 02, 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 02 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.