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 561–580 of 1030Page 29 of 52
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 561

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following keyboard shortcut keys is used to cut the selected text in MS-Word 365?

  1. AOption (a)

    Ctrl + c 

  2. BOption (b)

    Ctrl + x

  3. COption (c)

    Ctrl + p 

  4. DOption (d)

    Ctrl + v

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl + x

Why this answer is correct

The correct answer is Ctrl + x.

Key Points

  • In MS Word, the keyboard shortcut Ctrl + x is used to cut the selected text or object, removing it from its current location and placing it on the clipboard.
  • This action allows users to move text or objects to another location within the document or to a different document by using the paste function.
  • Cutting text or objects is part of the basic editing functionalities provided by most word processors, including MS Word.
  • After cutting, the user can paste the content using the Ctrl + v shortcut, which inserts the content from the clipboard to the desired location.

Additional Information

  • Clipboard:
  • The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
  • It stores the data until the user decides to paste it somewhere else.
  • In most operating systems, the clipboard can hold one item at a time.
  • Copy vs Cut:
  • Copying (Ctrl + c) duplicates the selected text or object without removing it from its original location.
  • Cutting (Ctrl + x) removes the selected text or object from its original location, placing it on the clipboard.
  • Both actions allow the user to paste the content elsewhere using the paste function (Ctrl + v).
  • Paste Function:
  • The paste function (Ctrl + v) inserts the content from the clipboard to the current cursor location.
  • This function allows users to move or duplicate content within or between documents.
  • Keyboard Shortcuts:
  • Keyboard shortcuts enhance productivity by allowing users to perform actions quickly without using a mouse.
  • Common shortcuts include Ctrl + c (copy), Ctrl + x (cut), Ctrl + v (paste), Ctrl + z (undo), and Ctrl + y (redo).
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 562

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What does the Uniform Resource Locator (URL) specify?

  1. AOption (a)

    HTML

  2. BOption (b)

    Unique address assigned to each web resource 

  3. COption (c)

    ISP

  4. DOption (d)

    Internet protocol

View answer & explanation

Correct answer

Answer: (b)B.

Unique address assigned to each web resource 

Why this answer is correct

The correct answer is Unique address assigned to each web resource.

Key Points

  • Uniform Resource Locator (URL) is a reference or address used to access resources on the internet.
  • URLs are used to specify the location of a web resource on a computer network and a mechanism for retrieving it.
  • The format of a URL is defined in RFC 1738 by the Internet Engineering Task Force (IETF).
  • A URL typically consists of the protocol (such as HTTP or HTTPS), the domain name, and the path to the resource.
  • Examples include https://www.example.com or ftp://ftp.example.com/file.txt.

Additional Information

  • Components of a URL:
  • Protocol: Indicates the method used to access the resource, such as HTTP, HTTPS, FTP.
  • Domain Name: The human-readable address of the server hosting the resource, e.g., www.example.com.
  • Path: Specifies the exact location of the resource on the server, e.g., /folder/file.html.
  • Query String: Provides additional parameters for accessing dynamic content, e.g., ?id=123.
  • Fragment Identifier: Directs the browser to a specific part of a resource, e.g., #section2.
  • HTTP vs. HTTPS:
  • HTTP: HyperText Transfer Protocol, the standard protocol for transferring web pages.
  • HTTPS: Secure version of HTTP, encrypts data between the client and server.
  • HTTPS is critical for protecting sensitive data during online transactions.
  • Domain Name System (DNS):
  • DNS translates human-readable domain names into IP addresses.
  • It functions like the internet's phone book, ensuring proper routing of web traffic.
  • Common URL Schemes:
  • HTTP: For accessing web pages.
  • HTTPS: Secure web page access.
  • FTP: File Transfer Protocol for downloading/uploading files.
  • MAILTO: For email addresses.
  • FILE: For accessing files on the local system.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 563

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Word 365 Which of the following best describes the use of justify text?

  1. AOption (a)

    To align evenly along left margins

  2. BOption (b)

    To align evenly along right margins

  3. COption (c)

    To center the text

  4. DOption (d)

    To align evenly along left and right margins

View answer & explanation

Correct answer

Answer: (d)D.

To align evenly along left and right margins

Why this answer is correct

