Data Entry MCQ Quiz - Objective Question with Answer for Data Entry - Download Free PDF
Last updated on Jul 15, 2025
Latest Data Entry MCQ Objective Questions
Data Entry Question 1:
How do you add text to a slide in MS PowerPoint?
Answer (Detailed Solution Below)
Data Entry Question 1 Detailed Solution
The correct answer is Click inside a text placeholder and start typing.
Key Points
- In MS PowerPoint, a text placeholder is a predefined area on the slide where text can be added easily.
- To add text, simply click inside the text placeholder and start typing your content.
- Placeholders are commonly found in slide layouts such as title slides, content slides, or bullet list slides.
- Text placeholders are designed to help maintain a consistent slide design and formatting throughout the presentation.
- Users can customize the font, color, size, and alignment of the text after typing to match their requirements.
Additional Information
- Text Placeholder:
- It is a box with dotted or dashed borders visible in slide layouts.
- Placeholders can also hold images, charts, tables, or other elements, but their default purpose is often text input.
- Slide Layouts:
- Each slide layout in MS PowerPoint determines the positioning of placeholders for title, content, and other elements.
- Common layouts include "Title Slide," "Title and Content," and "Two Content."
- Keyboard Shortcut Tips:
- There is no direct shortcut like Ctrl + T to add text; placeholders must be clicked manually.
- However, users can use shortcuts like Ctrl + A to select all text or Ctrl + E to center-align text.
- Custom Text Boxes:
- If no placeholder exists, users can insert a custom text box via the "Insert" tab.
- Select "Text Box," click on the slide, and then type text into the custom box.
- Formatting Options:
- Text formatting options are available under the "Home" tab in the Ribbon.
- Users can adjust font styles, apply bold/italic/underline effects, and change text colors.
Data Entry Question 2:
Which keyboard shortcut is used to save an MS Excel workbook?
Answer (Detailed Solution Below)
Data Entry Question 2 Detailed Solution
The correct answer is Ctrl + S.
Key Points
- Ctrl + S is the standard keyboard shortcut used in MS Excel, as well as most other software, to save the current file or workbook.
- When pressed, this shortcut ensures that the changes made to the workbook are stored in the file on the disk, preventing data loss.
- If the file is being saved for the first time, the "Save As" dialog box will appear to allow the user to specify the file name and location.
- This shortcut is part of the universally accepted Microsoft Office commands, ensuring consistency across various Office applications like Word, PowerPoint, and Excel.
- Using shortcuts like Ctrl + S improves productivity and minimizes the risk of losing unsaved work due to unexpected interruptions.
Additional Information
- Other Common Keyboard Shortcuts in MS Excel:
- Ctrl + N: Creates a new workbook.
- Ctrl + O: Opens an existing workbook.
- Ctrl + P: Opens the print dialog box for printing the workbook.
- Ctrl + Z: Undoes the last action.
- Ctrl + Y: Redoes the last undone action.
- AutoSave Feature:
- Microsoft Excel's AutoSave feature automatically saves changes to the workbook at regular intervals (if enabled).
- It is particularly useful when working on cloud-based platforms like OneDrive.
- Save As Command:
- Accessible via F12 or the File menu, this command allows users to save the file with a different name or in a different format.
- It is commonly used when creating multiple versions of a file.
- File Formats in MS Excel:
- Excel files can be saved in various formats, including .xlsx (default), .xls (Excel 97-2003), .csv (comma-separated values), and .pdf.
- Choosing the correct format is essential for compatibility and specific use cases.
- Importance of Regular Saving:
- Regularly saving your work ensures protection against unexpected system crashes, power outages, or accidental file closures.
- Experts recommend using Ctrl + S frequently during long working sessions to minimize data loss risks.
Data Entry Question 3:
Which of the following is the correct way to start a new blank presentation in MS PowerPoint?
Answer (Detailed Solution Below)
Data Entry Question 3 Detailed Solution
The correct answer is Press Ctrl + N.
Key Points
- Ctrl + N is the shortcut key used to create a new blank presentation in MS PowerPoint.
- This command is universally recognized across various versions of MS PowerPoint, including Office 2016, Office 2019, and Office 365.
- Using this shortcut automatically opens a new presentation with a default blank slide ready for content creation.
- File → New is another method to create a blank presentation but requires manual navigation through the ribbon.
- Keyboard shortcuts like Ctrl + N enhance productivity by saving time compared to manual navigation.
Additional Information
- MS PowerPoint
- MS PowerPoint is a presentation software developed by Microsoft, widely used for creating professional presentations.
- It is part of the Microsoft Office suite, compatible with Windows, macOS, and online platforms.
- It offers features like slide creation, animations, transitions, multimedia integration, and collaborative tools.
- MS PowerPoint supports multiple file formats, including .pptx and .pdf, for exporting presentations.
- Keyboard Shortcuts in MS PowerPoint
- Ctrl + N: Create a new presentation.
- Ctrl + O: Open an existing presentation.
- Ctrl + S: Save the current presentation.
- Ctrl + P: Print the presentation.
- These shortcuts help users perform tasks efficiently without relying on the mouse.
- Ribbon Interface
- The ribbon interface in MS PowerPoint provides access to tools and features through tabs like File, Insert, Design, and View.
- It enables users to perform advanced functions like adding transitions, animations, and multimedia to slides.
- Navigation through the ribbon can be enhanced using Alt key combinations.
- File Menu in MS PowerPoint
- The File menu is the starting point for managing presentations, offering options like New, Open, Save, and Export.
- It provides templates for creating presentations tailored to specific themes or industries.
- Users can access cloud services like OneDrive for saving and sharing presentations online.
Data Entry Question 4:
Read the following statements about Email and choose the CORRECT option.
i. The username and the domain name are separated by @ (at) symbol.
ii. E-mail addresses are case sensitive
Answer (Detailed Solution Below)
Data Entry Question 4 Detailed Solution
The correct answer is option 2.
Key PointsOption 1: The username and the domain name are separated by @ (at) symbol.
True, The @ (at) symbol is used to separate the user id from the domain name in the e-mail address.
Ex:
operations@testbook.com
ram@gmail.com
Here user-id is operations and ram.
The domain is Gmail and testbook.
Option 2: E-mail addresses are case-sensitive.
False, Email addresses are not case sensitive. Having letters in all lowercase makes the email address easier to read, but the oversight won't stop your messages from being delivered.
Hence the correct answer is i is true, ii is false.
Data Entry Question 5:
Which of the following icons is NOT available in the Clipboard group of the Home tab in MS-Word 365?
Answer (Detailed Solution Below)
Data Entry Question 5 Detailed Solution
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.
Top Data Entry MCQ Objective Questions
_______ is used for sending emails, whereas _______ is used for receiving emails.
Answer (Detailed Solution Below)
Data Entry Question 6 Detailed Solution
Download Solution PDFThe 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.
In power point, Themes could be found under-
Answer (Detailed Solution Below)
Data Entry Question 7 Detailed Solution
Download Solution PDFThe 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.
Which of the following is not a valid function in MS Excel?
Answer (Detailed Solution Below)
Data Entry Question 8 Detailed Solution
Download Solution PDFThe 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.
Which of the following is used to move an active cell to the first column on the current row?
Answer (Detailed Solution Below)
Data Entry Question 9 Detailed Solution
Download Solution PDFThe 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.
______ allows you to create a new presentation and open an existing presentation.
Answer (Detailed Solution Below)
Data Entry Question 10 Detailed Solution
Download Solution PDFThe 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.
What is the shortcut to enable filtering of selected cells in MS-Excel?
Answer (Detailed Solution Below)
Data Entry Question 11 Detailed Solution
Download Solution PDFThe 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:
Close a workbook |
Ctrl+W |
Open a workbook |
Ctrl+O |
Go to the Home tab |
Alt+H |
Save a workbook |
Ctrl+S |
Copy |
Ctrl+C |
Paste |
Ctrl+V |
Undo |
Ctrl+Z |
Remove cell contents |
Delete |
Choose a fill colour |
Alt+H, H |
Cut |
Ctrl+X |
Go to the Insert tab |
Alt+N |
Bold |
Ctrl+B |
Center align cell contents |
Alt+H, A, C |
Go to the Page Layout tab |
Alt+P |
Go to the Data tab |
Alt+A |
Go to the View tab |
Alt+W |
Open context menu |
Shift+F10, or Context key |
Add borders |
Alt+H, B |
Delete column |
Alt+H, D, C |
Go to the Formula tab |
Alt+M |
Hide the selected rows |
Ctrl+9 |
Hide the selected columns |
Ctrl+0 |
The valid format of MS Word is :
Answer (Detailed Solution Below)
Data Entry Question 12 Detailed Solution
Download Solution PDFThe 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
An email address consists of _____ parts.
Answer (Detailed Solution Below)
Data Entry Question 13 Detailed Solution
Download Solution PDFThe 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.
___________ in Microsoft Excel always begins with an equal to sign(=).
Answer (Detailed Solution Below)
Data Entry Question 14 Detailed Solution
Download Solution PDFThe 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
Symbol | Function |
+ | To perform a simple Addition operation |
- | To perform a simple Subtraction operation |
> | Comparison Operator(Greater than) |
In MS PowerPoint, key used to run the Slide Show from the beginning is -
Answer (Detailed Solution Below)
Data Entry Question 15 Detailed Solution
Download Solution PDFThe 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.