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 221–240 of 1030Page 12 of 52
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 221

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is a shortcut key to open the Font dialog box in MS Word 365?

  1. AOption (a)

    Ctrl + Shift + F

  2. BOption (b)

    Ctrl + Alt + F

  3. COption (c)

    Alt + F

  4. DOption (d)

    Ctrl + F 

View answer & explanation

Correct answer

Answer: (a)A.

Ctrl + Shift + F

Why this answer is correct

The correct answer is Ctrl + Shift + F.

Key Points

  • The shortcut key Ctrl + Shift + F is used to open the Font dialog box in MS Word 365.
  • This shortcut allows users to quickly access font settings without navigating through menus.
  • The Font dialog box provides options to change the font type, style, size, color, and other text effects.
  • Using shortcut keys like Ctrl + Shift + F enhances productivity and efficiency while working with text documents.

Additional Information

  • MS Word 365
  • MS Word 365 is a popular word processing software developed by Microsoft, part of the Microsoft Office 365 suite.
  • It offers a wide range of features for creating, formatting, and editing text documents.
  • Users can insert images, tables, charts, and other multimedia elements into documents.
  • MS Word 365 also includes collaboration tools that allow multiple users to work on a document simultaneously.
  • Shortcut Keys
  • Shortcut keys are combinations of keys that perform specific commands in software applications.
  • They are designed to provide quick access to frequently used functions, saving time and effort.
  • Common examples include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + S for save.
  • Knowing and using shortcut keys can significantly improve productivity when working with computer applications.
  • Font Dialog Box
  • The Font dialog box in MS Word 365 allows users to customize the appearance of text.
  • Options available in the Font dialog box include font type, style (bold, italic), size, color, and underline style.
  • Advanced options include text effects such as strikethrough, superscript, and subscript.
  • Accessing the Font dialog box via shortcut keys like Ctrl + Shift + F provides a quick way to make detailed text adjustments.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 222

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which organisation oversees the development and standardisation of technologies for the World Wide Web?

  1. AOption (a)

    IEEE

  2. BOption (b)

    IEIT

  3. COption (c)

    WHO

  4. DOption (d)

    W3C

View answer & explanation

Correct answer

Answer: (d)D.

W3C

Why this answer is correct

The correct answer is W3C.

Key Points

  • The World Wide Web Consortium (W3C) is the main international standards organization for the World Wide Web.
  • W3C was founded and is led by Tim Berners-Lee, the inventor of the Web, in 1994.
  • W3C's mission is to lead the Web to its full potential by developing protocols and guidelines that ensure long-term growth for the Web.
  • W3C operates under an open and transparent process aimed at building consensus and ensuring high-quality standards.

Additional Information

  • IEEE (Institute of Electrical and Electronics Engineers)
  • IEEE is a professional association dedicated to advancing technological innovation and excellence.
  • It is well known for its work in electrical and electronics engineering and computer science.
  • IEEE is responsible for setting technical standards in various fields but is not specific to the Web.
  • IEIT (Institution of Engineering and Technology)
  • IEIT is a multidisciplinary professional engineering institution.
  • It works to inspire, inform, and influence the global engineering community.
  • However, it does not specifically oversee Web technologies.
  • WHO (World Health Organization)
  • WHO is a specialized agency of the United Nations responsible for international public health.
  • Its primary role is to direct and coordinate health within the UN system.
  • WHO does not have a role in the standardization of Web technologies.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 223

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the default page orientation in Microsoft Word 365?

  1. AOption (a)

    Portrait

  2. BOption (b)

    Square

  3. COption (c)

    Pentagon

  4. DOption (d)

    Landscape

View answer & explanation

Correct answer

Answer: (a)A.

Portrait

Why this answer is correct

The correct answer is Portrait.

Key Points

  • The default page orientation in Microsoft Word 365 is Portrait.
  • Portrait orientation is taller than it is wide, making it suitable for most documents.
  • This is the most commonly used orientation for text-heavy documents like letters, reports, and essays.
  • Users can change the page orientation to Landscape if needed, which is wider than it is tall.