The correct answer is To align evenly along left and right margins.

Key Points

  • Justify text in MS Word 365 aligns text evenly along both the left and right margins.
  • This feature ensures that the text blocks have a clean and professional appearance by eliminating uneven edges.
  • It is commonly used in formal documents, newspapers, and magazines to create a uniform look.
  • Justification involves adjusting the spacing between words and characters to achieve this balanced alignment.

Additional Information

  • Text Alignment Options in MS Word:
  • Left Align: Aligns text to the left margin, leaving a ragged right edge.
  • Right Align: Aligns text to the right margin, leaving a ragged left edge.
  • Center Align: Centers the text evenly between the left and right margins.
  • Justify: Aligns text evenly along both left and right margins, adjusting spacing as necessary.
  • Applications of Justified Text:
  • Widely used in newspapers, books, and magazines for a clean look.
  • Often used in formal documents and publications.
  • Considerations When Justifying Text:
  • Can create large gaps between words if not handled properly.
  • Hyphenation can be used to minimize spacing issues.
  • Hyphenation in MS Word:
  • Helps to reduce the uneven spacing in justified text.
  • Automatically splits words at the end of lines to improve text flow.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 564

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following is the correct option to open an existing spread sheet in MS-Excel?

  1. AOption (a)

    Click on File tab<<Click on Open

  2. BOption (b)

    Click on File tab<<Click on New

  3. COption (c)

    Click on Home tab<<Click on New

  4. DOption (d)

    Click on Home tab<<Click on Open

View answer & explanation

Correct answer

Answer: (a)A.

Click on File tab<<Click on Open

Why this answer is correct

The correct answer is Click on File tab<<Click on Open.

Key Points

  • Opening an existing spreadsheet in MS Excel 365 begins with clicking on the File tab.
  • After clicking the File tab, users should then select Open from the menu options.
  • The Open option allows users to access and choose from recently opened files or browse their computer for the desired spreadsheet.
  • The File tab is located at the top-left corner of the Excel interface, providing a gateway to various file-related operations.

Additional Information

  • File Tab in MS Excel
  • The File tab is part of the Ribbon interface introduced in Microsoft Office 2007.
  • It provides access to the Backstage view, where users can perform file management tasks like saving, opening, and printing documents.
  • The Backstage view also includes options for account settings, managing document properties, and Excel options.
  • Excel Ribbon Interface
  • The Ribbon is a set of toolbars at the top of the Excel window, designed to help users quickly find commands they need to complete tasks.
  • It includes multiple tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View.
  • Each tab contains related command groups, making it easier to access various functionalities.
  • Opening Files in Excel
  • Users can open files stored locally on their computer, on OneDrive, or other cloud storage services integrated with Excel.
  • Excel supports various file formats, including .xlsx, .xls, .csv, and more.
  • In addition to the File tab, users can open files by dragging and dropping them into the Excel window.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 565

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which Microsoft Excel view allows you to see how the printed worksheet will look before actually printing it? 

  1. AOption (a)

    Full Screen view

  2. BOption (b)

    Page Layout view

  3. COption (c)

    Print Preview

  4. DOption (d)

    Normal view

View answer & explanation

Correct answer

Answer: (c)C.

Print Preview

Why this answer is correct

The correct answer is Print Preview.

Key Points

  • Print Preview in MS Excel 365 allows users to see exactly how the printed worksheet will look before printing.
  • This feature helps users to make adjustments to the layout, margins, and other page settings.
  • Users can access Print Preview by going to the File tab and selecting Print.
  • Print Preview displays the worksheet in a read-only format, preventing accidental edits while previewing.
  • It provides options to scale the worksheet to fit the page, adjust orientation, and select specific pages to print.

