Delhi Police Constable · Topic Collection

Computer Knowledge PYQs

Computer fundamentals — hardware, software, MS Office, internet, networking, and cybersecurity awareness asked in computer knowledge sections.

1030 Total Questions103 Official PapersYears: 2020–2026Search in Computer Knowledge
Showing questions 621–640 of 1030Page 32 of 52
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 621

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

When you ‘reply’ to an email, what does it mean?

  1. AOption (a)

    You're sending the same email back to the original sender.

  2. BOption (b)

    You're sending the email to a different recipient.

  3. COption (c)

    You're sending a new email to the same recipient. 

  4. DOption (d)

    You're deleting the email.

View answer & explanation

Correct answer

Answer: (c)C.

You're sending a new email to the same recipient. 

Why this answer is correct

The correct answer is Option 3: You're sending a new email to the same recipient..

Key Points

  • Replying to an email means sending a response directly to the original sender of the email.
  • The content of the reply can include answers, acknowledgments, or any other relevant information addressing the original email.
  • When replying, the recipient's email address is automatically populated in the "To" field, eliminating the need to manually input it.
  • Replying typically includes the original email thread for context, unless manually removed or adjusted.
  • The reply function is different from "Forward," which sends the email to a new recipient, not the original sender.

Additional Information

  • Reply vs. Reply All:
  • "Reply" sends the response only to the original sender.
  • "Reply All" sends the response to the original sender and all other recipients listed in the email.
  • Forwarding Emails:
  • The "Forward" function sends the email to a different recipient, not the original sender.
  • Forwarding allows you to share the email content with someone who was not part of the original conversation.
  • Email Thread:
  • An email thread refers to a series of emails that are related and grouped together for context.
  • Replying to an email often includes the thread, making it easier to follow the conversation history.
  • Importance of Email Etiquette:
  • Be concise and relevant while replying to an email.
  • Ensure proper formatting and grammar to maintain professionalism.
  • Avoid replying to "Reply All" unless necessary to avoid unnecessary communication overload.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 622

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which protocol allows users to make real-time voice and video calls over the internet?

  1. AOption (a)

    FTP

  2. BOption (b)

    VoIP

  3. COption (c)

    Email

  4. DOption (d)

    DNS

View answer & explanation

Correct answer

Answer: (b)B.

VoIP

Why this answer is correct

The correct answer is VoIP.

Key Points

  • VoIP (Voice over Internet Protocol) is a communication protocol that enables users to make voice and video calls over the internet.
  • It works by converting analog audio signals into digital data packets and transmitting them via the internet.
  • Popular VoIP services include Skype, Zoom, Google Meet, and Microsoft Teams, which are widely used for personal and professional communication.
  • VoIP is cost-effective, offering free or low-cost calls compared to traditional telephony systems.
  • It supports additional features such as video conferencing, file sharing, and instant messaging, making it a versatile communication tool.

Additional Information

  • How VoIP Works:
  • VoIP uses packet-switching technology to transmit data instead of the circuit-switching method used in traditional telephony.
  • Audio signals are compressed into smaller packets, sent over the internet, and reassembled at the receiver's end.
  • Advantages of VoIP:
  • Cost savings on long-distance and international calls.
  • Flexibility to use the service on various devices such as smartphones, laptops, and VoIP-enabled phones.
  • Scalability for businesses, as additional lines can be added without significant infrastructure costs.
  • Disadvantages of VoIP:
  • Reliability depends on a stable internet connection; poor network quality can affect call clarity.
  • Requires a power source and internet access, unlike traditional landlines that function during power outages.
  • Related Protocols:
  • VoIP works in conjunction with other protocols such as SIP (Session Initiation Protocol) and RTP (Real-Time Transport Protocol) to establish and manage calls.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 623

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following is the correct shortcut key to open an existing spreadsheet in MS Excel?

  1. AOption (a)

    Press Alternate (Alt) + N

  2. BOption (b)

    Press Control (Ctrl) + O

  3. COption (c)

    Press Control (Ctrl) + N

  4. DOption (d)

    Press Alternate (Alt) + O

View answer & explanation

Correct answer

Answer: (b)B.

Press Control (Ctrl) + O

Why this answer is correct

The correct answer is Press Control (Ctrl) + O.

Key Points

  • In Microsoft Excel 365, the shortcut Ctrl + O is used to open an existing spreadsheet.
  • This shortcut is universally recognized across most versions of Microsoft Excel, ensuring ease of use and consistency.
  • Using Ctrl + O opens the "Open" dialog box or the backstage view in Excel, allowing users to browse and select files.
  • Keyboard shortcuts like Ctrl + O are designed to improve productivity by reducing the need for mouse clicks.
  • Learning and utilizing such shortcuts can significantly enhance efficiency while working with Excel and other Microsoft Office applications.