Additional Information

  • Page Orientation:
  • Page orientation refers to the direction in which a document is displayed or printed.
  • There are two primary orientations: Portrait and Landscape.
  • Portrait Orientation: This is the vertical orientation where the height of the page is greater than the width.
  • Landscape Orientation: This is the horizontal orientation where the width of the page is greater than the height.
  • Microsoft Word allows users to switch between these orientations based on their document needs.
  • Changing Page Orientation:
  • To change the page orientation in Microsoft Word, go to the "Layout" tab on the ribbon.
  • Click on "Orientation" and choose either "Portrait" or "Landscape".
  • This can be applied to the entire document or a selected section.
  • Use Cases for Different Orientations:
  • Portrait: Suitable for standard text documents, letters, articles, and reports.
  • Landscape: Often used for presentations, charts, tables, and graphics-heavy documents.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 224

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, the default row height and the column width, respectively, are: 

  1. AOption (a)

    10 and 8.52

  2. BOption (b)

    20 and 10.51 

  3. COption (c)

    5 and 10.43 

  4. DOption (d)

    15 and 8.43 

View answer & explanation

Correct answer

Answer: (d)D.

15 and 8.43 

Why this answer is correct

The correct answer is 15 and 8.43.

Key Points

  • The default row height in MS Excel 365 is 15 points.
  • The default column width in MS Excel 365 is 8.43 characters.
  • The column width is measured in characters of the default font (usually Calibri 11).
  • These default settings can be changed according to the user's preference by adjusting the row height and column width manually.

Additional Information

  • Row Height
  • The row height in Excel is measured in points, where one point is equal to 1/72 of an inch.
  • The default row height of 15 points translates approximately to 20 pixels on the screen.
  • The row height can be adjusted by dragging the boundary below the row heading or by setting a specific height using the 'Row Height' option.
  • Column Width
  • The column width in Excel is measured in terms of the number of characters of the default font that can fit in the cell.
  • The default column width of 8.43 characters allows for approximately 64 pixels of width.
  • Column width can be adjusted by dragging the boundary on the right side of the column heading or by setting a specific width using the 'Column Width' option.
  • Adjusting Row Height and Column Width
  • To adjust the row height, select the row or rows you want to change, then go to the 'Home' tab, click on 'Format' in the 'Cells' group, and select 'Row Height'. Enter the desired height and click OK.
  • To adjust the column width, select the column or columns you want to change, then go to the 'Home' tab, click on 'Format' in the 'Cells' group, and select 'Column Width'. Enter the desired width and click OK.
  • Double-clicking the boundary between column headers will auto-fit the column to the width of the longest cell content.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 225

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Under which of the following tabs of the MS Word 365 ribbon are the Bullets and Numbering options present? 

  1. AOption (a)

    Insert

  2. BOption (b)

    Mailings

  3. COption (c)

    Home

  4. DOption (d)

    File

View answer & explanation

Correct answer

Answer: (c)C.

Home

Why this answer is correct

The correct answer is Home.

Key Points

  • The Home tab in MS Word 365 is where you can find the Bullets and Numbering options.
  • This tab also contains basic text formatting tools such as font type, size, color, and alignment options.
  • The Bullets and Numbering options are used to create ordered (numbered) and unordered (bulleted) lists to organize content.
  • These tools are essential for improving the readability and structure of documents by clearly outlining key points and steps.

Additional Information

  • Insert Tab
  • The Insert tab allows users to add various elements to their document, such as tables, pictures, shapes, charts, links, headers, and footers.
  • It is also used to insert symbols, equations, and text boxes.
  • This tab is crucial for adding non-text elements to enhance the document's visual appeal and functionality.
  • Mailings Tab
  • The Mailings tab is designed for creating and managing mail merges.
  • It allows users to create envelopes, labels, and personalized letters for mass mailing.
  • This tab is particularly useful for businesses and organizations that need to send out bulk communications.
  • File Tab
  • The File tab, also known as the Backstage view, provides access to file management options such as saving, opening, closing, printing, and sharing documents.
  • It also contains options for document properties, version history, and document protection settings.
  • This tab is essential for managing the overall lifecycle and security of a document.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 226

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, A Contour map is an example of which of the following charts? 

  1. AOption (a)

    Surface Chart

  2. BOption (b)

    Scatter chart 

  3. COption (c)

    Radar chart 

  4. DOption (d)

    Doughnut chart 

View answer & explanation

Correct answer

Answer: (a)A.

Surface Chart

Why this answer is correct

The correct answer is Surface Chart.

