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

The correct answer is Escape (Esc)

Key Points

• Esc Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog, or message window.  

Additional Information 

• The spacebar can delete the content when you enter a value in the cell if you press it.
• MS Excel:
  • Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.
  • By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed.
  • Excel contains a large number of boxes called cells that are ordered in rows and columns.

The correct answer is option 3

Key Points Clipboard group of the Home tab in MS-Word 365:

•  Cut: Removes selected content and places it on the clipboard.
•  Copy: Duplicates selected content and places a copy on the clipboard.
•  Paste: Inserts content from the clipboard at the cursor location.
•  Format Printer: Copies formatting from one place and applies it to another.

Additional Information

•   Text Highlight Color: Applies a colored background to selected text for emphasis or organization. It is under the Font Group of the Home Tab.

​

The correct answer is Worksheets.

Key Points

• Workbook
  • In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.
  • A workbook contains several worksheets with related content and only one of the worksheets is active at a time.
• Worksheet
  • Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you Interact with to enter data.
  • Each Worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

Additional Information

• Excel
  • Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.
  • Using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
• To open Ms Excel on your computer, follow the steps given below:
  • Click on Start
  • Then All Programs 
  • The next step is to click on MS Office
  • Then finally, choose the MS-Excel option
• Alternatively, you can also click on the Start button and type MS excel in the search option available.

Note:

Important Points

• An Excel workbook is a collection of worksheets, also known as spreadsheets. It can contain multiple sheets where you can enter and organize data.
• Charts, on the other hand, are visual representations of data that can be created within a worksheet using the data present in that particular worksheet or other worksheets in the workbook.
• So, while a workbook can contain both worksheets and charts, the primary component of an Excel workbook is the collection of worksheets.

The correct answer is option 3.

 Key Points

• The part of the computer used for calculating and comparing is the Arithmetic Logic Unit (ALU).
• The ALU performs arithmetic operations (addition, subtraction, multiplication, division) and logical operations (AND, OR, NOT) on data.
• The ALU is a component of the CPU (Central Processing Unit). • The ALU operates on binary data.

 Additional Information

• Disk unit: The disk unit is used for storage of data and programs. It is not involved in calculating or comparing data.
• Control unit: The control unit is responsible for coordinating and controlling the operations of the CPU. It does not directly perform calculations or comparisons.
• Modem: A modem is a device that enables communication between computers over a network. It is not involved in calculating or comparing data. 

The correct answer is Select cell → Right click → Format cell

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.