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 601–620 of 1030Page 31 of 52
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 601

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following types of networking is used to connect all the computers within a school or within an office? 

  1. AOption (a)

    Metropolitan Area Network

  2. BOption (b)

    Personal Area Network 

  3. COption (c)

    Wide Area Network

  4. DOption (d)

    Local Area Network

View answer & explanation

Correct answer

Answer: (d)D.

Local Area Network

Why this answer is correct

The correct answer is Local Area Network.

Key Points

  • A Local Area Network (LAN) is a type of network designed to connect computers and devices within a localized area such as schools, offices, or homes.
  • LANs are typically confined to a single building or a group of buildings and are used to share resources like files, printers, and internet access efficiently.
  • They are characterized by high data transfer speeds and low latency compared to other types of networks.
  • LANs can be established using wired connections (e.g., Ethernet) or wireless connections (e.g., Wi-Fi), depending on the network requirements.
  • LANs are crucial for enabling communication and collaboration in environments such as educational institutions, corporate offices, and small businesses.

Additional Information

  • Metropolitan Area Network (MAN):
  • A MAN is a network that spans a city or a large campus, linking multiple LANs together.
  • It is larger than a LAN but smaller than a Wide Area Network (WAN).
  • Examples include networks connecting offices in a city or university campuses spread over a large area.
  • Wide Area Network (WAN):
  • A WAN is a network that covers a broad geographical area, such as a country or even continents.
  • The internet itself is the largest example of a WAN.
  • It often uses telecommunications infrastructure like leased lines, satellite links, or fiber optics.
  • Personal Area Network (PAN):
  • A PAN is a very small network used for personal devices like smartphones, laptops, and wearable devices.
  • Examples include Bluetooth connections and USB tethering.
  • Advantages of LAN:
  • LANs offer cost-effective and efficient resource sharing, such as printers and centralized data storage.
  • They are secure due to limited coverage and controlled access points.
  • Maintenance and troubleshooting are easier due to the localized nature of the network.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 602

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the full form of email?

  1. AOption (a)

    Express mail 

  2. BOption (b)

    Efficient mail

  3. COption (c)

    Electro mail 

  4. DOption (d)

    Electronic mail

View answer & explanation

Correct answer

Answer: (d)D.

Electronic mail

Why this answer is correct

The correct answer is Electronic mail.

Key Points

  • Electronic mail (email) is a method of exchanging messages between people using electronic devices.
  • It was first developed in the 1960s and became widely used in the 1990s with the advent of the Internet.
  • Email allows users to send and receive text, multimedia files, and attachments globally within seconds.
  • It operates via internet protocols such as SMTP (Simple Mail Transfer Protocol) for sending messages and IMAP/POP for receiving them.
  • Email is one of the most widely used forms of communication, with billions of users worldwide.

Additional Information

  • SMTP (Simple Mail Transfer Protocol): It is a protocol used to send emails from one server to another.
  • IMAP (Internet Message Access Protocol): It allows users to access and manage their emails directly on the server, enabling synchronization across multiple devices.
  • POP (Post Office Protocol): It downloads emails from the server to a device and typically deletes them from the server after downloading.
  • Email clients such as Microsoft Outlook, Gmail, and Yahoo Mail provide interfaces for users to access and manage their emails.
  • Email is a fundamental component of modern communication, used in personal, professional, and academic contexts.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 603

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, Which option is typically used to save a new spreadsheet for the first time? 

  1. AOption (a)

    Save and New

  2. BOption (b)

    Save and Print 

  3. COption (c)

    Save As 

  4. DOption (d)

    Close

View answer & explanation

Correct answer

Answer: (c)C.

Save As 

Why this answer is correct

The correct answer is Save As.

Key Points

  • Save As is the option used in MS Excel 365 to save a new spreadsheet file for the first time or to save an existing file with a new name or location.
  • It allows users to specify the file format, location, and name of the spreadsheet before saving.
  • Accessible via the File tab in the Ribbon, followed by selecting "Save As."
  • In Excel 365, users can save files to local drives, OneDrive, or other cloud storage services.
  • Using "Save As" ensures a copy of the file is created while retaining the original file if it already exists.

Additional Information

  • File Formats in Excel: Excel files can be saved in various formats, including .xlsx, .xls, .csv, .txt, and .pdf, depending on user requirements.
  • AutoSave Feature: Excel 365 includes an AutoSave feature that automatically saves changes to files stored in OneDrive or SharePoint.
  • Quick Access Toolbar: Users can add a "Save As" shortcut to the Quick Access Toolbar for faster access.
  • Cloud Integration: Excel 365 supports seamless saving and sharing of files through Microsoft’s cloud services like OneDrive and SharePoint.
  • Version History: Excel 365 allows users to access previous versions of a file saved in OneDrive or SharePoint, which is helpful for tracking changes or recovering data.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 604

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is used to select the entire paragraph in MS - Word 365?

  1. AOption (a)

    Triple - click

  2. BOption (b)

    Double - click 

  3. COption (c)

    Scroll 

  4. DOption (d)

    Single - click