Additional Information

  • Microsoft Excel Shortcuts:
  • Ctrl + N: Creates a new blank workbook.
  • Ctrl + S: Saves the current workbook.
  • Ctrl + P: Opens the print dialog box for printing the workbook.
  • Alt + F: Opens the File menu in the ribbon interface.
  • Backstage View in Excel:
  • Introduced in Excel 2010, the backstage view is where users manage files, such as opening, saving, printing, and sharing.
  • It is accessed by pressing Ctrl + O or clicking the "File" tab in the ribbon.
  • Excel File Formats:
  • .xlsx: The default file format for Excel workbooks.
  • .xls: Legacy file format used in Excel versions prior to 2007.
  • .csv: Comma-separated values format, often used for data exchange.
  • Importance of Shortcuts:
  • Keyboard shortcuts are essential for improving speed and productivity in spreadsheet management.
  • They reduce dependency on the mouse, making workflows smoother and less time-consuming.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 624

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Word 365 which of the following menus is used to open a word document? 

  1. AOption (a)

    Start

  2. BOption (b)

    Mozilla

  3. COption (c)

    Power

  4. DOption (d)

    Control panel

View answer & explanation

Correct answer

Answer: (a)A.

Start

Why this answer is correct

The correct answer is Start.

Key Points

  • In MS Word 365, the Start menu is used to open a word document.
  • The Start menu allows users to access various files and applications, including Microsoft Word, installed on the system.
  • Once inside MS Word, users can select the "File" tab and then choose "Open" to navigate and open a specific document.
  • The Start menu is typically located on the bottom left corner of the screen in Windows operating systems.
  • Using the Start menu ensures quick access to applications like MS Word, enhancing user productivity.

Additional Information

  • Microsoft Word:
  • Microsoft Word is a widely used word processing application developed by Microsoft.
  • It is part of the Microsoft Office suite and is now integrated into Microsoft 365.
  • Users can create, edit, format, and share documents with advanced text and graphical features.
  • Word supports various file formats, including .doc, .docx, and .pdf.
  • Start Menu in Windows:
  • The Start menu is a feature of Microsoft Windows that provides access to programs, documents, and system settings.
  • Introduced in Windows 95, the Start menu has undergone significant updates in design and functionality over the years.
  • It serves as a central hub for navigating the operating system.
  • Microsoft 365:
  • Microsoft 365 is a subscription-based service offering productivity tools, including Word, Excel, PowerPoint, and Outlook.
  • It provides cloud storage solutions through OneDrive and collaborative features for teams.
  • Microsoft 365 ensures regular updates and access to the latest features.
  • File Tab in MS Word:
  • The "File" tab in MS Word provides essential options like Open, Save, Print, and Share.
  • Users can access recent documents and manage document properties through this tab.
  • It is an integral part of the ribbon interface introduced in Word 2007.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 625

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Word 365, the AutoCorrect feature is used for _______.

  1. AOption (a)

    misspelled text

  2. BOption (b)

    outside margin text

  3. COption (c)

    formulas

  4. DOption (d)

    short repetitive text

View answer & explanation

Correct answer

Answer: (a)A.

misspelled text

Why this answer is correct

The correct answer is misspelled text.

Key Points

  • The AutoCorrect feature in Microsoft Word 365 is primarily designed to automatically fix common spelling errors and typos as you type.
  • It replaces misspelled text with the correct spelling based on a predefined list of corrections stored in its dictionary.
  • This feature can also be customized to add specific corrections or shortcuts for frequently used terms.
  • AutoCorrect supports multiple languages, allowing seamless error correction for users working with different linguistic settings.
  • In addition to fixing spelling mistakes, AutoCorrect can handle capitalization errors, such as correcting accidental lowercase letters at the start of sentences.

