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

Question 581

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which folder in an email client is used to store received emails?

  1. AOption (a)

    Inbox

  2. BOption (b)

    Sent Items

  3. COption (c)

    Drafts

  4. DOption (d)

    Outbox

View answer & explanation

Correct answer

Answer: (a)A.

Inbox

Why this answer is correct

The correct answer is Inbox.

Key Points

  • The Inbox folder in an email client is specifically designed to store and organize all received emails.
  • Emails delivered to a user’s account are automatically routed to the Inbox unless specific filters or rules are applied.
  • The Inbox is the most commonly accessed folder in an email client for reading and managing received messages.
  • Popular email clients like Gmail, Outlook, Yahoo Mail, and Thunderbird use the Inbox as a default location for incoming messages.
  • Advanced email management features such as categorization, flagging, and sorting are applied within the Inbox for better organization.

Additional Information

  • Sent Items: This folder stores emails that have been successfully sent by the user.
  • Drafts: Emails that are composed but not yet sent are saved in the Drafts folder for future editing or sending.
  • Outbox: This temporary folder holds emails that are in the process of being sent or have encountered sending issues.
  • Spam/Junk Folder: Emails identified as unsolicited or potentially harmful are automatically routed to the Spam or Junk folder.
  • Email Filters: Users can set rules within the email client to automatically categorize or move emails to specific folders, bypassing the Inbox.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 582

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the primary function of FTP (File Transfer Protocol)? 

  1. AOption (a)

    Video streaming

  2. BOption (b)

    Browsing websites

  3. COption (c)

    Transferring files between computers

  4. DOption (d)

    Sending emails 

View answer & explanation

Correct answer

Answer: (c)C.

Transferring files between computers

Why this answer is correct

The correct answer is Transferring files between computers.

Key Points

  • FTP (File Transfer Protocol) is a standard network protocol used to transfer files between computers over the Internet or a local network.
  • It operates on a client-server model, where the FTP client initiates a connection with the FTP server to upload, download, or manage files.
  • FTP primarily uses two channels: Command Channel (for sending commands) and Data Channel (for transferring file data).
  • FTP supports both anonymous access (for public data) and authenticated access (requiring login credentials for secure file transfers).
  • It typically runs on port 21 for command communication and dynamically assigns ports for data transfer.

Additional Information

  • Secure File Transfer Protocols:
  • SFTP (SSH File Transfer Protocol): A secure version of FTP that uses SSH for encryption, ensuring data confidentiality.
  • FTPS (FTP Secure): Adds SSL/TLS encryption to FTP for enhanced security during data transfer.
  • Modes of Data Transfer in FTP:
  • Active Mode: The server initiates a connection to the client for data transfer.
  • Passive Mode: The client initiates both command and data connections, often used in firewalled environments.
  • Common FTP Tools:
  • FileZilla: A popular open-source FTP client supporting FTP, SFTP, and FTPS.
  • WinSCP: A Windows tool for FTP, SFTP, and SCP file transfers.
  • Limitations of FTP:
  • Traditional FTP lacks encryption, making data vulnerable during transfer.
  • It is considered less secure compared to modern file transfer protocols like SFTP or HTTPS.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 583

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following options is NOT used to set page margins in MS Word 365?

  1. AOption (a)

    Left

  2. BOption (b)

    Header

  3. COption (c)

    Bottom

  4. DOption (d)

    Right

View answer & explanation

Correct answer

Answer: (b)B.

Header

Why this answer is correct

The correct answer is Header.

Key Points

  • In MS Word, page margins define the space between the text and the edges of the page.
  • Page margins can be set for the Top, Bottom, Left, and Right of the document through the "Layout" tab.
  • The Header is not considered part of the page margins; it is a separate section used for placing text or objects at the top of the page.
  • Page margin settings can be accessed via the "Margins" dropdown in the "Page Setup" group.
  • Custom margins can also be created by selecting "Custom Margins" from the dropdown and specifying values for each side.