View answer & explanation

Correct answer

Answer: (a)A.

Triple - click

Why this answer is correct

The correct answer is Triple-click.

Key Points

  • Triple-click is used to select an entire paragraph in MS Word 365 or other versions of Microsoft Word.
  • When a user triple-clicks anywhere within a paragraph, the entire paragraph is selected automatically.
  • This method is a quick and efficient way to select large blocks of text without the need for dragging the cursor.
  • The feature works consistently in all versions of Microsoft Word, making it a standard functionality.
  • This is particularly useful for editing, formatting, or copying entire paragraphs in a document.

Additional Information

  • Other selection shortcuts in MS Word:
  • Single-click: Places the cursor at the clicked position in the text.
  • Double-click: Selects a single word where the cursor is positioned.
  • Ctrl + A: Selects the entire content of the document.
  • Paragraph selection via keyboard: Place the cursor at the beginning of the paragraph, then press Ctrl + Shift + Down Arrow to select the entire paragraph.
  • Scroll and drag: While clicking and holding, dragging the mouse over the content can also select multiple paragraphs, but it is less precise than triple-clicking.
  • Microsoft Word 365 features: Includes various tools for text selection, formatting, and editing that are user-friendly and time-saving.
  • Use of selection: Helps in formatting, copying, cutting, or applying styles to specific text sections efficiently.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 605

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

The keyboard shortcut ________ is used to create bullets in MS Word 2010.

  1. AOption (a)

    Ctrl + Shift + B

  2. BOption (b)

    Ctrl + Shift + L 

  3. COption (c)

    Ctrl + Alt + L

  4. DOption (d)

    Ctrl + Alt + B

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl + Shift + L 

Why this answer is correct

The correct answer is Ctrl + Shift + L.

Key Points

  • The keyboard shortcut Ctrl + Shift + L is used to create bullets in MS Word 2010.
  • This shortcut allows users to quickly apply a bulleted list format to their selected text.
  • It is a time-saving feature for formatting text in documents, particularly for creating organized lists.
  • Bullets can be customized in MS Word through the "Define New Bullet" option available under the "Bullets" section in the "Home" tab.
  • This shortcut is consistent across multiple versions of MS Word, ensuring familiarity for users.

Additional Information

  • Bulleted Lists in MS Word:
  • Bulleted lists are used to present information in a concise and organized way.
  • The "Bullets" option is located under the "Paragraph" group in the "Home" tab in MS Word.
  • Users can choose from a variety of bullet styles, including symbols, images, and custom designs.
  • Bulleted lists are often used in presentations, resumes, and reports.
  • Keyboard Shortcuts in MS Word:
  • Shortcuts are designed to enhance productivity by reducing the time spent navigating menus.
  • Examples: Ctrl + B for bold, Ctrl + U for underline, and Ctrl + I for italicize.
  • Custom shortcuts can also be defined by users via the "Customize Ribbon" or "Keyboard Shortcuts" options.
  • Customization of Bullets:
  • In the "Define New Bullet" option, users can select symbols, pictures, or fonts to create unique bullet styles.
  • This feature allows for greater flexibility and personalization in document formatting.
  • MS Word Versions:
  • The shortcut Ctrl + Shift + L is functional in MS Word 2010 and later versions.
  • Some older versions of MS Word may use different methods for applying bullets.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 606

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following shorcut key is used to convert the selected font to subscript in MS Word 365?

  1. AOption (a)

    Shift + = 

  2. BOption (b)

    Ctrl + + 

  3. COption (c)

    Ctrl + = 

  4. DOption (d)

    Shift + +

View answer & explanation

Correct answer

Answer: (c)C.

Ctrl + = 

Why this answer is correct

The correct answer is Ctrl + =.

Key Points

  • Ctrl + = is the shortcut key used to convert the selected font to subscript in MS Word 365.
  • Subscript formatting is commonly used in chemical formulas, mathematical expressions, and scientific notations (e.g., H2O).
  • This shortcut allows users to quickly apply subscript formatting without navigating through menus.
  • To remove subscript formatting, you can use the same shortcut key (Ctrl + =) as a toggle.
  • Shortcut keys significantly enhance productivity by reducing the time spent on formatting tasks in MS Word.