Additional Information

  • Full Screen View
  • Full Screen View in Excel provides a larger view of the worksheet by hiding the Ribbon and status bar.
  • It is useful for presentations or focusing on data without distractions from the interface elements.
  • Page Layout View
  • Page Layout View shows how the worksheet will appear when printed, including margins, headers, and footers.
  • This view is useful for adjusting the layout and ensuring all content fits within the printable area.
  • Normal View
  • Normal View is the default view in Excel, displaying the worksheet in a standard grid format.
  • This view is used for regular data entry and analysis without focusing on print layout.
  • Scaling Options
  • Scaling options in Print Preview allow users to fit the worksheet to a specific number of pages.
  • Options include "Fit Sheet on One Page," "Fit All Columns on One Page," and "Fit All Rows on One Page."
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 566

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following options allows you to choose whether to keep or discard the formatting of pasted text in MS Word 365?

  1. AOption (a)

    Font Selection

  2. BOption (b)

    Cut and Paste

  3. COption (c)

    Paste Special

  4. DOption (d)

    Format Painter 

View answer & explanation

Correct answer

Answer: (c)C.

Paste Special

Why this answer is correct

The correct answer is Paste Special.

Key Points

  • The "Paste Special" feature in MS Word 365 allows users to choose whether to keep or discard the formatting of the pasted text.
  • This function provides various options, including pasting text only, pasting with source formatting, or merging formatting with the destination document.
  • Users can access "Paste Special" by right-clicking in the document where they want to paste the text and selecting "Paste Special" from the context menu.
  • It helps maintain consistency in document formatting and is particularly useful when copying text from different sources or applications.
  • "Paste Special" supports other formats such as HTML, Unicode, and RTF, offering flexibility in handling different types of content.

Additional Information

  • Clipboard
  • The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
  • It can store text, images, files, and other types of data.
  • In most operating systems, the clipboard supports a single item at a time.
  • Clipboard managers can extend its functionality by storing multiple items and providing more control over clipboard content.
  • Format Painter
  • The Format Painter tool in MS Word allows users to copy formatting from one part of the document to another.
  • It can be used to copy font style, size, color, and other formatting attributes.
  • To use the Format Painter, select the text with the desired formatting, click the Format Painter icon, and then select the text to apply the formatting to.
  • This tool helps ensure consistency in document formatting.
  • Cut, Copy, and Paste
  • These are basic editing functions available in most text editors and word processors.
  • Cut removes the selected content from its original location, while Copy creates a duplicate without removing the original.
  • Paste inserts the content from the clipboard to the desired location.
  • These functions are typically accessed via keyboard shortcuts or context menus.
  • Rich Text Format (RTF)
  • RTF is a standardized format for text files that includes formatting information such as font styles, sizes, and colors.
  • It was developed by Microsoft to facilitate the exchange of text documents between different word processors.
  • RTF files can be opened and edited by various text editors, maintaining the original formatting.
  • It provides a balance between plain text and fully formatted documents.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 567

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS-Word 365, which action allows you to duplicate selected text and place a copy of it on the clipboard? 

  1. AOption (a)

    Select All

  2. BOption (b)

    Cut

  3. COption (c)

    Paste

  4. DOption (d)

    Copy

View answer & explanation

Correct answer

Answer: (d)D.

Copy

Why this answer is correct

The correct answer is Copy.

Key Points

  • The Copy command in MS-Word 365 creates a duplicate of the selected text and places it on the clipboard without removing it from its original location.
  • This action allows the user to paste the copied text multiple times in different locations within the document or into other documents.
  • The shortcut key for the Copy command is Ctrl+C on Windows and Cmd+C on Mac.
  • The copied text can be pasted using the Paste command, which is associated with the shortcut keys Ctrl+V on Windows and Cmd+V on Mac.

Additional Information

  • Clipboard
  • The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
  • It supports text, images, files, and other types of data.
  • Most operating systems provide clipboard functionality to facilitate the copy-paste operations.
  • Cut
  • The Cut command removes the selected text or object from its original location and places it on the clipboard.
  • The shortcut key for the Cut command is Ctrl+X on Windows and Cmd+X on Mac.
  • Paste
  • The Paste command inserts the content from the clipboard into the current location of the cursor.
  • The shortcut key for the Paste command is Ctrl+V on Windows and Cmd+V on Mac.
  • Shortcut Keys
  • Shortcut keys are combinations of keys that provide quick access to certain functions within software.
  • They enhance productivity by reducing the need for mouse clicks and navigation through menus.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 568

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following windows is used when we want to write an email in Gmail?

  1. AOption (a)

    Compose

  2. BOption (b)

    Send

  3. COption (c)

    Spam

  4. DOption (d)

    Draft

View answer & explanation

Correct answer