Additional Information

  • Header and Footer:
  • The Header section is located at the top of the page and is used for adding titles, page numbers, or other recurring elements.
  • The Footer section is located at the bottom of the page and serves similar purposes as the Header.
  • Both Header and Footer can be customized independently of page margins.
  • Page Layout Options:
  • The "Layout" tab in MS Word provides tools for adjusting page orientation, margins, size, and columns.
  • Users can choose predefined margin settings such as "Normal," "Narrow," "Wide," or create custom settings.
  • Print Preview:
  • Before printing a document, users can view how the margins and layout will appear in the "Print Preview" section.
  • This ensures the document layout aligns with the intended design.
  • Page Setup Dialog Box:
  • Users can access the Page Setup dialog box for advanced margin settings.
  • This includes options for gutter margins and adjusting spacing for binding purposes.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 584

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365,to enable the edit mode in MS-Excel worksheet, we should follow: 

  1. AOption (a)

    File > Advanced > Editing options > Options

  2. BOption (b)

    File > Options > Editing options

  3. COption (c)

    File > Options > Advanced > Editing options

  4. DOption (d)

    File > Advanced > Editing options 

View answer & explanation

Correct answer

Answer: (c)C.

File > Options > Advanced > Editing options

Why this answer is correct

The correct answer is File > Options > Advanced > Editing options.

Key Points

  • To enable the edit mode in MS Excel 365, navigate to File > Options > Advanced > Editing options, which allows you to configure editing settings.
  • This path provides users with access to various advanced features related to worksheet editing behavior.
  • By enabling "Edit directly in cells" under this menu, users can directly edit cell contents without requiring the formula bar.
  • Other options like enabling autofill, drag-and-drop editing, and automatic cell entry suggestions can also be configured here.
  • This setting enhances user flexibility and productivity while working on complex spreadsheets.

Additional Information

  • Excel Edit Mode:
  • Edit mode in Excel allows users to modify the content of a cell directly either by double-clicking the cell or pressing F2.
  • In edit mode, the cursor appears within the cell, allowing changes to be made without altering the entire cell content.
  • Excel Options Menu:
  • The Options menu in Excel provides customization features for general, advanced, proofing, and formula-related settings.
  • It is accessible via the File tab and is key to tailoring Excel to user-specific requirements.
  • Advanced Options in Excel:
  • Located under File > Options > Advanced, it gives users control over editing, display, and calculation options for spreadsheets.
  • Includes features like enabling multi-threaded calculations, customizing formula behavior, and controlling scroll and zoom settings.
  • Keyboard Shortcuts for Editing:
  • Pressing F2 directly enables edit mode for a selected cell.
  • Ctrl + Enter is used to quickly enter data into selected cells without exiting edit mode.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 585

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS-word 365, the keyboard shortcut Shift + F3 can be used to change the text document as: 

  1. AOption (a)

    Capitalize Each Word 

  2. BOption (b)

    Size of Font 

  3. COption (c)

    Bold Font 

  4. DOption (d)

    Highlight Text color 

View answer & explanation

Correct answer

Answer: (a)A.

Capitalize Each Word 

Why this answer is correct

The correct answer is Capitalize Each Word.

Key Points

  • The Shift + F3 shortcut in MS Word 365 is used to cycle through text case options: Uppercase, Lowercase, and Capitalize Each Word.
  • When using this shortcut, users can quickly change the case of selected text without manually editing each character.
  • Capitalize Each Word refers to making the first letter of every word uppercase while keeping the remaining letters lowercase.
  • This feature is particularly useful for formatting titles, headings, or lists in documents.
  • Shift + F3 is compatible with both Windows and Mac versions of MS Word, ensuring cross-platform usability.

Additional Information

  • Text Formatting in MS Word:
  • MS Word provides multiple text formatting options, including font styles, sizes, colors, and case changes.
  • Case-changing options include Uppercase, Lowercase, Sentence case, Capitalize Each Word, and Toggle case.
  • These formatting tools help enhance the readability and visual appeal of a document.
  • Keyboard Shortcuts in MS Word:
  • MS Word offers a wide array of shortcuts to improve productivity and efficiency.
  • Examples include Ctrl + B for Bold, Ctrl + U for Underline, and Ctrl + I for Italics.
  • Using shortcuts reduces reliance on the mouse and speeds up document editing.
  • Capitalize Each Word Use Cases:
  • Ideal for formatting titles, names, or headings in professional documents.
  • Ensures uniformity in presentation style across different sections of the document.
  • Useful in academic, business, and creative writing contexts.
  • MS Word 365 Features:
  • MS Word 365 is part of the Office 365 suite, offering cloud integration and real-time collaboration.
  • It includes advanced features like AI-powered suggestions, document sharing, and accessibility tools.
  • Regular updates ensure compatibility with the latest operating systems and technologies.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 586

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, which of the following functions can be used to display the formula applied to a specific cell?

  1. AOption (a)

    =RETFORMULA(Cell_Reference) 

  2. BOption (b)

    =FORMULATEXT(Cell_Reference)

  3. COption (c)

    =CALLFORMULA(Cell_Reference) 

  4. DOption (d)

    =TEXTFORMULA(Cell_Reference) 