Additional Information

  • Subscript and Superscript:
  • Subscript: Text appears below the baseline, often used in formulas (e.g., H2O).
  • Superscript: Text appears above the baseline, commonly used in exponents (e.g., x2).
  • Shortcut for Superscript: Use Ctrl + Shift + = to apply superscript formatting in MS Word.
  • Other Formatting Shortcuts:
  • Ctrl + B: Bold text.
  • Ctrl + I: Italicize text.
  • Ctrl + U: Underline text.
  • Customizing Shortcuts: MS Word allows users to customize shortcut keys through the "Customize Ribbon" and "Keyboard Shortcuts" options in the settings.
  • Accessibility: Shortcut keys help improve accessibility for users who rely on keyboard navigation or have limited use of a mouse.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 607

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which is the following options defines the ‘Clipboard’ in Microsoft Word 365? 

  1. AOption (a)

    Accessing the internet 

  2. BOption (b)

    Changing font settings

  3. COption (c)

    Creating hyperlinks

  4. DOption (d)

    Storing and managing copied or cut text and objects

View answer & explanation

Correct answer

Answer: (d)D.

Storing and managing copied or cut text and objects

Why this answer is correct

The correct answer is Storing and managing copied or cut text and objects.

Key Points

  • The Clipboard in Microsoft Word 365 is a temporary storage area where text, images, or objects that are cut or copied are stored.
  • It allows users to paste the stored content into the same document, another document, or even a different application.
  • The Clipboard can hold up to 24 items in Microsoft Office applications, enabling users to manage multiple copied elements simultaneously.
  • It is accessible via the Home tab in the Ribbon interface, under the "Clipboard" group, or by using Ctrl + C (copy) and Ctrl + X (cut) commands.
  • The Clipboard is an essential feature for editing and formatting documents efficiently, saving time during repetitive tasks.

Additional Information

  • Cut, Copy, and Paste:
  • Cut: Removes selected content from its original location and stores it in the Clipboard (shortcut: Ctrl + X).
  • Copy: Duplicates selected content without removing it from the original location and stores it in the Clipboard (shortcut: Ctrl + C).
  • Paste: Inserts the content stored in the Clipboard into a new location (shortcut: Ctrl + V).
  • Office Clipboard:
  • The Office Clipboard is an enhanced version of the standard Windows Clipboard, allowing users to store and manage multiple items simultaneously.
  • It can store up to 24 items, including text, images, and other objects from Microsoft Office applications.
  • System Clipboard:
  • The System Clipboard is a feature in operating systems like Windows and macOS, enabling users to cut, copy, and paste content across various applications.
  • Unlike the Office Clipboard, the System Clipboard typically stores only one item at a time.
  • Clipboard Shortcuts:
  • Ctrl + C: Copy selected content to the Clipboard.
  • Ctrl + X: Cut selected content to the Clipboard.
  • Ctrl + V: Paste content from the Clipboard into the current location.
  • Ctrl + Alt + V: Opens the Paste Special dialog box in Microsoft Word for advanced pasting options.
  • Clipboard History (Windows 10/11):
  • Windows 10 and Windows 11 introduced a Clipboard History feature, allowing users to access previously copied items by pressing Windows + V.
  • This feature must be enabled in system settings to function and supports pinning frequently used items for quick access.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 608

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, Which of the following is used to open a save dialog box in MS - Excel? 

  1. AOption (a)

    View -> save

  2. BOption (b)

    Home -> save

  3. COption (c)

    Data -> save

  4. DOption (d)

    File -> save

View answer & explanation

Correct answer

Answer: (d)D.

File -> save

Why this answer is correct

The correct answer is File -> Save.

Key Points

  • In MS Excel 365, the "File" menu provides access to various essential functionalities, including saving a file.
  • The "Save" option under the File menu opens the dialog box to save the current workbook or file.
  • Users can choose the desired file format, such as .xlsx, .csv, or others, while saving through the dialog box.
  • In addition to saving manually, Excel also includes an AutoSave feature to prevent accidental data loss.
  • The "File -> Save" option is universally recognized across different versions of MS Excel.

Additional Information

  • File Menu Overview:
  • The File menu in MS Excel includes options like New, Open, Save, Save As, Print, and Close.
  • It serves as a hub for managing workbook settings and exporting files.
  • AutoSave Feature:
  • AutoSave is available for files stored in OneDrive or SharePoint.
  • It automatically saves changes as users work on their files.
  • Keyboard Shortcut for Saving:
  • The shortcut Ctrl + S is widely used to save files in MS Excel.
  • This provides a quick and efficient way to save work without navigating the menu.
  • Save As Functionality:
  • The "Save As" option allows users to save a file with a different name or format.
  • It is useful for creating backups or converting files to different formats.
  • File Extensions in MS Excel:
  • .xlsx is the default file format for Excel workbooks.
  • .xls is the older format used in previous versions of Excel.
  • .csv is used for saving data in a comma-separated values format.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 609

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