Answer: (a)A.

Compose

Why this answer is correct

The correct answer is Compose.

Key Points

  • The Compose window in Gmail is used to create and write new emails.
  • It allows users to add recipients, subject lines, and the body content of the email.
  • Users can attach files, insert links, and format the text within the Compose window.
  • The window provides options to send, save as draft, or discard the email.
  • It is accessible by clicking the "Compose" button, typically located on the left sidebar of the Gmail interface.

Additional Information

  • Send
  • The "Send" button in the Compose window is used to dispatch the email to the specified recipients.
  • Once clicked, the email is moved from the Drafts folder to the Sent folder in Gmail.
  • Users can schedule emails to be sent at a later time using the "Send" button's dropdown menu.
  • Draft
  • Emails that are started but not sent are automatically saved in the "Drafts" folder.
  • Users can access the Drafts folder to continue editing or send the email at a later time.
  • Spam
  • The "Spam" folder in Gmail contains emails that are suspected to be unwanted or harmful.
  • Gmail automatically filters and moves emails identified as spam to this folder.
  • Users can manually mark emails as spam or remove them from the Spam folder if they are not junk.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 569

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is the default font when a new blank document is created in MS Word 365?

  1. AOption (a)

    Calibri

  2. BOption (b)

    Times New Roman

  3. COption (c)

    Arial

  4. DOption (d)

    Cambria

View answer & explanation

Correct answer

Answer: (a)A.

Calibri

Why this answer is correct

The correct answer is Calibri.

Key Points

  • Calibri is the default font in Microsoft Word 365 since the release of Office 2007.
  • The font was designed by Lucas de Groot, a Dutch type designer, and commissioned by Microsoft.
  • Calibri is a sans-serif typeface, known for its modern and clean appearance.
  • It was created to take advantage of ClearType, a Microsoft technology designed to improve the readability of text on LCD monitors.
  • Calibri has since become widely recognized and used across various Microsoft applications and documents.

Additional Information

  • ClearType Technology
  • ClearType is a font rendering technology developed by Microsoft to enhance the readability of text on LCD screens.
  • It works by optimizing the sub-pixel rendering on LCD monitors, making text appear sharper and more readable.
  • ClearType is especially effective on smaller font sizes, improving the overall user experience.
  • Other Default Fonts in Microsoft Office
  • Before Calibri, Times New Roman was the default font in older versions of Microsoft Word.
  • Other default fonts in various Microsoft Office applications include Cambria for Microsoft PowerPoint and Consolas for Visual Studio.
  • Font Types
  • Serif Fonts: These fonts have small lines or strokes regularly attached to the end of a larger stroke in a letter or symbol within the font family, e.g., Times New Roman.
  • Sans-Serif Fonts: These fonts do not have the additional lines or strokes added, offering a cleaner look, e.g., Calibri, Arial.
  • Calibri Font Family
  • The Calibri font family includes Calibri Light, Calibri, Calibri Light Italic, Calibri Italic, Calibri Bold, and Calibri Bold Italic.
  • This variety allows for greater flexibility and consistency in document formatting and design.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 28 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 570

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365 which of the following is an example of absolute reference pointing to cell A1 in MS Excel?

  1. AOption (a)

    $A$1 

  2. BOption (b)

    A1

  3. COption (c)

    @A1 

  4. DOption (d)

    1A

View answer & explanation

Correct answer

Answer: (a)A.

$A$1 

Why this answer is correct

The correct answer is $A$1.

Key Points

  • In MS Excel, an absolute reference is a reference that remains constant, even if the formula is copied to another cell.
  • The syntax for an absolute reference includes a dollar sign ($) before the column letter and row number, such as **$A$1**.
  • $A$1 refers to cell A1 and will not change when copied or filled to other cells.
  • Absolute references are useful when you want to maintain the reference to a specific cell in formulas, despite changes in the location of the formula.