Additional Information

  • AutoCorrect Customization:
  • Users can add, edit, or delete entries in the AutoCorrect list to tailor it to their specific needs.
  • Custom entries allow users to create shortcuts for phrases or symbols, speeding up document creation.
  • Other AutoCorrect Functions:
  • AutoCorrect can replace text with symbols (e.g., converting ":)" to a smiley face).
  • It can format text automatically, such as applying superscript for ordinals (e.g., "1st" to "1st").
  • AutoText vs AutoCorrect:
  • AutoText is a feature that allows users to insert predefined text blocks, while AutoCorrect focuses on error correction.
  • AutoText complements AutoCorrect by enabling efficient insertion of repetitive text.
  • AutoCorrect in Other Office Apps:
  • The AutoCorrect feature is also available in other Microsoft Office applications such as Excel and PowerPoint.
  • In Excel, AutoCorrect can fix errors in cell entries and formulas, ensuring data accuracy.
  • Disabling AutoCorrect:
  • Users can disable AutoCorrect or specific corrections through the application's settings.
  • This is useful when working with specialized text where automatic corrections might interfere with accuracy.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 626

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following groups contains the Insert and Delete command in the Home tab of the ribbon in MS-Excel 365?

  1. AOption (a)

    Editing

  2. BOption (b)

    Cells

  3. COption (c)

    Alignment

  4. DOption (d)

    Font

View answer & explanation

Correct answer

Answer: (b)B.

Cells

Why this answer is correct

The correct answer is Cells.

Key Points

  • In MS Excel 365, the Insert and Delete commands are located under the Cells group of the Home tab in the ribbon.
  • The Cells group provides options for inserting or deleting rows, columns, or individual cells within a worksheet.
  • Users can access commands such as Insert Cells, Insert Sheet Rows, Delete Cells, Delete Sheet Rows, and more from this group.
  • These commands are essential for modifying the structure of worksheets, enabling users to manage data efficiently.
  • The Home tab in Excel is designed to provide commonly used tools and functions, with the Cells group specifically catering to layout adjustments.

Additional Information

  • Ribbon Interface in MS Excel:
  • The ribbon interface in Excel is divided into tabs such as Home, Insert, Page Layout, etc.
  • Each tab contains groups of related commands, facilitating easy navigation and access to features.
  • Groups like Font, Alignment, Number, and Cells are part of the Home tab.
  • Home Tab Overview:
  • The Home tab is one of the most frequently used tabs in Excel, containing tools for formatting, editing, and managing worksheets.
  • Groups under the Home tab include Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.
  • Insert and Delete Commands:
  • Insert and Delete commands allow users to manipulate the structure of a worksheet by adding or removing rows, columns, or cells.
  • These commands are critical for organizing data and ensuring proper worksheet layout.
  • Keyboard Shortcuts for Insert/Delete:
  • Keyboard shortcuts such as Ctrl + Shift + "+" (Insert) and Ctrl + "-" (Delete) can be used for quick access.
  • These shortcuts enhance productivity by enabling faster data manipulation.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 627

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Word 365, which text alignment option is commonly used for legal documents because it aligns the text on both the left and right margins, leaving a jagged edge on the right side?

  1. AOption (a)

    Left Align 

  2. BOption (b)

    Center Align

  3. COption (c)

    Right Align

  4. DOption (d)

    Justify

View answer & explanation

Correct answer

Answer: (d)D.

Justify

Why this answer is correct

The correct answer is Justify.

Key Points

  • The "Justify" text alignment option aligns the text on both the left and right margins, creating a clean, professional appearance.
  • This alignment is commonly used for legal, academic, and formal documents as it makes the text appear balanced and uniform.
  • The "Justify" option eliminates jagged edges on both sides of the text, ensuring a polished and structured document layout.
  • It is particularly popular in legal documents as it aids readability and enhances the professional presentation of the content.
  • In MS Word, "Justify" can be applied by selecting the text and clicking the "Justify" button in the Home tab or using the keyboard shortcut Ctrl + J.

Additional Information

  • Text Alignment Options in MS Word:
  • Left Align: Aligns text to the left margin, leaving the right margin uneven (default alignment).
  • Center Align: Aligns text to the center of the page, often used for headings or titles.
  • Right Align: Aligns text to the right margin, leaving the left margin uneven, used for special formatting.
  • Justify: Aligns text to both margins, creating a clean and structured appearance by evenly distributing spaces between words.
  • Keyboard Shortcuts for Alignment:
  • Ctrl + L: Left Align
  • Ctrl + E: Center Align
  • Ctrl + R: Right Align
  • Ctrl + J: Justify
  • Importance of Justified Text:
  • Enhances readability and uniformity in formal documents.
  • Widely used in newspapers, books, legal papers, and academic writing.
  • Provides a professional and polished look to the content.
  • Limitations of Justify Alignment:
  • May create uneven spaces between words in some cases.
  • Requires careful formatting to avoid excessive gaps in narrow columns.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 628

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, Which of the following keyboard shortcuts is used to auto fit row height manually in MS Excel?

  1. AOption (a)

    Alt + H + O + A

  2. BOption (b)

    Alt + O + C + W

  3. COption (c)

    Alt + H + O + H

  4. DOption (d)

    Alt + O + C + N 