View answer & explanation

Correct answer

Answer: (b)B.

=FORMULATEXT(Cell_Reference)

Why this answer is correct

The correct answer is =FORMULATEXT(Cell_Reference).

Key Points

  • The =FORMULATEXT(Cell_Reference) error in MS Excel generally occurs when there is an issue with the function name or syntax.
  • It can arise if you attempt to display a formula or use a function that is incorrectly spelled or not recognized by Excel.
  • To display the formula applied to a specific cell, use the FORMULATEXT() function, but ensure it is supported in your version of Excel.
  • The #NAME? error also highlights that Excel cannot identify text used in a formula, typically due to missing quotes or undefined names.
  • This error serves as a diagnostic tool in Excel to identify and correct issues in functions or formulas.

Additional Information

  • FORMULATEXT() Function:
  • This function returns the formula as a text string from a referenced cell.
  • Syntax: FORMULATEXT(reference).
  • It is especially useful for auditing and reviewing formulas in large spreadsheets.
  • Available in Excel 2013 and later versions, including MS Excel 365.
  • Common Excel Errors:
  • #DIV/0!: Occurs when dividing by zero or an empty cell.
  • #VALUE!: Indicates incorrect data types in a formula.
  • #REF!: Arises when a cell reference is invalid.
  • #NAME?: Triggered by unrecognized text in a formula.
  • Excel Formula Auditing Tools:
  • Excel provides tools like Trace Precedents and Trace Dependents to track formula references.
  • The Evaluate Formula feature helps debug complex formulas step-by-step.
  • Excel Function Best Practices:
  • Always ensure correct syntax and spelling of functions.
  • Use Name Manager to define and manage named ranges or constants.
  • Double-check quotes and parentheses in formulas to avoid errors.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 587

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which operation can be used to move the text in a document of MS word 365?

  1. AOption (a)

    Cut-paste 

  2. BOption (b)

    Cut-copy-paste

  3. COption (c)

    Move-paste

  4. DOption (d)

    Copy-paste

View answer & explanation

Correct answer

Answer: (a)A.

Cut-paste 

Why this answer is correct

The correct answer is Cut-paste.

Key Points

  • Cut-paste is a widely used operation in MS Word to move text from one location to another within a document.
  • When you use "Cut," the selected text is removed from its original location and temporarily stored in the clipboard.
  • "Paste" allows you to insert the text stored in the clipboard into a new location in the document.
  • This operation ensures that the text is relocated rather than duplicated, unlike "Copy-paste."
  • Shortcut keys for this operation in MS Word are Ctrl + X (Cut) and Ctrl + V (Paste).

Additional Information

  • Clipboard:
  • The Clipboard is a temporary storage area where text or objects are saved after being cut or copied.
  • Data stored in the Clipboard can be pasted multiple times until new data is cut or copied.
  • Difference between Cut and Copy:
  • "Cut" removes the text from its original position, whereas "Copy" leaves the original text intact.
  • Both operations store the content in the Clipboard for further use.
  • Undo Operation:
  • If a Cut operation is performed by mistake, users can press Ctrl + Z to undo the action and restore the text.
  • Drag and Drop:
  • In addition to Cut-paste, users can also move text in MS Word by dragging it to a new location using the mouse.
  • This method is intuitive and does not require the use of the Clipboard.
  • MS Word Versions:
  • The Cut-paste operation is available in all versions of MS Word, including Microsoft 365.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 588

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Excel 365, which of the following keyboard shortcuts enables you to save a workbook?

  1. AOption (a)

    Ctrl + A

  2. BOption (b)

    Ctrl + S 

  3. COption (c)

    Ctrl + G

  4. DOption (d)

    Ctrl + F

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl + S 

Why this answer is correct

The correct answer is Ctrl + S.

Key Points

  • Ctrl + S is the standard keyboard shortcut for saving workbooks or files in Microsoft Excel 365 and other Microsoft Office applications.
  • Using Ctrl + S ensures that changes made to the workbook are saved and prevents the loss of data in case of unexpected interruptions like system crashes.
  • This shortcut can be used at any time while working on a file and applies universally across Windows versions of Excel.
  • The saved workbook is stored in the default location specified by the user, or the "Save As" prompt appears for new files without a defined save location.
  • It is recommended to use Ctrl + S frequently during work sessions to maintain data integrity.