The thesaurus tool in MS word 365 is used for ________. 

  1. AOption (a)

    finding similar words in the document

  2. BOption (b)

    checking for nouns and verbs 

  3. COption (c)

    checking for synonyms and antonyms

  4. DOption (d)

    finding repeated words in the document

View answer & explanation

Correct answer

Answer: (c)C.

checking for synonyms and antonyms

Why this answer is correct

The correct answer is checking for synonyms and antonyms.

Key Points

  • The Thesaurus tool in MS Word 365 is primarily used to find synonyms and antonyms of words to improve vocabulary and writing quality.
  • It helps users to replace repetitive or unsuitable words with more appropriate alternatives, enhancing the document's readability.
  • This feature is especially useful for writers, students, and professionals aiming to refine their written communication.
  • Users can access the Thesaurus tool by right-clicking a word and selecting "Synonyms" or by navigating to the Review Tab → Thesaurus in the ribbon.
  • The tool integrates with Microsoft Office's dictionary to provide a list of related words, ensuring contextual relevance.

Additional Information

  • Synonyms: Words that have similar meanings, e.g., "happy" and "joyful," are referred to as synonyms. These are commonly used to avoid repetition in writing.
  • Antonyms: Words that have opposite meanings, e.g., "hot" and "cold," are useful for providing contrast or clarity in text.
  • The Thesaurus tool is different from the Spelling & Grammar Check, which focuses on correcting spelling errors and grammatical mistakes.
  • Other tools in MS Word like Word Count and Find/Replace are complementary features but serve different purposes, such as tracking document length or replacing specific terms.
  • Microsoft Office 365 regularly updates its features, ensuring that the Thesaurus tool provides accurate and extensive suggestions based on current language usage trends.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 610

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Excel 365, which type of sorting places values from smallest to largest? 

  1. AOption (a)

    Ascending order

  2. BOption (b)

    Random order 

  3. COption (c)

    Descending order 

  4. DOption (d)

    Alphanumeric order

View answer & explanation

Correct answer

Answer: (a)A.

Ascending order

Why this answer is correct

The correct answer is Ascending order.

Key Points

  • Ascending order sorting places values from the smallest to the largest.
  • This type of sorting is commonly used for numerical data such as integers, decimals, or dates.
  • In Microsoft Excel, ascending order is achieved by selecting the "Sort A-Z" option for text or "Sort Smallest to Largest" for numbers.
  • Ascending order is often used in data analysis for easier identification of minimum values or chronological arrangement.
  • It is the opposite of descending order, which arranges values from largest to smallest.

Additional Information

  • Descending Order: A sorting method that arranges values from the largest to the smallest.
  • Alphanumeric Sorting: A type of sorting where values are arranged based on both letters and numbers. For example, "A1, A2, B1, B2."
  • Custom Sorting: Excel allows users to create custom sorting criteria to organize data based on specific preferences.
  • Sorting by Columns: Excel provides functionality to sort data not only by rows but also by columns for advanced data organization.
  • Multi-Level Sorting: Excel enables users to sort data by multiple fields simultaneously, such as sorting by date first and then by name.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 611

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Among the following, under which tab will you find the Bullets and Numbering in MS - Word 365? 

  1. AOption (a)

    Page Layout

  2. BOption (b)

    Insert 

  3. COption (c)

    Home 

  4. DOption (d)

    References

View answer & explanation

Correct answer

Answer: (c)C.

Home 

Why this answer is correct

The Correct answer is Home Tab.

Key Points

  • In MS Word 365, the Bullets and Numbering feature is located in the Home Tab.
  • This feature is used to create organized lists for better readability and formatting.
  • The Bullets option allows users to create unordered lists with symbols or icons, while the Numbering option provides ordered lists with numerical or alphabetical sequences.
  • Both options are available under the Paragraph group in the Home Tab.
  • The Home Tab is primarily used for basic text formatting, such as font style, size, alignment, and applying bullets or numbering.
  • Using Bullets and Numbering enhances the presentation and clarity of textual content, making it suitable for structured documents like reports, notes, or lists.
  • Shortcut: Users can also access Bullets and Numbering quickly using keyboard shortcuts or by right-clicking and selecting the respective option from the context menu.

 Additional Information

  • Page Layout Tab
  • The Page Layout Tab is primarily used for managing the page formatting such as margins, orientation, size, and line spacing.
  • This tab also includes options for themes, page borders, and watermarks.
  • It is not designed for features like bullets or numbering, which are related to text formatting.
  • Insert Tab
  • The Insert Tab is used to add elements like tables, images, shapes, charts, headers, footers, and page numbers into a document.
  • This tab focuses on enriching the content visually rather than formatting text or creating lists.
  • References Tab
  • The References Tab deals with creating citations, bibliographies, captions, and table of contents.
  • It is specifically designed for academic or professional documents that require references or indexing.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 612

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