Additional Information

  • Relative References
  • Relative references change when a formula is copied to another cell. For example, a reference to cell A1 changes to B1 when copied one cell to the right.
  • Mixed References
  • Mixed references contain a dollar sign either before the column letter or the row number, but not both. For example, $A1 or A$1.
  • Mixed references are partially fixed and partially relative.
  • Creating Absolute References
  • To create an absolute reference in a formula, press F4 after selecting the cell reference in the formula.
  • Use Cases
  • Absolute references are commonly used in financial modeling, data analysis, and any scenario requiring consistent reference points in calculations$.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 571

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following MS Excel charts compares different items of data that change over a period of time with categories arranged on the horizontal axis and values ​​on the vertical axis?

  1. AOption (a)

    Line chart

  2. BOption (b)

    Column chart

  3. COption (c)

    Pie chart

  4. DOption (d)

    Bar chart

View answer & explanation

Correct answer

Answer: (b)B.

Column chart

Why this answer is correct

The correct answer is Column Chart.

Key Points

  • A column chart is a type of chart used to compare different items of data that change over a period of time.
  • In this chart, categories are arranged in the horizontal axis and values ​​in the vertical axis.
  • Column chart helps in making the visual representation of data easy and clear.
  • This chart is very useful for analyzing various time series data.
  • Column charts are easy to create in MS Excel 365 and can be customized using chart tools.

Additional Information

  • Line chart
  • Line charts are used to show trends in data that change over time.
  • Data points are connected by lines.
  • Pie chart
  • A pie chart is a circular chart that shows the proportion of different parts of a data set.
  • The size of each section reflects the proportion of the data.
  • Bar chart
  • A bar chart is similar to a column chart but with categories arranged on the vertical axis and values ​​on the horizontal axis.
  • This chart is useful for comparing and analyzing data.
  • Data visualization
  • The purpose of data visualization is to present data in a graphical format so that it can be easily understood.
  • This makes the decision-making process simpler and more effective.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 572

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, how can we change page orientation in Print Preview?

  1. AOption (a)

    By using Show Margins

  2. BOption (b)

    By using Page Setup dialog box 

  3. COption (c)

    By using Zoom

  4. DOption (d)

    By using Print dialog box

View answer & explanation

Correct answer

Answer: (b)B.

By using Page Setup dialog box 

Why this answer is correct

The correct answer is By using Page Setup dialog box.

Key Points

  • The Page Setup dialog box in MS Excel 365 allows users to adjust various settings for printing, including page orientation.
  • To access the Page Setup dialog box, go to the File tab, click on Print, and then click on Page Setup at the bottom of the Print options.
  • Within the Page Setup dialog box, users can select between Portrait and Landscape orientation under the Page tab.
  • This feature is essential for ensuring that the printed document fits well on the selected paper size and layout.
  • Other options available in the Page Setup dialog box include adjusting margins, scaling, and paper size, providing comprehensive control over the printing format.

Additional Information

  • Print Preview
  • Print Preview allows users to see how the document will look when printed, ensuring that all elements are correctly placed and formatted.
  • Users can access Print Preview by going to the File tab and selecting Print, which displays the document preview on the right side.
  • Page Orientation
  • Page orientation refers to the direction in which a document is printed, either Portrait (vertical) or Landscape (horizontal).
  • Choosing the correct orientation is crucial for readability and presentation, especially for documents with tables and wide charts.
  • Show Margins
  • In the Print Preview, the Show Margins option allows users to adjust the margins of the document visually.
  • By clicking and dragging the margin guides, users can fine-tune the print layout directly from the preview screen.
  • Zoom
  • The Zoom feature in Print Preview helps users to enlarge or reduce the view of the document to check details closely.
  • It does not affect the actual size of the printed document but helps in reviewing the layout and content.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 573

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following parts of the email contains the address of the sender and recipient?

  1. AOption (a)

    Body

  2. BOption (b)

    Header

  3. COption (c)

    Footer

  4. DOption (d)

    Complimentary close

View answer & explanation

Correct answer

Answer: (b)B.

Header

Why this answer is correct

The correct answer is Header.

Key Points

  • The header of an email contains essential information such as the sender's email address and the recipient's email address.
  • It also includes the subject line, which provides a brief summary of the email's content.
  • The header may contain timestamps, indicating when the email was sent and received.
  • Other technical details in the header include the email's path through various mail servers.