Key Points

  • A Surface Chart in Excel is used to find the optimum combinations between two sets of data.
  • It is particularly useful for displaying data in a three-dimensional view, making patterns or trends easier to observe.
  • Contour maps, which represent data in three dimensions, are a type of surface chart.
  • Surface charts can be used to visualize complex data and are often used in scientific and engineering fields.

Additional Information

  • Surface Chart:
  • A surface chart in Excel plots data points on a 3D surface, allowing you to see a comprehensive view of how the data points relate to each other.
  • Surface charts can be used to visualize mathematical functions or any data that can be plotted in three dimensions.
  • They help in identifying the optimum levels in a dataset by showing peaks, valleys, and flat areas.
  • There are different types of surface charts like 3D Surface, Contour, Wireframe 3D Surface, and Wireframe Contour charts.
  • Scatter Chart:
  • Scatter charts are used to plot data points on the horizontal and vertical axes to show how much one variable is affected by another.
  • They are useful for identifying relationships or patterns between two variables.
  • Scatter charts are often used in statistical analysis and correlation studies.
  • Radar Chart:
  • Radar charts, also known as spider charts, are used to display multivariate data in the form of a two-dimensional chart.
  • Each variable has its own axis, which starts from the same point in the center.
  • Radar charts are useful for comparing multiple variables and identifying outliers or trends.
  • Doughnut Chart:
  • Doughnut charts are similar to pie charts but have a blank center, making them look like a doughnut.
  • They are used to represent data in rings, where each ring corresponds to a data series.
  • Doughnut charts are effective for comparing the proportions of different categories in a dataset.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 227

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following features can you use if you are having problems or want to find out how to do something in MS Word 365?

  1. AOption (a)

    Review

  2. BOption (b)

    Insert

  3. COption (c)

    Help

  4. DOption (d)

    Edit

View answer & explanation

Correct answer

Answer: (c)C.

Help

Why this answer is correct

The correct answer is Help.

Key Points

  • The Help feature in MS Word 365 provides users with a comprehensive resource for troubleshooting and learning how to use various features.
  • It includes a searchable database of articles, tutorials, and tips to assist users in resolving issues or learning new tasks.
  • Users can access the Help feature by clicking on the Help tab or pressing F1 on their keyboard.
  • The Help feature also offers a virtual assistant that can guide users through complex tasks step-by-step.

Additional Information

  • Review:
  • The Review tab in MS Word 365 is used for proofreading and editing documents.
  • It includes features like Spelling & Grammar check, Thesaurus, Word Count, Track Changes, and Comments.
  • These tools help in improving the quality of the document and facilitating collaboration with others.
  • Insert:
  • The Insert tab allows users to add various elements to their document such as tables, pictures, shapes, links, headers, and footers.
  • It also includes options for inserting text boxes, symbols, and equations.
  • Using the Insert tab helps in enhancing the visual appeal and functionality of the document.
  • Edit:
  • The Edit feature in MS Word 365 encompasses basic text editing functions like Cut, Copy, Paste, Undo, and Redo.
  • It also includes options for formatting text, such as changing font styles, sizes, and colors.
  • These tools are essential for creating and modifying the content of the document efficiently.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 228

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following shortcut keys is used in MS Word 365 to move by one preview page when zoomed out?

  1. AOption (a)

    Ctrl + Alt + I 

  2. BOption (b)

    Page UP or Page Down 

  3. COption (c)

    Ctrl + P

  4. DOption (d)

    Ctrl + D 

View answer & explanation

Correct answer

Answer: (b)B.

Page UP or Page Down 

Why this answer is correct

The correct answer is Page UP or Page Down.

Key Points

  • Page UP and Page Down are used to move by one preview page when zoomed out in MS Word 365.
  • These keys help in quickly navigating through the document without using the mouse.
  • Page UP moves the view to the previous page, while Page Down moves the view to the next page.
  • This functionality is especially useful when working with large documents.

Additional Information

  • Ctrl + Alt + I: This shortcut key is used to switch in and out of Print Preview mode.
  • Ctrl + P: This shortcut key is commonly used to open the Print dialog box in many applications, including MS Word.
  • Ctrl + D: In MS Word, this shortcut key opens the Font dialog box to change font settings.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 229

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In Microsoft Excel 365, what is a function?

  1. AOption (a)

    A method to create animations in spreadsheets

  2. BOption (b)

    A design tool for creating charts and graphs

  3. COption (c)

    A predefined formula that performs calculations using values in a specific order 

  4. DOption (d)

    A text formatting option for cells 