When composing a new e-mail, what is the usual place to enter the e-mail address of the primary recipient?

  1. AOption (a)

    Body of the email

  2. BOption (b)

    ‘CC’ field

  3. COption (c)

    Subject line

  4. DOption (d)

    ‘To’ field

View answer & explanation

Correct answer

Answer: (d)D.

‘To’ field

Why this answer is correct

The Correct answer is 'To' field.

Key Points

  • The 'To' field is specifically designed to hold the email addresses of the primary recipients.
  • When composing an email, the addresses in the 'To' field are considered the main recipients of the message.
  • The primary recipients in the 'To' field are expected to take action or respond to the email content.
  • The 'To' field is the first and most prominent field when composing an email, ensuring clarity about who the email is directed to.
  • Modern email clients, including Gmail, Outlook, and Yahoo Mail, universally use the 'To' field for the primary recipient's email address.
  • Other fields like 'CC' and 'BCC' are used for secondary recipients or for confidential communications, but the 'To' field remains reserved for the main recipient.
  • Emails sent using the 'To' field clearly indicate to the recipient that they are the intended audience of the message.
  • The 'To' field is usually mandatory, as an email cannot be sent without specifying at least one valid recipient in this field.

 Additional Information

  • 'CC' field
  • The 'CC' field stands for Carbon Copy, and it is used to send a copy of the email to additional recipients.
  • Recipients in the 'CC' field are not expected to take action but are included for informational purposes.
  • Emails sent to the 'CC' field are visible to all recipients listed in the 'To' and 'CC' fields.
  • Subject Line
  • The Subject Line is used to specify the topic or purpose of the email.
  • A well-written Subject Line helps recipients quickly understand the context of the email.
  • This field does not hold email addresses and is not related to identifying recipients.
  • Body of the email
  • The Body of the email is used to write the content or message intended for the recipient.
  • This section allows formatting, attachments, and detailed information but does not hold recipient email addresses.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 613

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following keyboard shortcuts helps you copy data in MS Excel 365? 

  1. AOption (a)

    Ctrl + C

  2. BOption (b)

    Ctrl + Y

  3. COption (c)

    Ctrl + Z 

  4. DOption (d)

    Ctrl + X

View answer & explanation

Correct answer

Answer: (a)A.

Ctrl + C

Why this answer is correct

The Correct answer is Ctrl + C.

Key Points

  • The Ctrl + C shortcut is universally used across various software applications, including MS Excel 365, to copy the selected data or text to the clipboard.
  • In MS Excel, this shortcut allows users to copy the contents of a single cell, a range of cells, or even an entire worksheet for pasting elsewhere.
  • After pressing Ctrl + C, the copied data remains in the clipboard until it is replaced by new content or until the system is restarted.
  • This shortcut enhances productivity by enabling quick duplication of data without requiring manual re-entry.
  • When you use Ctrl + C, the selected cells are highlighted with a moving dashed border, indicating the data is ready to be pasted.
  • The copied data can be pasted using the Ctrl + V shortcut in the desired location within the same sheet or in another worksheet.

 Additional Information

  • Ctrl + Y
  • The Ctrl + Y shortcut is used to redo the last action that was undone in MS Excel or other Microsoft Office applications.
  • This shortcut is helpful in scenarios where users mistakenly undo an action and want to restore it immediately.
  • For example, if a user deletes content and then undoes the deletion, pressing Ctrl + Y will redo the deletion.
  • Ctrl + Z
  • The Ctrl + Z shortcut is commonly used to undo the last action performed by the user.
  • This is particularly useful for correcting mistakes, such as accidental data entry, formatting changes, or deletions.
  • It can be repeatedly pressed to undo multiple recent actions in reverse order.
  • Ctrl + X
  • The Ctrl + X shortcut is used to cut selected data from its current location and place it on the clipboard.
  • Unlike copying, cutting removes the data from the original location, which can then be pasted elsewhere using Ctrl + V.
  • This is particularly useful for reorganizing data within a worksheet or between different worksheets.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 614

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the purpose of sorting data in Microsoft Excel 365?

  1. AOption (a)

    To create charts and graphs

  2. BOption (b)

    To organise data in a specific order based on values

  3. COption (c)

    To apply formatting to the cells only 

  4. DOption (d)

    To calculate averages of the data

