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

The correct answer is Quick Access Toolbar

Key PointsQuick Access Toolbar -

• Positioned just above the Ribbon, the Quick Access Toolbar in MS-PowerPoint 2016 provides commands you are likely to use frequently. It's customizable and by default, it includes commands such as Save, Undo, and Redo. It remains constant no matter which tab/menu in the Ribbon you are currently accessing.

​

Additional Information

Status Bar - Located at the bottom of the PowerPoint window, the status bar displays information about the current presentation such as the number of slides, slide number being viewed, theme, etc. It can also have view buttons and a zoom slider.

Title Bar - This is the uppermost part of the application window where the name of your presentation is displayed. It also contains buttons to close, minimize, or maximize the window.

Scroll Bar - It's situated on the right and sometimes bottom side of the PowerPoint window, the scroll bar allows you to navigate through your slides or if zoomed in, throughout different parts of a single slide, by clicking and dragging the scroll bar or clicking the arrows at its end.

The correct answer is Select the empty cell available next in the left direction to the current selection.

Key Points

• The function of the shortcut key Ctrl + Shift + F4 is to select the empty cell available next in the left direction to the current selection. 
• Microsoft Office program includes MS-EXCEL.
• It is an electronic spreadsheet with many rows and columns that is used for data organization, graphic data representation, and various calculations.

Additional Information

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