View answer & explanation

Correct answer

Answer: (c)C.

A predefined formula that performs calculations using values in a specific order 

Why this answer is correct

The correct answer is A predefined formula that performs calculations using values in a specific order.

Key Points

  • A function in Microsoft Excel is a predefined formula that performs calculations using specific values in a particular order.
  • Functions can be used to perform simple or complex calculations, making data analysis more efficient.
  • Excel functions cover a wide range of categories, including mathematical, statistical, logical, text, date and time, and financial operations.
  • Common functions include SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE, which simplify the process of manipulating and analyzing data.

Additional Information

  • SUM Function:
  • The SUM function adds all the numbers in a range of cells.
  • Example: =SUM(A1:A10) adds all the values from cell A1 to A10.
  • AVERAGE Function:
  • The AVERAGE function calculates the average (arithmetic mean) of a group of numbers.
  • Example: =AVERAGE(B1:B10) calculates the average of the values from cell B1 to B10.
  • IF Function:
  • The IF function performs a logical test and returns one value for a TRUE result and another for a FALSE result.
  • Example: =IF(C1>10, "Over 10", "10 or less") checks if the value in C1 is greater than 10 and returns "Over 10" if true, otherwise it returns "10 or less".
  • VLOOKUP Function:
  • The VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from another column.
  • Example: =VLOOKUP(D1, A1:B10, 2, FALSE) looks for the value in D1 within the range A1:B10 and returns the corresponding value from the second column.
  • CONCATENATE Function:
  • The CONCATENATE function combines two or more text strings into one string.
  • Example: =CONCATENATE(E1, " ", F1) joins the text in E1 and F1 with a space in between.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 2) (Previous Year Paper)·Computer Awareness
View full paper

Question 230

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Files or documents that are included with the email are commonly referred to as ____________. 

  1. AOption (a)

    add-ons

  2. BOption (b)

    appends

  3. COption (c)

    attachments

  4. DOption (d)

    supplements

View answer & explanation

Correct answer

Answer: (c)C.

attachments

Why this answer is correct

The correct answer is attachments.

Key Points

  • Attachments are files or documents that are included with an email message.
  • They can be of various types, including documents, images, videos, and compressed files.
  • Attachments are a convenient way to share additional information or files that are too large to include directly in the email body.
  • Most email clients provide an option to add attachments to an email before sending it.

Additional Information

  • Add-ons:
  • In computing, add-ons are additional software components that add specific features to an existing software application.
  • They are often used in web browsers to add functionalities such as ad blockers, password managers, and downloaders.
  • Appends:
  • To append means to add data to the end of an existing structure, such as adding a new record to the end of a file or a new element to the end of a list.
  • It is a common operation in programming and data management.
  • Attachments:
  • As mentioned, attachments are files or documents included with an email.
  • They allow users to send additional content without embedding it directly into the email text.
  • Email clients usually support various attachment types, such as PDFs, Word documents, Excel sheets, images, and videos.
  • Supplements:
  • Supplements are additional sections or materials that provide extra information to support or enhance the main content.
  • They are often used in publications, reports, or educational materials.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 231

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

F1 is the shortcut key used by almost every Windows program to display which of the following menus?

  1. AOption (a)

    Rename

  2. BOption (b)

    Edit

  3. COption (c)

    Help

  4. DOption (d)

    Refresh

View answer & explanation

Correct answer

Answer: (c)C.

Help

Why this answer is correct

The correct answer is Help.

Key Points

  • The F1 key is universally recognized for opening the help menu in almost all Windows applications.
  • This function is crucial for users to quickly access help documentation or support resources within the software.
  • Help menus typically provide guidance on how to use the software, troubleshoot issues, and find additional resources.
  • The F1 key has been a standard for accessing help menus in software applications for many years, ensuring consistency and ease of use.