View answer & explanation

Correct answer

Answer: (c)C.

Alt + H + O + H

Why this answer is correct

The correct answer is Alt + H + O + H.

Key Points

  • The keyboard shortcut Alt + H + O + H in MS Excel is used to auto-fit the row height manually.
  • This shortcut adjusts the row height automatically to fit the content within the cells of that row.
  • It helps to optimize the visibility of text and data without requiring manual adjustment.
  • Auto-fitting row height is particularly useful when dealing with variable-length text or data in cells.
  • This shortcut is available in MS Excel 365 and works across Windows systems.

Additional Information

  • Auto-fit Features in Excel:
  • Excel provides auto-fit options for both row height and column width to ensure data is displayed neatly.
  • The auto-fit feature can also be accessed via the Home tab under the Format menu.
  • Shortcut for auto-fitting column width: Alt + H + O + I.
  • Keyboard Shortcuts in MS Excel:
  • Excel offers numerous keyboard shortcuts to enhance productivity and efficiency.
  • Examples include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + Z for undo.
  • Format Options:
  • The Format menu in Excel allows users to manage cell styles, row heights, column widths, and data formatting.
  • It is accessible via the Home tab or by right-clicking on selected rows/columns.
  • Excel Versions:
  • Excel 365 is the latest version of Microsoft's spreadsheet software and includes advanced features like cloud collaboration.
  • Older versions of Excel may have slight differences in shortcuts or functionality.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 629

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following tabs is used in MS Word 365 if we want to delete a table?

  1. AOption (a)

    Insert tab

  2. BOption (b)

    Edit tab

  3. COption (c)

    File tab

  4. DOption (d)

    Layout tab

View answer & explanation

Correct answer

Answer: (d)D.

Layout tab

Why this answer is correct

The correct answer is Layout Tab.

Key Points

  • The Layout Tab in MS Word 365 is specifically used for table-related operations, including deleting rows, columns, or the entire table.
  • To delete a table, users can select the table and navigate to the Layout Tab under the Table Tools section.
  • Within the Layout Tab, there is an option to delete the entire table or specific components like rows and columns.
  • The Delete feature in the Layout Tab ensures precise control over table manipulation without affecting other document content.
  • This tab also provides additional functionalities such as aligning text, resizing rows and columns, and managing table properties.

Additional Information

  • Table Tools in MS Word:
  • Table Tools consist of two tabs: Design Tab and Layout Tab, which appear when a table is selected.
  • The Design Tab is used for formatting and styling tables, such as adding borders and colors.
  • The Layout Tab focuses on structural modifications like deleting, resizing, and aligning tables.
  • Steps to Delete a Table:
  • Select the table by clicking anywhere inside it.
  • Navigate to the Layout Tab under Table Tools.
  • Click on the "Delete" option and choose "Delete Table."
  • Other Tabs in MS Word:
  • The Insert Tab is used for adding tables, images, charts, and other elements to the document.
  • The File Tab provides access to document settings, saving, sharing, and printing options.
  • The Edit Tab is not present in MS Word; editing features are distributed across other tabs like Home and Layout.
  • Keyboard Shortcut to Delete a Table:
  • Press Ctrl+A to select the table and then hit the Delete key.
  • This method is quick and does not require navigation to the Layout Tab.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 630

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following shortcut keys is used to make Centre-aligned text in MS-Word 365?

  1. AOption (a)

    Ctrl + E

  2. BOption (b)

    Ctrl + R

  3. COption (c)

    Ctrl + J

  4. DOption (d)

    Ctrl + C

View answer & explanation

Correct answer

Answer: (a)A.

Ctrl + E

Why this answer is correct

The correct answer is Ctrl + E.

Key Points

  • Ctrl + E is the shortcut key used to center-align text in Microsoft Word.
  • It allows users to quickly align text to the center of the page without manually adjusting alignment options in the toolbar.
  • This shortcut is commonly used for formatting titles, headings, and other text elements that require central alignment.
  • Microsoft Word provides various alignment shortcuts like Ctrl + L (Left Alignment), Ctrl + R (Right Alignment), and Ctrl + J (Justify Alignment).
  • These shortcuts enhance efficiency and productivity, especially in document formatting tasks.