View answer & explanation

Correct answer

Answer: (b)B.

To organise data in a specific order based on values

Why this answer is correct

The Correct answer is To organise data in a specific order based on values.

Key Points

  • In Microsoft Excel 365, sorting data is a feature that helps users arrange data in a logical or systematic order, making it easier to analyze and interpret.
  • Sorting can be performed in ascending or descending order based on numeric values, alphabetical order, or dates.
  • This feature is useful for tasks such as organizing a list of names, sales data, or grades in a meaningful way.
  • Sorting can be applied to a single column or across multiple columns to maintain the integrity of related data.
  • Excel allows users to sort using custom lists, enabling personalized ordering, such as days of the week or months of the year.
  • Sorting is particularly crucial for large datasets, as it improves data visibility and aids in identifying trends or outliers.
  • It is an essential step in data cleaning and preparation for further analysis or visualization tasks, such as creating pivot tables or generating reports.
  • Sorting does not alter the underlying data but reorders it temporarily for better comprehension and usability.

 Additional Information

  • To create charts and graphs
  • This option refers to Excel's charting and graphing capabilities, which allow users to visualize data.
  • Charts and graphs help in representing data in formats such as bar charts, pie charts, or line graphs, making complex data easier to understand.
  • While this is a different feature, sorted data is often a prerequisite for creating accurate and meaningful charts.
  • To apply formatting to the cells only
  • Formatting in Excel involves changing the appearance of data or cells, such as applying bold, italics, colors, or borders.
  • It helps in improving the readability and presentation of the data but does not involve organizing data in a specific order.
  • To calculate averages of the data
  • This option refers to Excel's ability to calculate statistical metrics such as averages, sums, or medians using formulas or built-in functions like AVERAGE().
  • Although averages provide insights into data trends, this function is unrelated to sorting.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 615

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Word 365, what does the ‘B’ icon usually represent? 

  1. AOption (a)

    Bold formatting 

  2. BOption (b)

    Italic formatting

  3. COption (c)

    Page break

  4. DOption (d)

    Bullet points

View answer & explanation

Correct answer

Answer: (a)A.

Bold formatting 

Why this answer is correct

The correct answer is Bold formatting.

Key Points

  • In Microsoft Word 365, the 'B' icon in the toolbar represents the Bold formatting feature.
  • The Bold formatting feature is used to make the selected text thicker and darker, thereby emphasizing it.
  • This feature is part of the Home tab in the Ribbon interface of Microsoft Word and can be applied using the shortcut key Ctrl + B (Windows) or Command + B (Mac).
  • Bold text is often used to draw attention to key points, titles, headings, or any text that needs to stand out.
  • The Bold option can be toggled on or off, allowing users to apply or remove the formatting as needed.
  • This feature is widely used in document formatting, such as resumes, reports, and presentations, to make content visually appealing and easy to read.
  • Other formatting features like Italic and Underline are located adjacent to the Bold icon in the Word toolbar for quick access.

 Additional Information

  • Italic formatting
  • The 'I' icon in Microsoft Word represents Italic formatting.
  • It makes the selected text slanted to the right, often used for emphasizing quotes, titles, or foreign words.
  • The shortcut key for Italic is Ctrl + I (Windows) or Command + I (Mac).
  • Page break
  • A Page break is used to start a new page in a document manually.
  • It is accessed via the Insert tab or the shortcut key Ctrl + Enter.
  • This feature is helpful in organizing content and ensuring proper formatting in long documents.
  • Bullet points
  • The 'Bullets' icon in Microsoft Word is used to create bulleted lists.
  • It helps in structuring information clearly and is located in the Home tab of the Ribbon.
  • Users can select different bullet styles and formats based on their needs.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 616

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which option in the context menu allows you to paste the copied text with formatting removed in Microsoft Word 365?

  1. AOption (a)

    Paste

  2. BOption (b)

    Paste as Plain Text

  3. COption (c)

    Paste Special

  4. DOption (d)

    Paste as Unformatted Text

View answer & explanation

Correct answer

Answer: (b)B.

Paste as Plain Text

Why this answer is correct

The Correct answer is Paste as Plain Text.