Additional Information

  • Shortcut Keys
  • Shortcut keys are combinations of keys that provide quick access to certain functions within a software application.
  • They are designed to save time and increase efficiency by allowing users to perform actions without navigating through menus.
  • Common examples include Ctrl+C for copy, Ctrl+V for paste, and Ctrl+Z for undo.
  • Help Menu
  • The help menu in a software application provides users with documentation and support for using the software.
  • It typically includes a user manual, troubleshooting tips, FAQs, and sometimes links to online resources or customer support.
  • Accessing the help menu can be critical for new users or when encountering issues with the software.
  • Windows Operating System
  • Windows is a series of operating systems developed by Microsoft, widely used on personal computers and enterprise environments.
  • It provides a graphical user interface (GUI) and supports a wide range of software applications.
  • Windows OS includes various built-in features and tools to enhance user productivity and system management.
  • Function Keys (F1-F12)
  • Function keys are located on the top row of a keyboard and serve specific purposes depending on the software being used.
  • In addition to F1 for help, other function keys include F2 for renaming files, F5 for refreshing the screen, and F11 for toggling full-screen mode in browsers.
  • These keys can often be customized or have additional functions when used with modifier keys like Ctrl, Alt, or Shift.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 232

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS Excel 365, how can you set a specific print area in MS Excel?

  1. AOption (a)

    By selecting the cells to be printed and defining the print area

  2. BOption (b)

    By adjusting the page margins in the print settings

  3. COption (c)

    By changing the font size and style in the spreadsheet

  4. DOption (d)

    By applying conditional formatting to the data

View answer & explanation

Correct answer

Answer: (a)A.

By selecting the cells to be printed and defining the print area

Why this answer is correct

The correct answer is By selecting the cells to be printed and defining the print area.

Key Points

  • To set a specific print area in MS Excel, you need to select the cells that you want to print.
  • After selecting the cells, you can define the print area by going to the Page Layout tab and selecting 'Print Area' and then 'Set Print Area'.
  • This ensures that only the selected cells will be printed, ignoring other parts of the worksheet.
  • Defining a print area is particularly useful for large worksheets where you want to print only a specific section of your data.

Additional Information

  • Page Layout Tab:
  • The Page Layout tab in MS Excel contains various options that allow you to control the appearance and layout of your printed worksheet.
  • Options include setting margins, orientation, size, print area, breaks, background, and print titles.
  • Print Area:
  • A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet.
  • When you set a print area, Excel saves the print area with the workbook.
  • Each worksheet in a workbook can have its own print area.
  • Page Breaks:
  • Page breaks are used to control the layout of the printed pages by specifying where one page ends and the next begins.
  • You can insert or remove manual page breaks to ensure the data is printed as you want.
  • Print Titles:
  • Print titles are rows or columns that are repeated on every printed page.
  • This is useful for large datasets where you want to have headers or specific columns visible on every page for better readability.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 233

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is the correct software used for Word processing?

  1. AOption (a)

    MS Excel

  2. BOption (b)

    MS PowerPoint

  3. COption (c)

    MS Word

  4. DOption (d)

    MS Access

View answer & explanation

Correct answer

Answer: (c)C.

MS Word

Why this answer is correct

The correct answer is MS Word.

Key Points

  • MS Word is a word processing software developed by Microsoft.
  • It is part of the Microsoft Office suite and is widely used for creating and editing text documents.
  • MS Word offers a variety of features like spell check, grammar check, text formatting, and image insertion.
  • It allows users to create professional documents such as reports, letters, resumes, and brochures with ease.

Additional Information

  • MS Excel
  • It is a spreadsheet program developed by Microsoft.
  • MS Excel is used for data analysis, financial modeling, and creating charts and graphs.
  • It offers features like pivot tables, formulas, and macro programming.
  • MS Excel is part of the Microsoft Office suite.
  • MS PowerPoint
  • It is a presentation software developed by Microsoft.
  • MS PowerPoint is used to create slide show presentations.
  • It offers features like slide transitions, animations, and multimedia integration.
  • MS PowerPoint is part of the Microsoft Office suite.
  • MS Access
  • It is a database management system developed by Microsoft.
  • MS Access is used to create and manage databases.
  • It offers features like forms, reports, and SQL queries.
  • MS Access is part of the Microsoft Office suite.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 234

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the purpose of spellcheck in email composition?

  1. AOption (a)

    To check for and correct spelling errors

  2. BOption (b)

    To format the email text

  3. COption (c)

    To add attachments to the email

  4. DOption (d)

    To translate the email into another language

View answer & explanation

Correct answer

Answer: (a)A.

To check for and correct spelling errors

Why this answer is correct

The correct answer is To check for and correct spelling errors.

