Data Entry MCQ Quiz - Objective Question with Answer for Data Entry - Download Free PDF

The correct answer is Clear All Formatting.

Key Points

• MS Word allows you to clear bold texts, underlines, subscripts and superscripts etc from the text and revert to the default formatting style.
• Clear All Formatting is a tool that clears the formatting and comments and applies the default format. Hence option 1 is correct.
• To do this, go to the home menu and click erase symbol in the font section.

Additional Information

• To clear only formatting, use Clear format.
• To clear only content in the selected cells, use Clear content. It will leave formatting.

The correct answer is POP.

Key Points

• Email protocols are a set of rules defined to ensure the reliable and secure exchange of data between various servers. These protocols define how an email has to be encoded, sent, received and rendered.
• Various protocols are used for email delivery, such as Post-Office Protocol (POP), Internet Message Access Protocol (IMAP), Simple Mail Transfer Protocol (SMTP) etc.
• In POP, the POP client is installed on the recipient system, and the POP server is installed on the recipient's mail server. It is used to retrieve email from an email server for client applications. Hence option 3 is correct.
• POP is an application layer protocol. It supports offline access to email, but to access offline, email has to be downloaded. This protocol is used to retrieve emails for a single client.

Additional Information

• SMTP transfers emails between email clients and servers but primarily for sending emails.
  • It is a transport layer protocol and is sometimes paired with POP and IMAP to retrieve emails. SMTP is reliable because it sends an error message if the mail is not delivered to the receiver.
• IMAP is an application layer protocol used to retrieve mail for multiple clients. It supports both offline access and online access to email.
  • It allows two-way sync of emails between the email server and the email client.
• Multipurpose Internet Mail Extension Protocol (MIME) is a protocol that allows non-ASCII values to be sent through SMTP. 
  • It supports different data like images, videos, audio files, etc., and allows multiple attachments with a single message.

The correct answer is Android.

Key Points

• Android is not a web-based search engine but rather a mobile operating system developed by Google.
  • It is designed for touchscreen devices such as smartphones and tablets.
  • Android provides the platform for users to install apps, including web browsers and search engine apps, to access the internet.
  • While Google, Bing, and Yahoo are search engines used to find information on the web, Android serves as the operating system enabling the device’s functionality.
  • Search engines like Google and Bing can be accessed on Android devices through web browsers or dedicated apps.

Additional Information

• Bing, Google, and Yahoo are conventional web-based search engines used to find information on the internet.
• Web-based search engines work by crawling, indexing, and ranking web pages to provide relevant search results based on user queries.
• Android powers millions of devices globally and supports various apps, including those for communication, entertainment, productivity, and web browsing.
• While Android allows you to access search engines, it itself is not a search engine.

The correct answer is Multiple at signs (@)

Key Points

• Email ID Format: A valid email ID typically follows the format username@domain.com.
• Multiple @ Signs: ❌ Invalid. An email ID can contain only one @ symbol. Having more than one breaks the standard structure and is not accepted by email systems.
• Multiple Digits: ✅ Valid. Digits 0-9 can be used in any number within the local part of the email.
• Multiple Dots: ✅ Valid if used correctly. Dots can be used in the local part (username), but not at the beginning, end, or consecutively.
• Multiple Underscores: ✅ Valid. Underscores are allowed in the username part of the email.

Additional Information

• Email addresses are governed by RFC 5322 standards.
• Only one @ is permitted, separating the local and domain parts.
• Domain names must follow valid DNS naming conventions.

Hence, the correct answer is: option 4) Multiple at signs (@)