Additional Information

  • Keyboard Shortcuts in Microsoft Excel:
  • Ctrl + A: Selects all cells in the workbook or the current data range.
  • Ctrl + G: Opens the "Go To" dialog box, allowing navigation to specific cells or ranges.
  • Ctrl + F: Opens the "Find" dialog box to search for specific text or values within the workbook.
  • Ctrl + Z: Undo the last action performed in Excel.
  • AutoSave Feature:
  • In Excel 365, the AutoSave feature automatically saves changes to the workbook if it is stored on OneDrive or SharePoint.
  • This feature eliminates the need for manual saving but works alongside Ctrl + S for local files.
  • Save Options in Excel:
  • Excel allows saving files in various formats, including .xlsx, .xls, .csv, and .pdf.
  • Users can specify file locations, names, and formats during the save process.
  • Excel Backup Settings:
  • Excel provides options to create automatic backups, accessible through the "Options" menu under "Save."
  • Users can set the frequency for saving AutoRecover information to minimize data loss risks.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 589

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What does the menu bar do in MS-Word 365?

  1. AOption (a)

    Finds program essential functions

  2. BOption (b)

    Displays the title of the software

  3. COption (c)

    It moves the window moving area upside 

  4. DOption (d)

    Displays the current page number of the document

View answer & explanation

Correct answer

Answer: (a)A.

Finds program essential functions

Why this answer is correct

The correct answer is Finds program essential functions.

Key Points

  • The menu bar in MS-Word 365 provides access to program-essential functions like saving, opening, formatting, and printing documents.
  • It contains a series of menus such as File, Home, Insert, Design, Layout, References, Review, View, and others, each dedicated to specific tasks.
  • The menu bar is located at the top of the MS-Word interface, providing a user-friendly navigation system.
  • It allows users to execute both basic and advanced operations, such as formatting text, adding tables, and managing references.
  • By clicking on a menu, users can access a dropdown with further options and commands relevant to the selected menu.

Additional Information

  • Ribbon Interface:
  • In MS-Word 365, the menu bar is integrated with the Ribbon interface, which organizes commands into tabs for better usability.
  • The ribbon was introduced in Office 2007 and has since been an integral part of Microsoft Office applications.
  • Quick Access Toolbar:
  • Located above the menu bar, the Quick Access Toolbar provides shortcuts to frequently used commands like Save, Undo, and Redo.
  • Users can customize this toolbar to include commands they use most often.
  • File Menu Features:
  • The File menu in the menu bar provides functions such as Save, Open, Export, Print, and Share.
  • It also includes options for managing account settings and accessing document properties.
  • Context-Sensitive Menus:
  • Some menus and options in MS-Word are context-sensitive, appearing only when specific elements (e.g., tables, images) are selected.
  • This feature ensures that users have relevant tools readily accessible.
  • Integration with Cloud Services:
  • MS-Word 365 integrates with cloud services like OneDrive, enabling users to save and access documents directly from the menu bar.
  • This feature promotes seamless collaboration and storage solutions.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 590

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the shortcut key for closing the documents in MS-Word 365?

  1. AOption (a)

    Ctrl + C

  2. BOption (b)

    Ctrl + W

  3. COption (c)

    Ctrl + Alt + S

  4. DOption (d)

    Ctrl + B

View answer & explanation

Correct answer

Answer: (b)B.

Ctrl + W

Why this answer is correct

The correct answer is Ctrl + W.

Key Points

  • Ctrl + W is the shortcut key used in MS Word (including MS Word 365) to close the current document while keeping the application open.
  • This shortcut is part of the universal commands across many applications, ensuring ease of use and consistency.
  • When using Ctrl + W, unsaved changes in the document will prompt a save dialog before closing.
  • It is a quick and efficient way to close documents without navigating through the file menu or using the mouse.
  • Ctrl + W does not exit the application; it only closes the active document, allowing the user to work on other open documents within MS Word.