Key Points

  • Spellcheck helps in identifying and correcting spelling mistakes in the text.
  • It enhances the professionalism and readability of the email content.
  • Spellcheck tools often provide suggestions for misspelled words, ensuring accuracy.
  • Automated spellcheck features can save time and reduce manual proofreading efforts.

Additional Information

  • Spellcheck in Email Composition:
  • Purpose: The main purpose of spellcheck is to identify and correct spelling mistakes in the text. This is crucial in professional communication to ensure that the email content is error-free and polished.
  • Functionality: Spellcheck tools work by scanning the text for words that are not found in the dictionary. When a misspelled word is detected, the tool highlights it and often provides suggestions for the correct spelling.
  • Importance: Using spellcheck helps maintain the credibility and professionalism of the sender. Emails with spelling errors can create a negative impression and may be perceived as unprofessional or careless.
  • Automatic vs Manual: Many email platforms offer automatic spellcheck features that underline misspelled words as you type. Additionally, users can manually run a spellcheck before sending the email to ensure all errors are corrected.
  • Formatting Email Text:
  • Formatting involves adjusting the font size, style, color, and alignment of the text to enhance the presentation of the email.
  • It is crucial for emphasizing important points and making the email visually appealing.
  • However, formatting is a separate function from spellcheck and does not involve correcting spelling errors.
  • Adding Attachments:
  • This function allows users to attach files such as documents, images, or other media to the email.
  • Attachments provide additional information or resources that support the email's content.
  • Adding attachments is a different task and is not related to correcting spelling errors.
  • Translating Emails:
  • Email translation tools convert the email text from one language to another.
  • This is helpful in communicating with recipients who speak different languages.
  • Translation is a separate feature and does not involve spellchecking the original text for spelling errors.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 235

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

If the custom format of a number is XX,XX,XXX then how will 4482023 be displayed in Microsoft Excel 365?

  1. AOption (a)

    448,20,23

  2. BOption (b)

    4,48,2023

  3. COption (c)

    44,82,023

  4. DOption (d)

    4482,02,3

View answer & explanation

Correct answer

Answer: (c)C.

44,82,023

Why this answer is correct

The correct answer is 44,82,023.

Key Points

  • In Microsoft Excel, custom number formats allow you to format numbers in a specific way, enhancing readability.
  • The format XX,XX,XXX is a custom format that groups digits in the 2-2-3 pattern, commonly used in certain locales for displaying large numbers.
  • When the number 4482023 is formatted with the custom format XX,XX,XXX, it will be displayed as 44,82,023.
  • This type of formatting is particularly useful in financial data representation, where clarity in large numbers is crucial.

Additional Information

  • Custom Number Formats in Excel
  • Custom number formats in Excel allow users to display numbers in various ways, including currency, percentages, dates, times, and more.
  • Custom formats are created using a combination of symbols and placeholders. For example, "#" is a digit placeholder, "," adds a thousand separator, and "0" forces a digit to display even if it's zero.
  • To create a custom number format, you can go to the "Format Cells" dialog box (Ctrl+1), choose "Custom," and then enter the desired format in the "Type" field.
  • Importance of Proper Number Formatting
  • Proper number formatting enhances the readability and comprehension of data, particularly in reports and financial statements.
  • It ensures consistency and professionalism in data presentation, which is vital for accurate interpretation and decision-making.
  • Using appropriate number formats can also help in avoiding errors and misinterpretations, especially in large datasets.
  • Examples of Custom Number Formats
  • ###,### - Displays numbers with comma separators for thousands. E.g., 1234567 will be displayed as 1,234,567.
  • 0.00% - Displays numbers as percentages with two decimal places. E.g., 0.1234 will be displayed as 12.34%.
  • [$$-409]#,##0.00 - Displays numbers as currency in US dollars with two decimal places. E.g., 1234.56 will be displayed as $1,234.56$.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 236

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is NOT an example of Instant Messaging in Internet?

  1. AOption (a)

    Discord

  2. BOption (b)

    Telegram

  3. COption (c)

    WhatsApp

  4. DOption (d)

    Email

View answer & explanation

Correct answer

Answer: (d)D.

Email

Why this answer is correct

The correct answer is Email.

Key Points

  • Email is a method of exchanging messages between people using electronic devices.
  • Email operates across computer networks, primarily the Internet, and it is not considered an instant messaging service.
  • Instant Messaging (IM) services, like Discord, Telegram, and WhatsApp, allow users to communicate in real-time.
  • Email is typically used for more formal or long-form communication, whereas IM services are used for quick, conversational exchanges.