Additional Information

  • Text Alignment in MS Word:
  • MS Word provides four primary text alignment options: Left, Right, Center, and Justify.
  • Alignment affects the positioning of text in relation to the margins of a document.
  • Other Common Shortcut Keys:
  • Ctrl + L: Aligns text to the left margin.
  • Ctrl + R: Aligns text to the right margin.
  • Ctrl + J: Justifies the text, ensuring it is evenly distributed across both margins.
  • Ctrl + C: Copies selected text or elements.
  • Benefits of Shortcut Keys:
  • Shortcut keys save time and improve efficiency while working on documents.
  • They allow users to perform tasks without navigating through menus or toolbars.
  • MS Word Versions:
  • The shortcut keys mentioned are consistent across most versions of MS Word, including Word 365.
  • Word 365 is the cloud-based version of Microsoft Word, offering advanced collaboration and accessibility features.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 631

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS word 365, While working with the text the thesaurus tool is used for:

  1. AOption (a)

    finding repeated words in the document 

  2. BOption (b)

    corrects misspelling word

  3. COption (c)

    correct the format of the text

  4. DOption (d)

    check for synonyms and antonyms

View answer & explanation

Correct answer

Answer: (d)D.

check for synonyms and antonyms

Why this answer is correct

The correct answer is check for synonyms and antonyms.

Key Points

  • The thesaurus tool in MS Word 365 helps users find synonyms (words with similar meanings) and antonyms (words with opposite meanings).
  • It aids in enhancing the vocabulary used in the document by suggesting alternative words.
  • The tool can be accessed by right-clicking on a word and selecting "Synonyms" or by using the Review tab.
  • It is particularly useful for avoiding repetitive words and making the text more engaging and varied.

Additional Information

  • Microsoft Word 365
  • Part of the Microsoft Office 365 suite, Word is a word processing application that allows users to create, edit, and format text documents.
  • It offers various tools such as spell check, grammar check, and a thesaurus to assist in writing and editing documents.
  • MS Word 365 is cloud-based, enabling users to access and collaborate on documents from any device with internet connectivity.
  • It includes advanced features like real-time collaboration, which allows multiple users to work on a document simultaneously.
  • Thesaurus Tool
  • A thesaurus is a reference tool that provides a list of words grouped together according to similarity of meaning (synonyms) and sometimes opposite meanings (antonyms).
  • In MS Word, the thesaurus helps improve the quality of writing by offering alternative words to enhance the text.
  • It is useful for expanding vocabulary, avoiding word repetition, and making the document more dynamic and interesting.
  • Using the thesaurus can also aid in better articulation of ideas and more effective communication.
  • Other Tools in MS Word 365
  • Spell Check: Identifies and corrects spelling errors in the document.
  • Grammar Check: Provides suggestions for correcting grammatical errors, improving sentence structure, and ensuring proper punctuation.
  • Formatting Tools: Allows users to change the appearance of the text, such as font type, size, color, and paragraph alignment.
  • Track Changes: A feature that records all changes made to a document, useful for editing and collaboration.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 632

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What feature in Microsoft Word 365 allows you to create a numbered list with different levels of indentation?

  1. AOption (a)

    Multi-hierarchy numbering

  2. BOption (b)

    Multi-indenting numbering

  3. COption (c)

    Multilevel numbering 

  4. DOption (d)

    Multi-spaced numbering

View answer & explanation

Correct answer

Answer: (c)C.

Multilevel numbering 

Why this answer is correct

The correct answer is Multilevel numbering.

Key Points

  • Multilevel numbering allows you to create a hierarchy in your numbered lists, making it easier to organize sections, subsections, and points within documents.
  • It helps in providing structure and clarity, especially in lengthy documents such as reports, manuals, and complex proposals.
  • This feature is highly customizable, allowing users to modify the numbering style, indentation, and format according to their specific needs.
  • Multilevel numbering can be applied to both numbered and bulleted lists, making it versatile for various types of content organization.

Additional Information

  • Numbered List:
  • A numbered list is a sequence of items each preceded by a number. It is used to present information in a specific order or sequence.
  • In Microsoft Word, you can create numbered lists by selecting the list option from the toolbar and choosing the desired numbering style.
  • Bulleted List:
  • A bulleted list is a sequence of items each preceded by a bullet point (
  • ). It is used to present information where the order is not important.
  • Bulleted lists can be created in Microsoft Word by selecting the bullet list option from the toolbar and choosing the preferred bullet style.
  • Indentation:
  • Indentation refers to the space between the margin of the page and the text. Indentation is used to show the hierarchical relationship between different levels of text.
  • In multilevel numbering, indentation is used to visually distinguish between different levels of the list.
  • Customization:
  • Microsoft Word allows extensive customization of multilevel lists. Users can choose different numbering formats, change indentation levels, and apply different styles to different levels of the list.
  • Customization options can be accessed through the Multilevel List menu in the Paragraph group on the Home tab.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 633

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365 how can you add a specific number of days to a date in Excel?

  1. AOption (a)

    Using the EDATE function

  2. BOption (b)

    Using the WORKDAY function

  3. COption (c)

    Using the DAY function

  4. DOption (d)

    Using the DATE function