Additional Information

  • Other Common Shortcut Keys in MS Word:
  • Ctrl + C: Copies the selected text or object to the clipboard.
  • Ctrl + V: Pastes the copied content from the clipboard.
  • Ctrl + B: Applies bold formatting to the selected text.
  • Ctrl + S: Saves the current document.
  • Ctrl + Z: Undoes the last action performed.
  • Ctrl + Alt + S: This shortcut in MS Word is used to split or remove the split view of the document window.
  • Document Closing vs. Application Closing:
  • Ctrl + W: Closes the current document but keeps the application open.
  • Alt + F4: Closes the entire application, including all open documents.
  • MS Word 365:
  • Part of the Microsoft Office 365 suite, it is a cloud-based version of Microsoft Word.
  • It offers additional features like real-time collaboration, cloud storage integration, and regular updates.
  • Shortcut Key Efficiency: Using shortcut keys like Ctrl + W enhances productivity by reducing dependency on the mouse and speeding up workflow.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 591

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following statements related to attaching a file to an email is correct? 

  1. AOption (a)

    Writing a subject field is mandatory while sending an attachment. 

  2. BOption (b)

    We can’t use CC field while sending an attachment. 

  3. COption (c)

    We can’t attach an audio file in an email attachment.

  4. DOption (d)

    In Gmail, If your file is greater than 25 MB, Gmail automatically adds a Google Drive link in the email instead of including it as an attachment.

View answer & explanation

Correct answer

Answer: (d)D.

In Gmail, If your file is greater than 25 MB, Gmail automatically adds a Google Drive link in the email instead of including it as an attachment.

Why this answer is correct

The Correct answer is In Gmail, If your file is greater than 25 MB, Gmail automatically adds a Google Drive link in the email instead of including it as an attachment.

Key Points

  • Gmail has a size limit for email attachments, which is 25 MB.
  • If an attachment exceeds 25 MB, Gmail automatically uploads the file to Google Drive, a cloud storage service provided by Google.
  • Once uploaded to Google Drive, Gmail includes a Google Drive link in the email instead of attaching the file directly.
  • This feature ensures that users can share large files seamlessly without encountering issues related to file size limitations.
  • Recipients can access the file through the provided link, which redirects them to Google Drive.
  • This integration between Gmail and Google Drive enhances the functionality of email services and provides a convenient solution for sending large files.
  • The file-sharing feature is part of Google’s ecosystem, which also includes services like Google Docs, Sheets, and Slides.

Additional Information

  • Writing a subject field is mandatory while sending an attachment
  • It is not mandatory to write a subject while sending an email with an attachment. However, it is a best practice to include a subject to provide clarity to the recipient.
  • We can't use CC field while sending an attachment
  • This statement is incorrect. The CC (Carbon Copy) field can be used in emails regardless of whether an attachment is included or not. It is used to send a copy of the email to other recipients.
  • We can't attach an audio file in an email attachment
  • This is incorrect. Audio files can be attached to emails as long as their size does not exceed the attachment limit (e.g., 25 MB for Gmail).
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 592

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following options in MS Word 365 lets you customize various aspects of a document's layout, such as paper size, margins, orientation, and page numbering?

  1. AOption (a)

    Document Inspector

  2. BOption (b)

    Print Layout View

  3. COption (c)

    Page Setup

  4. DOption (d)

    Navigation Pane

View answer & explanation

Correct answer

Answer: (c)C.

Page Setup

Why this answer is correct

The Correct answer is Page Setup.

Key Points

  • The Page Setup option in MS Word 365 enables users to customize critical aspects of a document's layout.
  • It allows adjustments to paper size, such as A4, Letter, Legal, etc., suitable for different printing needs.
  • Users can modify the margins of a document, which affects the spacing between text and the edges of the paper.
  • The orientation feature lets users switch between Portrait (vertical) and Landscape (horizontal) layouts.
  • With the Page Setup tool, users can define page numbering, including formats, positioning, and starting numbers.
  • This tool is essential for creating professional documents that require specific formatting and layout standards, such as reports, brochures, and academic papers.
  • Page Setup is located under the Layout Tab in MS Word 365, making it accessible for customization.

Additional Information

  • Document Inspector
  • The Document Inspector is a tool used to check for hidden metadata, personal information, or sensitive details in a document.
  • It helps in ensuring the document is clean and free of unintended information before sharing or publishing.
  • It is not related to customizing the layout of the document.
  • Print Layout View
  • The Print Layout View displays the document as it will appear when printed, including margins, page breaks, and layout.
  • It is a visual representation and does not allow customization of layout settings.
  • Navigation Pane
  • The Navigation Pane in MS Word is used to view and navigate through headings, pages, or search results in a document.
  • It is helpful for quickly moving across sections but does not control the document layout.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 593

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is NOT a characteristic of communication on the internet? 

  1. AOption (a)

    It is asynchronous. 

  2. BOption (b)

    It is interactive.

  3. COption (c)

    It is global.

  4. DOption (d)

    It is always private.

View answer & explanation

Correct answer

Answer: (d)D.

It is always private.

Why this answer is correct

The Correct answer is It is always private.