Additional Information

  • Discord
  • Discord is a VoIP, instant messaging, and digital distribution platform designed for creating communities.
  • Users communicate with voice calls, video calls, text messaging, media, and files in private chats or as part of communities called "servers".
  • Telegram
  • Telegram is a cloud-based instant messaging, video telephony, and VoIP service.
  • It allows users to send messages, photos, videos, and files of any type, as well as create groups for up to 200,000 people or channels for broadcasting to unlimited audiences.
  • WhatsApp
  • WhatsApp is a freeware, cross-platform messaging and Voice over IP (VoIP) service owned by Facebook.
  • It allows users to send text messages and voice messages, make voice and video calls, and share images, documents, user locations, and other media.
  • Email
  • Email (electronic mail) is a method of exchanging digital messages over the Internet or other computer networks.
  • It was one of the first uses of the Internet and is still one of the most widely used services.
  • Emails are typically used for longer, more formal communications.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 237

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the default alignment for text entered in Microsoft Excel 365 cells?

  1. AOption (a)

    Left aligned

  2. BOption (b)

    Justified

  3. COption (c)

    Right aligned

  4. DOption (d)

    Center aligned

View answer & explanation

Correct answer

Answer: (a)A.

Left aligned

Why this answer is correct

The correct answer is Left aligned.

Key Points

  • By default, text entered into a cell in Microsoft Excel 365 is left-aligned. This means that the text starts at the left edge of the cell and moves towards the right.
  • Left alignment is the standard alignment for text in most spreadsheet applications, including Microsoft Excel, to ensure readability and consistency.
  • Numeric data, on the other hand, is right-aligned by default in Excel cells to facilitate easier reading and comparison of numbers.
  • Users can manually change the alignment of text in cells using the alignment options available in the toolbar or the Format Cells dialog box.

Additional Information

  • Cell Alignment in Microsoft Excel
  • Alignment refers to the position of text or data within the cell. It can be adjusted horizontally (left, center, right) or vertically (top, middle, bottom).
  • Horizontal alignment options include Left Align, Center Align, and Right Align, while vertical alignment options include Top Align, Middle Align, and Bottom Align.
  • Users can access alignment options from the Home tab in the Ribbon or by right-clicking on a cell and selecting Format Cells.
  • Proper alignment of cell contents is crucial for creating readable and professional-looking spreadsheets.
  • Format Cells Dialog Box
  • The Format Cells dialog box provides comprehensive options for formatting cells, including number formatting, alignment, font, border, fill, and protection.
  • To open the Format Cells dialog box, right-click on a cell or range of cells and select Format Cells, or press Ctrl+1 on your keyboard.
  • In the Alignment tab, users can set horizontal and vertical alignment, text control options (wrap text, shrink to fit, merge cells), and text direction.
  • Using the Format Cells dialog box, users can customize the appearance of their spreadsheet to improve readability and visual appeal.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 238

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

In MS word 365, in word-processing software, what is the key difference between copying of text and cutting of text?

  1. AOption (a)

    Copying is reversible, while cutting is irreversible.

  2. BOption (b)

    Copying removes the text from the original location, while cutting retains the text in the original location.

  3. COption (c)

    Copying duplicates the text to a new location, while cutting moves the text to a new location.

  4. DOption (d)

    Copying requires the use of a keyboard shortcut, while cutting is performed by using the mouse.

View answer & explanation

Correct answer

Answer: (c)C.

Copying duplicates the text to a new location, while cutting moves the text to a new location.

Why this answer is correct

The correct answer is Copying duplicates the text to a new location, while cutting moves the text to a new location.

Key Points

  • Copying creates a duplicate of the selected text in a new location without removing it from the original location.
  • Cutting moves the selected text from the original location to a new location, effectively removing it from the original place.
  • Both operations use the clipboard to temporarily store the text. When you paste, the text is retrieved from the clipboard.
  • These functionalities allow users to efficiently rearrange or replicate text within a document or across different documents.