Key Points

  • The Paste as Plain Text option allows you to paste the copied text into Microsoft Word 365 while removing any formatting from the source text.
  • This option ensures that the text adopts the default formatting of the destination document, such as font, size, and style.
  • It is particularly useful when copying content from a source with complex formatting, such as web pages or other documents, where the formatting is not required or desirable.
  • You can access this option either through the context menu by right-clicking and selecting it or using the Paste Options button that appears after pasting content.
  • By pasting as plain text, you eliminate the need to manually adjust the formatting, making the process more efficient and time-saving.
  • This feature ensures consistency in your document, especially when working with texts from multiple sources.

 Additional Information

  • Paste
  • The Paste option pastes the copied content into the document, retaining the original formatting of the source.
  • This option is useful when you want to preserve the exact style of the copied content, such as font type, color, and size.
  • However, it may lead to inconsistencies in formatting when working with a document that has a specific style guide.
  • Paste Special
  • The Paste Special option provides advanced paste options, such as pasting content as a picture, HTML, or unformatted text.
  • It is particularly useful for specific scenarios, such as embedding tables or graphical elements.
  • This feature is often accessed through the Edit menu or using a shortcut key combination.
  • Paste as Unformatted Text
  • The Paste as Unformatted Text option is similar to "Paste as Plain Text," but its availability may depend on the specific version of Microsoft Word or system settings.
  • It ensures that the pasted content is stripped of all formatting and aligns with the destination document’s style.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 617

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following is the correct shortcut key used to paste data in MS Excel?

  1. AOption (a)

    Ctrl + C

  2. BOption (b)

    Shift + V 

  3. COption (c)

    Alt + V

  4. DOption (d)

    Ctrl + V

View answer & explanation

Correct answer

Answer: (d)D.

Ctrl + V

Why this answer is correct

The correct answer is Ctrl + V.

Key Points

  • Ctrl + V is the universal shortcut key used for pasting data across various software applications, including MS Excel 365.
  • This shortcut is part of the standard Windows operating system keyboard commands and is widely recognized globally.
  • Using Ctrl + V, users can paste data, formulas, or values into the desired cell or range of cells in MS Excel 365.
  • This shortcut significantly enhances productivity as it eliminates the need to navigate through menus manually.
  • It is particularly helpful when working with large datasets, allowing users to quickly copy and paste data between sheets or workbooks.
  • To use this shortcut, users must first copy the data using Ctrl + C or any other method before pasting it into the desired location.
  • Besides pasting data, Ctrl + V can be used to paste formatting, formulas, or specific aspects of data, depending on the paste options available in MS Excel 365.

 Additional Information

  • Ctrl + C
  • Ctrl + C is used to copy data in MS Excel and other applications.
  • It is the complementary shortcut to Ctrl + V, as copying is the first step before pasting.
  • This shortcut is widely used for duplicating data without altering the original source.
  • Shift + V
  • Shift + V is not a recognized shortcut for pasting data in MS Excel or Windows applications.
  • This shortcut may be used in other specialized software or custom setups, but it is not standard for Excel.
  • Alt + V
  • Alt + V is typically used to access the View menu in Excel and other Windows-based software.
  • It is not associated with the pasting function in MS Excel 365.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 618

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which keyboard shortcut is commonly used to create a new blank document in MS Word 365? 

  1. AOption (a)

    Ctrl + S

  2. BOption (b)

    Ctrl + C

  3. COption (c)

    Ctrl + O 

  4. DOption (d)

    Ctrl + N

View answer & explanation

Correct answer

Answer: (d)D.

Ctrl + N

Why this answer is correct

The Correct answer is Ctrl + N.

Key Points

  • The Ctrl + N keyboard shortcut is used to create a new blank document in MS Word 365.
  • This shortcut is universally recognized and works across most versions of Microsoft Word.
  • It is part of the standard keyboard shortcuts that allow users to quickly perform common tasks, thereby improving productivity and efficiency.
  • Using Ctrl + N eliminates the need to navigate through menus to create a new document, saving time.
  • In addition to MS Word, this shortcut often works in other Microsoft Office applications like Excel and PowerPoint to create new files.
  • Keyboard shortcuts like Ctrl + N enhance the user experience by providing a fast and consistent way to perform operations.
  • For users who frequently work with documents, mastering shortcuts such as Ctrl + N can significantly streamline their workflow.

 Additional Information

  • Ctrl + S
  • Ctrl + S is used to save the current document in MS Word.
  • It is one of the most commonly used shortcuts in Microsoft Office applications to ensure that work is saved and not lost due to unforeseen circumstances.
  • This shortcut is especially important for preventing data loss in case of system crashes or power failures.
  • Ctrl + C
  • Ctrl + C is used to copy selected text or objects in MS Word and other applications.
  • It is part of the basic copy-paste functionality that allows users to duplicate content without rewriting or recreating it.
  • This shortcut is universally recognized and works across multiple platforms, including Windows, macOS, and Linux.
  • Ctrl + O
  • Ctrl + O is used to open an existing document in MS Word.
  • It allows users to quickly navigate to previously saved files, improving accessibility and saving time.
  • This shortcut works across other Microsoft Office applications for opening files like spreadsheets and presentations.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 619

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What does ‘ISP’ stand for in the context of internet access? 

  1. AOption (a)

    International Security Protocol

  2. BOption (b)

    Internet System Protocol 

  3. COption (c)

    Internet Service Provider

  4. DOption (d)

    Internet Security Program