Key Points

  • Communication on the internet is not always private because online interactions can be subject to surveillance, hacking, data breaches, or monitoring by third parties.
  • Many platforms and services collect user data for analytics, personalization, and advertising, which compromises privacy.
  • Activities like email exchanges, social media interactions, and file sharing often involve third-party servers or intermediaries, which can access or store data.
  • Encryption and other security measures can improve privacy, but they do not guarantee absolute confidentiality.
  • Users often rely on terms of service and privacy policies of platforms, which might include clauses allowing data usage or sharing.
  • Even private conversations can be exposed due to phishing attacks, malware, or inadequate security practices.
  • Thus, while the internet enables global and interactive communication, it is inaccurate to consider it always private.

Additional Information

  • It is asynchronous
  • Asynchronous communication refers to interactions where participants do not need to be present at the same time, such as emails, forums, and text messages.
  • The internet facilitates asynchronous communication, allowing users to respond at their convenience.
  • This characteristic makes the internet suitable for remote work, education, and collaborative projects.
  • It is interactive
  • The internet is inherently interactive, enabling real-time communication through chats, video calls, and collaborative tools.
  • It supports user engagement through features like comments, likes, and feedback on social media platforms and websites.
  • Interactive communication is essential for education, entertainment, and business applications.
  • It is global
  • The internet connects people across the world, enabling global communication, collaboration, and access to information.
  • It has revolutionized industries like trade, education, and media by removing geographical barriers.
  • Examples include international e-commerce platforms, remote work, and social media networks.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 594

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, if you set a row height to 0 (zero), what happens to the row?

  1. AOption (a)

    It hides the row. 

  2. BOption (b)

    It asks for a new value.

  3. COption (c)

    It sets the default height.

  4. DOption (d)

    It returns to the last entered value.

View answer & explanation

Correct answer

Answer: (a)A.

It hides the row. 

Why this answer is correct

The Correct answer is It hides the row.

Key Points

  • In MS Excel 365, setting the row height to 0 effectively hides the row. The content in the row remains intact but becomes invisible, making it a useful feature for managing large datasets.
  • A hidden row can be unhidden by adjusting the row height back to a visible value or using the Unhide option from the context menu.
  • This feature is commonly used to temporarily hide data that is not immediately relevant without deleting it from the sheet.
  • When the row height is set to 0, Excel automatically interprets this as a command to hide the row instead of displaying it with zero height.
  • It is important to note that hiding rows does not affect formulas or calculations in Excel; they continue to reference the hidden data.
  • The ability to hide rows is a part of Excel's data management tools, enhancing flexibility and organization in working with large spreadsheets.

Additional Information

  • Option 2: It asks for a new value
  • This is incorrect because Excel does not prompt the user for a new value when setting the row height to 0; it directly hides the row.
  • Option 3: It sets the default height
  • This option is incorrect as setting the row height to 0 does not restore the default height; it hides the row instead.
  • Option 4: It returns to the last entered value
  • This is incorrect because Excel does not revert to the previously set height when a row height is explicitly set to 0.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 595

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Excel 365, which of the following functions is used for displaying the current date? 

  1. AOption (a)

    Time() 

  2. BOption (b)

    Now() 

  3. COption (c)

    Today() 

  4. DOption (d)

    Day()

View answer & explanation

Correct answer

Answer: (c)C.

Today() 

Why this answer is correct

The Correct answer is Today().

Key Points

  • The Today() function in Microsoft Excel 365 is used to display the current date.
  • It returns only the date component (day, month, and year) without the time component.
  • The syntax for using the Today() function is simple: =TODAY().
  • It automatically updates to show the current date whenever the worksheet is recalculated or reopened.
  • The Today() function is commonly used in applications that require dynamic date calculations, such as tracking deadlines, generating daily reports, or calculating age.
  • This function does not accept any arguments, making it straightforward to use.
  • For example, if today's date is October 10, 2023, the Today() function will return 10/10/2023 in the default date format of your system.

Additional Information

  • Time()
  • The Time() function is used to return a specific time based on the input values for hour, minute, and second.
  • For example, =TIME(14, 30, 0) would return 2:30 PM.
  • Now()
  • The Now() function returns both the current date and time.
  • For example, if the current date and time are October 10, 2023, 3:00 PM, the =NOW() function will return 10/10/2023 3:00 PM.
  • It is useful when you need to track both date and time dynamically.
  • Day()
  • The Day() function extracts the day component from a specific date.
  • For instance, =DAY("10/10/2023") will return 10.
  • It is often used in conjunction with other date functions for custom date calculations.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 596

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365,what is the keyboard shortcut to automatically adjust the width of a column to fit the content in Excel? 

  1. AOption (a)

    Ctrl + W 

  2. BOption (b)

    Ctrl + Spacebar

  3. COption (c)

    Ctrl + A

  4. DOption (d)

    ALT + H then O and then I