Additional Information

  • Body: The body of an email contains the main message content, including text, images, and attachments.
  • Footer: The footer typically includes the sender's contact information, legal disclaimers, or any additional notes.
  • Complimentary Close: This is a polite way to end the email, often including phrases like "Best regards" or "Sincerely."
  • Email Protocols: Common protocols for sending and receiving emails include SMTP (Simple Mail Transfer Protocol) and IMAP (Internet Message Access Protocol).
  • Spam Filters: These are used to detect unsolicited and unwanted emails, filtering them out of a user’s inbox.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 574

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which wireless technology allows devices to connect to the internet within the limited range of a wireless router? 

  1. AOption (a)

    DSL

  2. BOption (b)

    LTE

  3. COption (c)

    Wi-Fi

  4. DOption (d)

    3G

View answer & explanation

Correct answer

Answer: (c)C.

Wi-Fi

Why this answer is correct

The correct answer is Wi-Fi.

Key Points

  • Wi-Fi stands for Wireless Fidelity and is a technology that allows devices to connect to the internet wirelessly within the range of a wireless router.
  • It operates over radio waves, typically in the 2.4 GHz and 5 GHz bands, to transmit data.
  • Wi-Fi is widely used in homes, offices, and public places like cafes and airports to provide internet access.
  • Most modern devices, including smartphones, laptops, and tablets, are equipped with Wi-Fi capabilities to connect to wireless networks.

Additional Information

  • Wireless Router
  • A wireless router is a device that provides access to the internet or a private computer network.
  • It uses radio waves to transmit data and can support multiple devices simultaneously.
  • Most routers come with built-in security features like firewalls and encryption to protect the network.
  • Wi-Fi Standards
  • Wi-Fi standards are developed by the IEEE (Institute of Electrical and Electronics Engineers).
  • Common standards include 802.11a, 802.11b, 802.11g, 802.11n, and 802.11ac, each offering different speeds and ranges.
  • Hotspot
  • A hotspot is a physical location where people can access the internet via Wi-Fi.
  • Hotspots can be found in public places like cafes, airports, hotels, and libraries.
  • Internet Service Provider (ISP)
  • An ISP is a company that provides internet access to users.
  • ISPs supply the necessary infrastructure, such as cables and routers, to connect users to the internet.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 575

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the general functionality of Mail Merge in the MS-Word 365? 

  1. AOption (a)

    To restore the deleted emails

  2. BOption (b)

    To delete and remove bulk emails

  3. COption (c)

    To create and receive bulk emails

  4. DOption (d)

    To create and send bulk emails

View answer & explanation

Correct answer

Answer: (d)D.

To create and send bulk emails

Why this answer is correct

The correct answer is To create and send bulk emails.

Key Points

  • Mail Merge is a feature in MS-Word 365 that allows users to create personalized bulk emails or letters.
  • It automates the process of sending the same document to multiple recipients with customized details for each recipient.
  • Users can import a list of recipients from various data sources, such as Excel spreadsheets or databases.
  • Mail Merge is commonly used for mass communication in business, marketing, and personal correspondence to ensure each recipient receives a customized message.

Additional Information

  • Components of Mail Merge
  • Main Document: The template that contains the generic content and placeholders for personalized information.
  • Data Source: The file or database that contains the information to be merged into the main document, such as names and addresses.
  • Merge Fields: Placeholders in the main document that correspond to the data fields in the data source.
  • Steps in Mail Merge
  • Step 1: Select the main document type (e.g., letters, emails).
  • Step 2: Choose the data source and import recipient information.
  • Step 3: Insert merge fields into the main document.
  • Step 4: Preview the merged document to ensure accuracy.
  • Step 5: Complete the merge to generate personalized documents or emails.
  • Applications of Mail Merge
  • Creating personalized marketing emails or newsletters.
  • Sending invitations, announcements, or notifications to multiple recipients.
  • Generating bulk letters for business communications or direct mail campaigns.
  • Benefits of Mail Merge
  • Increases efficiency by automating repetitive tasks.
  • Ensures consistency and accuracy in mass communication.
  • Allows for easy customization and personalization of documents.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 576

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which area in MS-Word 365 contains icons for common tasks and actions, providing quick access to frequently used commands?

  1. AOption (a)

    Status Bar 

  2. BOption (b)

    Ribbon 

  3. COption (c)

    Navigation Pane 

  4. DOption (d)

    Quick Access Toolbar 