View answer & explanation

Correct answer

Answer: (d)D.

Using the DATE function

Why this answer is correct

The correct answer is Using the DATE function.

Key Points

  • The DATE function in Excel is used to create a date from individual year, month, and day components.
  • To add a specific number of days to a date, you can use the formula: =DATE(YEAR(start_date), MONTH(start_date), DAY(start_date) + number_of_days).
  • This function is versatile as it automatically adjusts the month and year values if the day value exceeds the number of days in a month.
  • Using the DATE function ensures that the resulting date is valid and correctly formatted.

Additional Information

  • EDATE function
  • The EDATE function is used to add or subtract months from a given date.
  • It is not suitable for adding a specific number of days.
  • Syntax: =EDATE(start_date, months)
  • Example: =EDATE("01-Jan-2023", 1) will return 01-Feb-2023.
  • WORKDAY function
  • The WORKDAY function is used to return a date that is a specified number of working days before or after a given date.
  • It excludes weekends and optionally holidays.
  • Syntax: =WORKDAY(start_date, days, [holidays])
  • Example: =WORKDAY("01-Jan-2023", 5) will exclude weekends and return a date 5 working days after 01-Jan-2023.
  • DAY function
  • The DAY function returns the day of the month as a number from 1 to 31.
  • It is used to extract the day part of a date.
  • Syntax: =DAY(date)
  • Example: =DAY("15-Jan-2023") will return 15.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 634

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, Which of the following charts in MS Excel shows the change of magnitude over a period of time? 

  1. AOption (a)

    Line chart

  2. BOption (b)

    Area chart

  3. COption (c)

    Bar chart 

  4. DOption (d)

    Pie chart

View answer & explanation

Correct answer

Answer: (b)B.

Area chart

Why this answer is correct

The correct answer is Area chart.

Key Points

  • An Area chart is used to represent quantitative data graphically.
  • It displays the magnitude of change over time using filled areas below the line segments.
  • This type of chart is useful for showing the trend of data over intervals of time or categories.
  • Area charts emphasize the magnitude of values and help in understanding the overall volume of the dataset.

Additional Information

  • Line Chart
  • A line chart is a type of chart which displays information as a series of data points called 'markers' connected by straight line segments.
  • It is one of the most common types of charts and is useful for showing trends over time.
  • Line charts are typically used to track changes over short and long periods of time.
  • They are particularly useful for visualizing data trends and comparing different sets of data.
  • Bar Chart
  • A bar chart is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.
  • Bar charts are used to compare different categories of data.
  • They are ideal for showing the relative sizes of different categories.
  • Bar charts can be plotted vertically or horizontally.
  • Pie Chart
  • A pie chart is a circular statistical graphic, which is divided into slices to illustrate numerical proportion.
  • Each slice of the pie chart represents a category and the size of each slice is proportional to the quantity it represents.
  • Pie charts are best used when you are trying to compare parts of a whole.
  • They are not suitable for showing changes over time.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 635

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following options allows you to change page orientation in MS Word 365? 

  1. AOption (a)

    Paragraph alignment

  2. BOption (b)

    Margins

  3. COption (c)

    Page layout

  4. DOption (d)

    Page break

View answer & explanation

Correct answer

Answer: (c)C.

Page layout

Why this answer is correct

The correct answer is Page layout.

Key Points

  • The Page Layout tab in MS Word 365 is specifically designed to handle the layout and formatting of the document.
  • Under the Page Layout tab, you will find options to change the page orientation between Portrait and Landscape.
  • This tab also allows you to adjust margins, page size, and other layout settings, ensuring your document looks exactly as you want it to.
  • Changing the page orientation can be crucial for documents that contain wide tables, images, or need a different layout for presentation purposes.

Additional Information

  • Paragraph Alignment:
  • Paragraph alignment refers to the positioning of text within a paragraph, such as left, right, center, or justified.
  • This option is found under the Home tab and affects the alignment of text within the paragraph, but does not change the page orientation.
  • Margins:
  • Margins are the blank spaces around the edges of the page where text and other content do not appear.
  • You can adjust margins under the Page Layout tab, but this does not change the page orientation.
  • Page Break:
  • A page break is a marker in a document that tells the printer or display device where to start a new page.
  • Inserting a page break is useful for controlling the flow of content, but it does not affect page orientation.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 636

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following keyboard shortcut keys is used to copy the selected text in MSWord 365?

  1. AOption (a)

    Ctrl + X

  2. BOption (b)

    Ctrl + V

  3. COption (c)

    Ctrl + C

  4. DOption (d)

    Ctrl + P