View answer & explanation

Correct answer

Answer: (d)D.

ALT + H then O and then I

Why this answer is correct

The Correct answer is ALT + H then O and then I.

Key Points

  • In MS Excel 365, the keyboard shortcut ALT + H then O and then I is used to automatically adjust the width of a column to fit the content.
  • This shortcut is part of the Alt Key Tips feature in Excel, which allows users to access commands and features via the keyboard instead of the ribbon.
  • Here’s how it works:
  • ALT + H: Activates the Home tab on the Excel ribbon.
  • O: Selects the Format option under the Home tab.
  • I: Executes the AutoFit Column Width command.
  • The AutoFit Column Width feature ensures that the column width is adjusted to fit the content of the cells, making the data more readable and organized.
  • This shortcut is especially useful for handling spreadsheets with large amounts of data or when copying and pasting data from external sources.

Additional Information

  • Ctrl + W
  • The Ctrl + W shortcut is used to close the current workbook or document in Excel.
  • This shortcut does not affect column width or formatting.
  • Ctrl + Spacebar
  • The Ctrl + Spacebar shortcut is used to select the entire column in Excel.
  • It does not adjust the column width.
  • Ctrl + A
  • The Ctrl + A shortcut is used to select all the content within the sheet or specific data range.
  • It is a general-purpose selection shortcut and does not impact column width.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 597

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

When we press the control key with the letter E, what happens to the text in the MS - Word 365? 

  1. AOption (a)

    It selects the whole content on the file. 

  2. BOption (b)

    Right aligns the contents on the page.

  3. COption (c)

    Centers the contents on the page. 

  4. DOption (d)

    Left aligns the contents on the page.

View answer & explanation

Correct answer

Answer: (c)C.

Centers the contents on the page. 

Why this answer is correct

The Correct answer is Centers the contents on the page.

Key Points

  • Pressing Ctrl + E in MS Word 365 centers the text or content within the current paragraph or the selected text.
  • Center alignment is one of the four types of text alignment available in MS Word, alongside left alignment, right alignment, and justified alignment.
  • This shortcut is particularly useful for formatting titles, headings, or any content that needs to be visually centered on the page.
  • The centered text is aligned to the middle of the page, maintaining an equal distance from both the left and right margins.
  • Shortcut keys, such as Ctrl + E, enhance productivity by reducing the time required to navigate through menus for commonly used functions.
  • MS Word is widely used for text formatting and document creation, and mastering such shortcuts can significantly improve efficiency.

Additional Information

  • It selects the whole content on the file
  • To select all content in the file, the shortcut Ctrl + A is used instead of Ctrl + E.
  • This command is helpful for performing actions like formatting, copying, or deleting the entire text in a document.
  • Right aligns the contents on the page
  • Pressing Ctrl + R aligns the text or content to the right margin.
  • Right alignment is often used for specific formatting needs, such as aligning dates or author names in formal letters.
  • Left aligns the contents on the page
  • The shortcut for left alignment is Ctrl + L, which is the default alignment for most text in MS Word.
  • Left alignment is commonly used for body text, ensuring readability and a clean layout.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 598

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which action in MS - Word 365, allows you to remove selected text from its original location and place it on the clipboard? 

  1. AOption (a)

    Copy 

  2. BOption (b)

    Cut 

  3. COption (c)

    Paste 

  4. DOption (d)

    Select All

View answer & explanation

Correct answer

Answer: (b)B.

Cut 

Why this answer is correct

The Correct answer is Cut.

Key Points

  • The Cut action in MS Word 365 removes the selected text from its original location and places it onto the clipboard.
  • The content stored on the clipboard can then be pasted into a new location within the document or into another document.
  • This action is especially useful when you want to rearrange text without creating duplicates.
  • To perform the Cut action, users can either press the keyboard shortcut Ctrl + X or use the Ribbon menu by clicking on the "Cut" icon in the Home tab.
  • When text is cut, it remains on the clipboard until it is either overwritten by other copied/cut content or until the MS Word application is closed.
  • This feature enhances the editing and formatting capabilities of MS Word, allowing users to efficiently manage their documents.