Here is the requested explanation of the correct answer in a valid HTML format based on the provided CSV data and structure: ```html

The correct answer is MS PowerPoint.

Key Points

• MS PowerPoint is a powerful software application widely used for creating, modifying, and presenting slideshows.
• It allows users to include a combination of text, images, animations, videos, and sound in their presentations.
• With its user-friendly interface, MS PowerPoint is ideal for creating visually engaging presentations on topics such as cybercrime, prevention, and laws.
• Users can apply different colors to text, add transitions and animations to slides, and embed multimedia content like videos and audio seamlessly.
• MS PowerPoint supports exporting presentations in various formats, including PPTX, PDF, and video, making it versatile for sharing and presenting.

Additional Information

• MS PowerPoint is part of the Microsoft Office suite and is compatible with both Windows and macOS operating systems.
• It offers templates and design tools that help users create professional presentations with minimal effort.
• Collaborative features in MS PowerPoint allow multiple users to edit and review presentations simultaneously using cloud-based tools like OneDrive.
• It also integrates with other Microsoft Office applications, such as Excel and Word, for seamless data sharing and embedding.
• MS PowerPoint is widely used in educational, corporate, and personal settings for training sessions, project reports, and event presentations.

The correct answer is SMTP, POP.

Key Points

• SMTP is used for sending emails, whereas POP is used for receiving emails.
• SMTP stands for Simple Mail Transfer Protocol.
• POP stands for Post Office Protocol.
• SMTP is a set of communication guidelines that allow the software to transmit electronic mail over the internet.
• Post Office Protocol is an application-layer Internet standard protocol used by e-mail clients to retrieve e-mail from a mail server. 

The correct answer is Design tab.

• Themes could be found in Design tab.
• The Design Tab contains all the features to change the look of your document in one place.

Additional Information

• To find out how to format your document using the design tab follow these simple instructions.

• To format your document with a theme
  • Select Design (tab) | Document Formatting (group) | Themes (drop-down button)
  • Select a theme from the drop-down list.

The correct answer is SUBTRACT().

Key Points

SUBTRACT() is not a valid function in MS Excel

Subtract two or more numbers in a cell :

1. Click any blank cell, and then type an equal sign (=) to start the formula.

2. After the equal sign, type a few numbers that are separated by a minus sign (-).

for example, 100-50-30.

3. Press RETURN, then the result is 20.

Additional Information

SUM()

• The SUM() adds values.
• You can add individual values, cell references or ranges, or a mix of all three.
• For example: =SUM(A2:A10) Adds the values in cells A2:10.

• COUNTA - It will allow you to evaluate any gaps the dataset might have without having to reorganize the data.

COUNT()

• The COUNT() is generally used to count a range of cells containing numbers or dates excluding blanks

COUNTA()

COUNTA() will count everything as numbers, dates, text, or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for the count all.

The correct answer is Home.

Key Points

• The Home key is used to move the active cell to the first column on the current row in spreadsheet applications like Microsoft Excel.
• This function is helpful for quickly navigating to the beginning of the row without using the mouse.

Additional Information

• Page Up:
  • This key is used to move the active cell up by one screen.
• Ctrl + Home:
  • This key combination moves the active cell to the beginning of the worksheet (cell A1).
• Page Down:
  • This key is used to move the active cell down by one screen.

The correct answer is Task pane,

Key Points

• The Task Pane is a rectangular window that appears docked on the right side of your PowerPoint window.
• It acts as an open menu allowing you to select from a range of commands and functions.
• It displays a list of links and commands allowing you to perform different tasks depending on what you are doing at the time.
• The task pane is designed to help you complete tasks quickly and will change automatically according to the task in hand.

Additional Information

• Placeholder: The term “placeholder” is used to identify the containers on a slide which are shown with a dotted external border. Placeholders are specifically used to position different types of content on the slide and are preformatted for you to provide consistent formatting between each slide.
• Outline pane: The Outline pane appears at the left, showing only the text in your presentation.
• Slide pane: Slide pane contains the current slide in your presentation. You can use the vertical scroll bar to view other slides in the presentation. Notes pane is located below the slide pane and is used to type reference notes.

The correct answer is Ctrl + shift + L.

Key Points

Ctrl + shift + L is the shortcut to enable filtering of selected cells in MS-Excel.

Additional Information

Shortcuts in Excel:

The correct answer is .doc.

Key Points

• The valid format of MS Word is .doc.
• .docx has been the default file type for Microsoft Word since the 2007 version, i.e. in Word 2007, Word 2010, Word 2013, and Word 2016.

Additional Information

• Extension of some other important files:
  • Excel file - Xls
  • Text file - txt
  • Powerpoint file - ppt 
  • Open document - Odt

The correct option is 1).

A valid email address is an address composed of two parts, a username, and a domain name. The prefix appears to the left of the @ symbol. The domain appears to the right of the @ symbol. For example, in the address name@website.com, "name" is the email prefix, and "website.com" is the email domain

The 2 parts of an Email Address are:

Username - The first part of an email address is the username.
Domain - The last part of an email address is the domain, which can be broken down into two portions: the mail server and the top-level domain.

The correct answer is "Formulae".

Key Points

• MS Excel
  • It is a spreadsheet program for data analysis and documentation.
  • It contains a number of rows and columns, where the intersection of a column and a row is a "cell".
  • Each cell contains one point of data.
  • It is developed by Microsoft.
  • It features calculation, graphing tools, pivot tables, etc.
• The function of (=) sign (Starting of Formula)
  • ​All Excel formulas begin with an equals sign,=, followed by a specific tag denoting the formula.
  • For example, =B1+B2+B3 is a formula that adds up the values in the cells B1 through B3.

Additional Information

The correct answer is F5.

Key Points

• PowerPoint:
  • It is used to create overhead transparency, paper, 35mm slides, Photo Print, or on-screen presentations. We can insert pictures (gif, jpeg), sounds, animation, video (mp4), and type text in presentations.
  • There are Auto Layouts and templates that make the creation of a presentation simple. 
  • F5: Start a presentation from the beginning
  • Shift+F5: Start a presentation from the current slide
  • Alt+F5: Start the presentation in Presenter View
  • Enter, Page Down, Right arrow key, Down arrow key, Spacebar, N: Perform the next animation or advance to the next slide
  • P, Page Up, Left arrow key, Up arrow key, Backspace: Perform the previous animation or return to the previous slide
  • Ctrl+H: Hide the pointer and navigation buttons
  • B, Period (.): Display a blank black slide, or return to the presentation from a blank black slide.
  • W, Comma (,): Display a blank white slide, or return to the presentation from a blank white slide.
  • S: Stop or restart an automatic presentation.
  • Esc, Hyphen (-): End the presentation.