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 11.

Key Points

• When opening a new document in Microsoft Word 2016, the default font size is 11 points.
• 11 points size means it is approximately 0.152778 inches.
• 72 points size means the text size equals 1 inch.
• The default font style in MS Word 2016 is Calibri.

The correct answer is F5.

Key Points

• Pressing F5 is a widely recognized shortcut to start a slideshow from the beginning in Microsoft PowerPoint.
• When you press F5 in PowerPoint, the presentation opens in full-screen mode starting from the first slide.
• This shortcut is useful for quickly previewing or presenting your slides without manually navigating through the PowerPoint interface.
• Using F5 saves time and ensures a smooth transition into the slideshow mode.
• It is a universal shortcut across different versions of Microsoft PowerPoint, making it a consistent tool for presenters.

Additional Information

• Other useful PowerPoint shortcuts include Shift + F5 to start the slideshow from the current slide and Ctrl + P to activate the pen tool during a presentation.
• Knowing these shortcuts can enhance the efficiency and professionalism of your presentations.
• Practice using these shortcuts to become more familiar with them and improve your presentation skills.
• In addition to keyboard shortcuts, PowerPoint offers various features and tools to customize and enhance your slideshow experience.

The correct answer is Option 1) Go to Home > Insert > Insert Sheet Columns.

Key Points

• To insert a new column in applications like Microsoft Excel, go to the Home tab, click on Insert, and then choose Insert Sheet Columns.
• This inserts a new column to the left of the currently selected column.
• You can also right-click a column letter and choose Insert for quick access.

Additional Information

• Option 2 is incorrect — the File tab is used for file operations, not inserting columns.
• Option 3 is incorrect — Ctrl + Z is used for undo, not inserting columns.
• Option 4 is incorrect — Ctrl + X is used to cut content, not insert columns.
• Shortcut for inserting a new column via right-click: Right-click the column header > Insert.

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

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 [email protected], "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.