View answer & explanation

Correct answer

Answer: (c)C.

Internet Service Provider

Why this answer is correct

The Correct answer is Internet Service Provider.

Key Points

  • An Internet Service Provider (ISP) is a company or organization that provides individuals, businesses, or other entities with access to the internet.
  • ISPs can offer a variety of services, including broadband connections such as DSL, fiber optics, cable, and satellite internet.
  • ISPs often provide additional services such as email hosting, web hosting, domain registration, and internet security services.
  • They serve as the gateway for users to access content, browse websites, and use online services via the World Wide Web.
  • ISPs can operate at different levels, such as local, regional, national, or even international scales.
  • Some well-known ISPs include Comcast, AT&T, Verizon, BSNL, Airtel, Jio, and Vodafone.
  • The role of ISPs is critical in modern society, enabling functions such as remote work, education, e-commerce, and entertainment.
  • ISPs are also responsible for assigning IP addresses to their clients to facilitate connectivity.

 Additional Information

  • International Security Protocol
  • This option may refer to protocols or measures designed to ensure security in international data communications, but it is unrelated to internet access services.
  • Some widely used security protocols include SSL/TLS (Secure Sockets Layer/Transport Layer Security) for encrypted communication.
  • Internet System Protocol
  • This term is likely a confusion with Internet Protocol (IP), which is a set of rules governing how data is sent over the internet.
  • IP is a fundamental component of internet communication, but it does not represent the term ISP.
  • Internet Security Program
  • This term might refer to software or strategies for ensuring online safety, such as antivirus programs, firewalls, or anti-phishing tools.
  • While important, this is unrelated to the concept of an ISP, which provides internet access.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 30 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 620

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following icons are a part of the Design menu in MS Word 365? 

  1. AOption (a)

    Icons to change themes, colours, fonts, effects and page borders 

  2. BOption (b)

    Icons for zooming in and out, print layout, switching windows and splitting windows 

  3. COption (c)

    Icons for spelling and grammar check, thesaurus and word count

  4. DOption (d)

    Icons to change font size, style, alignment and borders

View answer & explanation

Correct answer

Answer: (a)A.

Icons to change themes, colours, fonts, effects and page borders 

Why this answer is correct

The Correct answer is Icons to change themes, colours, fonts, effects and page borders.

Key Points

  • The Design menu in MS Word 365 is specifically tailored to allow users to enhance the visual appeal of their documents.
  • It includes tools to change themes, colours, fonts, effects, and page borders, helping users create professional and aesthetically pleasing documents.
  • Themes: A theme is a collection of formatting choices like fonts, colours, and effects that are applied consistently throughout the document.
  • Colours: Users can select a predefined colour set or customize the colours in their document to suit their preference or branding requirements.
  • Fonts: The Design menu provides options to choose font styles and sizes that align with the overall design of the document.
  • Effects: These include visual styles applied to shapes, graphics, and text to create a polished look.
  • Page Borders: Users can add borders to the pages of their document, enhancing its structure and appearance.
  • The Design menu is pivotal for creating appealing documents such as brochures, reports, and presentations.

 Additional Information

  • Icons for zooming in and out, print layout, switching windows and splitting windows
  • These icons are part of the View menu in MS Word, which is designed to help users adjust how their document is displayed on the screen.
  • Options like zooming in/out allow users to focus on specific parts of the document.
  • Print layout provides a preview of the document as it will appear when printed.
  • Switching windows and splitting windows enable multitasking and simultaneous editing of multiple sections of a document.
  • Icons for spelling and grammar check, thesaurus and word count
  • These icons belong to the Review menu in MS Word, which is focused on editing and proofreading tools.
  • The spelling and grammar check ensures the document is free of language errors.
  • The thesaurus helps users find synonyms and alternatives for words to enhance writing quality.
  • Word count provides details about the number of words, characters, and pages in the document.
  • Icons to change font size, style, alignment and borders
  • These icons are part of the Home menu in MS Word, which serves as the central hub for formatting text and paragraphs.
  • Font size and style icons allow users to customize text appearance.
  • Alignment icons help structure text in various formats like left, center, right, and justified.
  • Borders options are used for creating visual separation or emphasis in text or tables.

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.