Additional Information

  • Clipboard: The clipboard is a temporary storage area for data that the user wants to copy from one place to another. When you cut or copy data, it is stored on the clipboard until you paste it somewhere else.
  • Copying: When you copy text, the original text remains unchanged, and a duplicate of the text is placed in the clipboard. The copied text can then be pasted multiple times without affecting the original text.
  • Cutting: When you cut text, the original text is removed from its original location and placed in the clipboard. The cut text can then be pasted in a new location. Cutting is useful for moving text from one part of a document to another.
  • Pasting: Pasting inserts the clipboard's content into the new location. The text or data stored in the clipboard remains available for pasting until new data is cut or copied to the clipboard.
  • Keyboard Shortcuts: Common keyboard shortcuts for these actions include Ctrl+C (Copy), Ctrl+X (Cut), and Ctrl+V (Paste) on Windows, or Command+C, Command+X, and Command+V on macOS.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 239

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

What is the keyboard shortcut for changing text alignment to the left in MS Word 365?

  1. AOption (a)

    Ctrl + J

  2. BOption (b)

    Ctrl + C

  3. COption (c)

    Ctrl + L

  4. DOption (d)

    Ctrl + R

View answer & explanation

Correct answer

Answer: (c)C.

Ctrl + L

Why this answer is correct

The correct answer is Ctrl + L.

Key Points

  • In MS Word 365, Ctrl + L is the keyboard shortcut to align the text to the left.
  • This shortcut is used to quickly align a paragraph or selected text to the left margin.
  • Using keyboard shortcuts like Ctrl + L increases efficiency by reducing the need to navigate through menus.
  • Text alignment is an important aspect of document formatting, and left alignment is commonly used for most text documents.

Additional Information

  • Text Alignment in MS Word:
  • Left Alignment (Ctrl + L): Aligns the text to the left margin.
  • Center Alignment (Ctrl + E): Centers the text horizontally on the page.
  • Right Alignment (Ctrl + R): Aligns the text to the right margin.
  • Justify Alignment (Ctrl + J): Aligns the text to both the left and right margins, adding extra space between words as necessary.
  • Keyboard Shortcuts in MS Word:
  • Keyboard shortcuts are combinations of keys that provide an alternative way to do something that you’d typically do with a mouse.
  • They are designed to help users quickly perform common tasks and improve workflow efficiency.
  • Examples include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + Z for undo.
  • MS Word 365:
  • MS Word 365 is a word processing application that is part of the Microsoft Office 365 suite.
  • It offers a variety of features for creating, editing, and formatting documents.
  • Users can work collaboratively in real-time and access their documents from any device with internet connectivity.
Delhi Police Constable (Executive) 2023 Official Paper (Held On: 02 Dec, 2023 Shift 3) (Previous Year Paper)·Computer Awareness
View full paper

Question 240

Delhi Police Constable 2023• Computer Awareness• Computer Awareness

Which of the following is NOT a word processing package?

  1. AOption (a)

    Adobe Photoshop

  2. BOption (b)

    Microsoft Word

  3. COption (c)

    Apple Pages

  4. DOption (d)

    Google Docs

View answer & explanation

Correct answer

Answer: (a)A.

Adobe Photoshop

Why this answer is correct

The correct answer is Adobe Photoshop.

Key Points

  • Adobe Photoshop is a raster graphics editor developed and published by Adobe Inc. for Windows and macOS.
  • It was originally created in 1988 by Thomas and John Knoll. Since then, this software has become the industry standard not only in raster graphics editing but in digital art as a whole.
  • While Adobe Photoshop is widely used for photo editing, digital art, and graphic design, it is not a word processing package.
  • Word processing packages are specialized software applications used to create, edit, and format text documents. Examples include Microsoft Word, Apple Pages, and Google Docs.

Additional Information

  • Microsoft Word
  • Microsoft Word is a widely used commercial word processor designed by Microsoft.
  • It is a part of the Microsoft Office suite of productivity software.
  • Word allows users to create, edit, format, and print documents.
  • It provides tools for spell check, grammar check, text formatting, and more.
  • Apple Pages
  • Apple Pages is a word processing and desktop publishing application developed by Apple Inc.
  • It is part of the iWork productivity suite and runs on the macOS and iOS operating systems.
  • Pages allows users to create documents, newsletters, brochures, and more.
  • It features a variety of templates and design tools for creating visually appealing documents.
  • Google Docs
  • Google Docs is a web-based word processor offered by Google.
  • It is part of the Google Workspace suite of productivity tools.
  • Google Docs allows users to create, edit, and collaborate on documents in real-time.
  • Documents are stored in the cloud, making them accessible from any device with an internet connection.

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.