Additional Information

  • Copy
  • The Copy action creates a duplicate of the selected text and places it on the clipboard without removing it from its original location.
  • This is useful when you need to replicate content across various sections of the document or other documents.
  • The keyboard shortcut for the Copy action is Ctrl + C.
  • Paste
  • The Paste action inserts the content stored on the clipboard into a new location within the document.
  • It complements the Cut and Copy actions, allowing users to place the text where desired.
  • The keyboard shortcut for Paste is Ctrl + V.
  • Select All
  • The Select All action highlights all the content within the document, including text, images, and other elements.
  • It is often used for performing bulk actions, such as changing the font style or size across the entire document.
  • The keyboard shortcut for Select All is Ctrl + A.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 599

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is the shortcut key to Paste text in MS Word 365?

  1. AOption (a)

    Ctrl + Shift + V 

  2. BOption (b)

    Shift + V 

  3. COption (c)

    Ctrl + V

  4. DOption (d)

    Ctrl + C

View answer & explanation

Correct answer

Answer: (c)C.

Ctrl + V

Why this answer is correct

The Correct answer is Ctrl + V.

Key Points

  • The shortcut key Ctrl + V is universally used to paste text or other content in various applications, including MS Word 365.
  • It is part of the standard set of keyboard shortcuts developed by Microsoft Windows and adopted by other operating systems for basic functions like copy, cut, and paste.
  • When a user copies or cuts content, it is stored in the clipboard. Using Ctrl + V, the content from the clipboard can be pasted at the cursor's location.
  • This shortcut enhances productivity by eliminating the need for manual pasting through the context menu or toolbar.
  • Ctrl + V works across different versions of MS Word, including Office 365, 2019, 2016, 2013, 2010, and earlier versions.
  • Users who rely on keyboard shortcuts for efficiency find Ctrl + V indispensable for editing and formatting tasks.

Additional Information

  • Ctrl + Shift + V
  • The shortcut key Ctrl + Shift + V is used in certain applications (such as Google Docs or web applications) to paste text without formatting.
  • However, this functionality is not available in MS Word 365.
  • In MS Word, pasting without formatting can be done manually via the "Paste Special" option in the ribbon.
  • Shift + V
  • Shift + V is not a valid shortcut for pasting text in MS Word 365 or any other version of MS Word.
  • This shortcut has no assigned function related to pasting content in Microsoft Office applications.
  • Ctrl + C
  • Ctrl + C is the shortcut key used to copy content to the clipboard in MS Word and other applications.
  • This function works in tandem with Ctrl + V, as content must first be copied or cut before it can be pasted.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 29 Nov, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 600

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is NOT a common method of opening a document in a web - based document editor like Google Docs? 

  1. AOption (a)

    Typing the entire document from scratch 

  2. BOption (b)

    Creating a new document from a template

  3. COption (c)

    Importing a document from a web link 

  4. DOption (d)

    Uploading the document from your computer

View answer & explanation

Correct answer

Answer: (a)A.

Typing the entire document from scratch 

Why this answer is correct

The Correct answer is Typing the entire document from scratch.

Key Points

  • Web-based document editors like Google Docs are designed to streamline workflows and allow users to easily create and edit documents.
  • While it's technically possible to type a document from scratch, this is not considered a common or efficient method for opening a document in such platforms.
  • These editors provide various tools for importing, creating, and editing documents, which are more commonly used than starting from scratch.
  • Common methods for opening a document in web-based editors include:
  • Creating a new document from a template—This provides pre-designed layouts for reports, resumes, and other professional purposes.
  • Importing a document from a web link—Allows users to open documents directly shared via URLs.
  • Uploading the document from your computer—Facilitates editing of existing files stored locally on a user’s device.
  • Typing the entire document from scratch can be time-consuming and is not aligned with the platform's core purpose of enhancing productivity through existing tools.

Additional Information

  • Creating a new document from a template
  • Templates are pre-designed formats available in web-based editors to save time and effort.
  • Examples include resume templates, business letter formats, and project reports.
  • Using templates ensures professional consistency and reduces formatting errors.
  • Importing a document from a web link
  • This feature allows users to open documents shared via URLs or hyperlinks.
  • It is often used in collaborative environments where documents are shared publicly or within teams.
  • Example platforms supporting this include Google Drive and Dropbox.
  • Uploading the document from your computer
  • This is a common method for editing files like Word documents, PDFs, or spreadsheets directly in web-based editors.
  • Users can upload files stored locally on their devices to make edits or convert them to online formats.
  • Supported file types include .doc, .docx, .pdf, .xlsx, and .ppt.

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.