View answer & explanation

Correct answer

Answer: (d)D.

Quick Access Toolbar 

Why this answer is correct

The correct answer is Quick Access Toolbar.

Key Points

  • The Quick Access Toolbar is a customizable toolbar in MS Word 365 that provides quick access to frequently used commands.
  • It is located above the Ribbon or can be moved below the Ribbon for easier access.
  • Common commands such as Save, Undo, Redo, and Print are typically found on the Quick Access Toolbar by default.
  • Users can add or remove commands based on their preferences to streamline their workflow.

Additional Information

  • Ribbon
  • The Ribbon is a set of toolbars at the top of the MS Word 365 interface, organized into tabs that group related commands.
  • Each tab on the Ribbon includes different tools and options related to specific tasks, such as Home, Insert, Design, Layout, References, and Review.
  • The Ribbon is dynamic and changes based on the task being performed, allowing users to access the tools they need quickly.
  • Status Bar
  • The Status Bar is located at the bottom of the MS Word 365 window and provides information about the current document, such as page number, word count, and language.
  • Users can customize the Status Bar to display additional information like line number, column number, and document views.
  • Navigation Pane
  • The Navigation Pane in MS Word 365 helps users quickly navigate through the document using headings, pages, or search results.
  • It can be accessed from the View tab or by pressing Ctrl+F on the keyboard.
  • The Navigation Pane is particularly useful for working with long documents, allowing users to jump to specific sections easily.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 577

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the definition of a workbook in Microsoft Excel 365?

  1. AOption (a)

    A workbook is a group of cells. 

  2. BOption (b)

    A workbook is a group of worksheets. 

  3. COption (c)

    A workbook is a group of blocks. 

  4. DOption (d)

    A workbook is a group of rows

View answer & explanation

Correct answer

Answer: (b)B.

A workbook is a group of worksheets. 

Why this answer is correct

The correct answer is A workbook is a group of worksheets..

Key Points

  • A workbook in Microsoft Excel 365 is a file that contains one or more worksheets, allowing users to organize, calculate, and analyze data.
  • Each workbook can contain multiple sheets, each identified by a tab at the bottom of the workbook window.
  • Worksheets within a workbook can be linked to each other through formulas and references, enabling complex data analysis.
  • Users can add, delete, rename, and move worksheets within a workbook, providing flexibility in data management.
  • Excel workbooks are saved with the file extension .xlsx, which is the standard format for Excel files in Microsoft Excel 365.

Additional Information

  • Worksheet:
  • A worksheet is a single sheet within a workbook containing cells organized in rows and columns.
  • Each cell can hold data such as text, numbers, or formulas.
  • Worksheets are used for various tasks like data entry, calculations, and data analysis.
  • Cell:
  • A cell is the intersection of a row and a column in a worksheet.
  • Cells are identified by their column letter and row number, e.g., A1, B2.
  • Cells can contain text, numbers, formulas, and functions.
  • Formula:
  • A formula is an expression entered in a cell that performs calculations on data in other cells.
  • Formulas begin with an equal sign (=) followed by the calculation, e.g., =A1+B1.
  • Formulas can include functions like SUM, AVERAGE, and VLOOKUP.
  • Function:
  • A function is a predefined calculation in Excel that simplifies complex mathematical operations.
  • Functions are used within formulas to perform specific tasks, e.g., =SUM(A1:A10).
  • Excel provides a wide range of functions for different purposes, including statistical, financial, and logical functions.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 578

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is used in MS Word 365 to split text into two or more columns? 

  1. AOption (a)

    Rows

  2. BOption (b)

    Columns

  3. COption (c)

    Margins

  4. DOption (d)

    Orientation

View answer & explanation

Correct answer

Answer: (b)B.

Columns

Why this answer is correct

The correct answer is Columns.

Key Points

  • Columns in MS Word 365 allow users to split text into two or more columns, making it easier to create newspaper-style layouts.
  • This feature can be accessed from the 'Layout' tab in the Ribbon, under the 'Columns' dropdown menu.
  • Users can choose from preset column options such as one, two, three, left, or right.
  • Columns can be customized further by selecting 'More Columns' for additional settings like column width and spacing.
  • Utilizing columns enhances the readability and organization of text-heavy documents.