View answer & explanation

Correct answer

Answer: (c)C.

Ctrl + C

Why this answer is correct

The correct answer is Ctrl + C.

Key Points

  • The keyboard shortcut Ctrl + C is used to copy the selected text or item in MS Word 365.
  • When you press Ctrl + C, the selected text or item is copied to the clipboard.
  • The copied text or item can then be pasted elsewhere using the Ctrl + V shortcut.
  • This shortcut is universally used across most applications including MS Word, Excel, PowerPoint, and many others for copying content.

Additional Information

  • Clipboard:
  • The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
  • When you copy or cut text or an item, it is stored on the clipboard until you paste it somewhere.
  • The clipboard usually can hold only one item at a time, but more advanced clipboard managers can store multiple items.
  • Ctrl + X:
  • This shortcut is used to cut the selected text or item.
  • When you cut a text or item, it is removed from its original location and stored on the clipboard.
  • You can then paste the cut item somewhere else using Ctrl + V.
  • Ctrl + V:
  • This shortcut is used to paste the text or item that is currently stored on the clipboard.
  • It can be used to paste content that was copied or cut previously.
  • It is one of the most commonly used shortcuts in text editing and data manipulation.
  • Ctrl + P:
  • This shortcut is used to open the print dialog in most applications.
  • It allows the user to print the current document, image, or file.
  • In MS Word, it opens the print settings where you can choose the printer, number of copies, and other printing options.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 637

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, the VLOOKUP function in Microsoft Excel is primarily used for:

  1. AOption (a)

    searching for a value in a table and returning a corresponding value 

  2. BOption (b)

    finding the total of a range

  3. COption (c)

    creating pivot tables

  4. DOption (d)

    calculating percentages

View answer & explanation

Correct answer

Answer: (a)A.

searching for a value in a table and returning a corresponding value 

Why this answer is correct

The correct answer is searching for a value in a table and returning a corresponding value.

Key Points

  • The VLOOKUP function stands for Vertical Lookup and is used to search for a value in the first column of a table or range and return a value in the same row from a specified column.
  • This function is useful when you need to find specific information in large spreadsheets, such as retrieving employee names based on their ID numbers.
  • VLOOKUP requires four

Arguments:

the value to search for, the range to search within, the column number of the value to return, and a logical value to indicate exact or approximate match.

  • VLOOKUP is especially useful in database-like scenarios where data is organized in columns and you need to retrieve related information.

Additional Information

  • Range: A range in Excel is a collection of two or more cells. This can be a single row, a single column, or multiple rows and columns.
  • Column Index Number: The column index number is the number of the column in the range from which to retrieve the value. For example, if you want to retrieve the value from the third column of the range, you would use 3 as the column index number.
  • Exact vs. Approximate Match: The fourth argument in VLOOKUP is a logical value indicating whether to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. If FALSE, VLOOKUP will find an exact match.
  • Error Handling: If VLOOKUP cannot find the value you are looking for, it returns the #N/A error. This can be handled using the IFERROR function to provide a default value or message.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 638

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following statements is FALSE regarding attaching a file in an email?

  1. AOption (a)

    The size of the attachment is unlimited.

  2. BOption (b)

    Attachments can be previewed within the email composition window. 

  3. COption (c)

    You can remove or change attachments before sending the email.

  4. DOption (d)

    Multiple files can be attached in an email message. 

View answer & explanation

Correct answer

Answer: (a)A.

The size of the attachment is unlimited.

Why this answer is correct

The correct answer is The size of the attachment is unlimited..

Key Points

  • Most email providers impose a limit on the size of attachments that can be sent. This limit is usually around 25MB for services like Gmail.
  • If your attachment exceeds the size limit, you may need to use a file-sharing service or cloud storage like Google Drive or Dropbox.
  • Email attachments can be previewed within the email composition window before sending.
  • Users have the ability to remove or change attachments before sending an email.
  • Multiple files can be attached in a single email message, provided the total size does not exceed the provider's limit.