Additional Information

  • Paragraph Formatting:
  • MS Word provides various paragraph formatting options such as alignment, line spacing, and indentation to structure the text effectively.
  • These options are available under the 'Home' tab in the 'Paragraph' group.
  • Page Layout:
  • The 'Layout' tab allows users to adjust page margins, orientation, size, and columns.
  • These settings help in defining the overall structure and appearance of the document.
  • Section Breaks:
  • Section breaks allow the user to divide a document into sections, each with its own layout settings.
  • This feature is useful for applying different column settings to different parts of a document.
  • Headers and Footers:
  • Headers and footers can be added to include information such as page numbers, dates, and titles.
  • These elements are accessible under the 'Insert' tab and enhance the document's professional appearance.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 579

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which option is used to paste copied text at a specific location in Microsoft Word 365?

  1. AOption (a)

    Paste As Hyperlink 

  2. BOption (b)

    Paste Link

  3. COption (c)

     Paste Special

  4. DOption (d)

    Paste Destination Styles

View answer & explanation

Correct answer

Answer: (c)C.

 Paste Special

Why this answer is correct

The correct answer is Paste Special.

Key Points

  • Paste Special is a feature in Microsoft Word that allows users to paste copied content in a variety of formats.
  • It provides options like pasting as text, HTML, RTF, Unicode, or even as a picture.
  • This feature is useful for maintaining the original formatting or choosing a specific format for the pasted content.
  • The Paste Special option can be accessed from the Home tab under the Paste dropdown or by using the keyboard shortcut Ctrl + Alt + V.
  • It offers more control over how the copied content is integrated into the document.

Additional Information

  • Clipboard
  • The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
  • It is used to transfer data between applications or within an application.
  • In Microsoft Word, the clipboard can hold multiple items at once.
  • Users can view the clipboard contents by opening the Clipboard pane from the Home tab.
  • Formatting Options
  • When pasting content, users can choose to keep source formatting, merge formatting, or keep text only.
  • These options help in maintaining the consistency of the document's appearance.
  • The choice of formatting affects the overall look and feel of the document.
  • Other Paste Options
  • Paste as Hyperlink allows users to paste the copied text as a hyperlink.
  • Paste Link creates a link to the source content, which updates automatically if the source changes.
  • Paste Destination Styles matches the formatting of the pasted text to the destination document's style.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 1) (Previous Year Paper)·Computer Awareness
View full paper

Question 580

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the shortcut key to initiate a spelling check in Microsoft Word 365?

  1. AOption (a)

    F8

  2. BOption (b)

    F7

  3. COption (c)

    F5

  4. DOption (d)

    F6

View answer & explanation

Correct answer

Answer: (b)B.

F7

Why this answer is correct

The correct answer is F7.

Key Points

  • The shortcut key to initiate a spelling check in Microsoft Word 365 is F7.
  • Pressing F7 in Microsoft Word will open the Spelling and Grammar dialog box, allowing users to check and correct spelling and grammar errors in the document.
  • This function helps ensure that the document is free of spelling and grammatical errors before it is shared or published.
  • F7 is a commonly used shortcut across different versions of Microsoft Word for spell checking.
  • Using keyboard shortcuts like F7 can enhance efficiency and productivity when working with documents.

Additional Information

  • Grammar Check:
  • In addition to spelling, Microsoft Word also includes a grammar check feature that can be accessed via the same F7 shortcut.
  • The grammar checker helps identify issues such as subject-verb agreement, sentence fragments, and incorrect punctuation.
  • Proofing Options:
  • Microsoft Word allows users to customize proofing options under the "File" menu, then "Options", and "Proofing".
  • Users can enable or disable different types of checks, such as ignoring words in uppercase or checking for contextual spelling errors.
  • Other Useful Shortcuts:
  • Ctrl + A: Selects all content in the document.
  • Ctrl + C: Copies the selected content to the clipboard.
  • Ctrl + V: Pastes the content from the clipboard.
  • Ctrl + Z: Undoes the last action.
  • Microsoft Editor:
  • Microsoft Editor is an advanced AI-powered service that offers additional writing assistance, including style suggestions and readability checks.
  • It can be accessed via the "Review" tab and complements the built-in spelling and grammar checker.

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.