Additional Information

  • Email Attachment
  • An email attachment is a computer file sent along with an email message. One or more files can be attached to any email message, and be sent along with it to the recipient.
  • Attachments can include documents, images, videos, and other types of files.
  • Attachment Size Limitations
  • Most email services have a maximum size limit for attachments. For example, Gmail allows attachments up to 25MB per email. If the size exceeds this limit, users are advised to use cloud storage services.
  • Outlook limits attachments to 20MB, while Yahoo Mail has a limit of 25MB.
  • Previewing Attachments
  • Many email services allow users to preview attachments within the email composition window. This helps in ensuring that the correct files are attached before sending.
  • Removing or Changing Attachments
  • Users can remove or change attachments before sending an email. This is typically done by clicking on the attachment and selecting the option to remove it or by adding a new file.
  • Multiple Attachments
  • Users can attach multiple files to a single email message. However, the combined size of all attachments must not exceed the maximum size limit set by the email provider.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 639

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is an example of internet service provider?

  1. AOption (a)

    Outlook

  2. BOption (b)

    Airtel

  3. COption (c)

    Google

  4. DOption (d)

    Mozilla

View answer & explanation

Correct answer

Answer: (b)B.

Airtel

Why this answer is correct

The correct answer is Airtel.

Key Points

  • Airtel is a leading global telecommunications company with operations in 18 countries across South Asia and Africa.
  • It is known for providing various services such as mobile services, fixed line services, broadband, and digital TV services.
  • Airtel is one of the largest mobile operators in the world with over 400 million subscribers.
  • It offers a wide range of internet services, including high-speed broadband and 4G/5G connectivity, making it a prominent internet service provider.

Additional Information

  • Internet Service Provider (ISP)
  • An Internet Service Provider (ISP) is a company that provides individuals and organizations access to the internet and other related services such as website building and virtual hosting.
  • ISPs use a range of technologies to provide internet access to users, including dial-up, DSL, cable modem, fiber-optics, wireless, and dedicated high-speed interconnects.
  • Some well-known ISPs include companies like AT&T, Comcast, Verizon, and in India, Airtel, Jio, and BSNL.
  • ISPs may also provide additional services such as email services, domain registration, and web hosting.
  • Email Providers
  • Email providers are services that offer users the ability to send and receive electronic mail (email) through the internet.
  • Popular email providers include Outlook (by Microsoft), Gmail (by Google), Yahoo Mail, and many others.
  • Web Browsers
  • Web browsers are software applications used to access and view websites and other content on the internet.
  • Common web browsers include Mozilla Firefox, Google Chrome, Microsoft Edge, and Safari.
  • Search Engines
  • Search engines are tools that allow users to search for information on the internet by entering keywords or phrases.
  • Google is one of the most widely used search engines globally, alongside others like Bing, Yahoo, and Baidu.
Delhi Police Constable (Executive) 2023 Official Paper (Held On 01 Dec, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 640

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is the purpose of the "Zoom" icon in Microsoft Word 365?

  1. AOption (a)

    To delete the current page

  2. BOption (b)

    To adjust the visual appearance of our document to suit our reading or editing needs

  3. COption (c)

    To increase the font size

  4. DOption (d)

    To change the document's page layout 

View answer & explanation

Correct answer

Answer: (b)B.

To adjust the visual appearance of our document to suit our reading or editing needs

Why this answer is correct

The correct answer is to adjust the visual appearance of our document to suit our reading or editing needs.

Key Points

  • The Zoom icon in Microsoft Word 365 is used to control the magnification level of our document, making it larger or smaller on the screen.
  • It helps in adjusting the document view to make reading or editing more comfortable depending on our preference.
  • We can zoom in to get a closer view of the text or zoom out to see more of the page layout at once.
  • This feature is particularly useful when working with detailed documents or when we have vision difficulties.

Additional Information

  • Zoom Slider: Located at the bottom right corner of the Word window, this slider allows us to quickly adjust the zoom level by dragging the slider or clicking the plus (+) or minus (-) buttons.
  • Zoom Dialog Box: We can access more zoom options by clicking on the percentage value next to the zoom slider or by selecting "Zoom" from the "View" tab. This dialog box provides predefined zoom levels, a custom zoom option, and settings to fit the document to the window width, page width, or select multiple pages view.
  • Reading Mode: This feature optimizes the document layout for easier reading, removing unnecessary visual elements and adjusting the zoom level to fit the screen. We can activate it from the "View" tab or the status bar.
  • Print Layout vs. Web Layout: The Zoom feature works in conjunction with different layout views. In Print Layout, we see the document as it would appear when printed, while in Web Layout, the document adapts to fit the screen width, useful for documents intended for online viewing.
  • Page Width and Text Width: Options in the Zoom dialog allow us to fit the document to the width of the page or the width of the text, providing flexibility in how we view our content.

How should I prepare for Computer Knowledge in Delhi Police Constable?

Solving previous year questions by topic helps identify recurring concepts, question patterns, and frequently asked sub-topics. Attempt each question, review the step-by-step explanation, and note down key formulas or facts for quick revision before the exam.