Welcome to the Data Entry Operator (DEO) Mock Test!
Please read the following instructions carefully before starting the test:

This is a mock test designed to help you practice for the DEO examination.
Each question carries one mark. There is no negative marking.
You will see one question per page. Click Next to move to the next question.
Once you submit your answer, it cannot be changed.
After completing all questions, click Submit Testto view your result.
Please do not refresh or close the window during the test.
This test is for practice purposes only — your score will not affect any official exam.
If you find any incorrect question or answer, please contact us immediately at [info.tathyasathi@yahoo.com].

Which view in Power Point is used for editing individual slide layouts?

Slide Master

Notes Page

Outline

Reading View

None

In word, how do you create a bulleted list?

Click the Numbering button in the Paragraph group

Click the Bullets button in the paragraph group

Use the Styles menu

Press Ctrl+B

None

What is the purpose of a Pivot Table in Excel?

To create charts and graphs

To find specific data

To merge cells

To summarize and analyze data

None

In Power Point, which feature is used to animate objects on a slide?

Transitions

Animations

Design

Slide Show

None

Which of the following is used to change the orientation of a document in Word?

Review

View

Reference

Page Layout

None

In Excel, what does the function VLOOKUP do?

Verifies the validity of data

Looks up a value in a table and returns a corresponding value

Calculates the vertical sum of a range

Finds the vertical position of a cell

None

Which of the following is a file extension for PowerPoint Presentation?

.pptx

.potx

.txt

.docs

None

In Word how do you insert a table?

Home tab, Table group

Design tab, Table group

Insert tab, Table group

Layout tab, Table group

None

What is the function of the 'AutoSum' button in Excel?

Automatically sorts a range of cells

Automatically saves a work book

Automatically adds a range of cells

Automatically formats a range of cells

None

In Power Point, how do you insert a new slide?

Home tab, slides group

Insert tab, Slides group

Design tab, Slides group

Slide show tab, Slides group

None

Which feature in Word allows you to quickly apply a set of formatting choices?

Themes

Templates

Layouts

Styles

None

In Excel what does the function 'CONCATENATE' do?

Joins multiple text strings into one

Counts the number of cells with text

Calculates the sum of a range

Finds the average of a range

None

Which view in Power Point allows you to rehearse timings for your slides?

Slide Show

Presenter View

Slide Sorter

Reading View

None

In Word What is the function of the 'Header' and ;Footer'?

To insert page numbers

To add text at the top and bottom of every page

To change the documents layout

To insert images

None

In Excel ,what is a 'Chart'?

A graphical representation of data

A type of formula

A data validation tool

A worksheet

None

In Power Point what does the 'Slide Master ' view allow you to do?

Rehearse slide timings

Add animations to slides

Insert new slides

Edit the overall design of the presentation

None

In Word ,how do you create a hyperlink?

Insert tab , Links group

Home tab, Links group

Design tab, Links Group

References tab, Links group

None

Which of the following is used to protect an Excel workbook with a password?

Home tab,Media group

Design tab,Media group

File tab, Info group

Insert tab, Text group

None

In Power Point how do you insert a video?

Insert tab , media group

Home tab, media group

Design tab Media group

Slide shoe tab Media group

None

In word what is the 'Review' tab used for?

To insert tables and charts

To change the page layouts

To check spelling and grammer

To format text

None

In Excel what does the 'Freeze Panes' feature do?

Sorts data in ascending order

Filters data

Formats cells

Keeps rows or columns visible while scrolling

None

In Power Point, what is the 'Notes Page' view used for?

To add speaker notes to slides

To create handouts

To rehearse timings

To add animations

None

In word what does the Find & Replace feature do?

Finds and replaces specified text

Changes the documents layout

Inserts a new paragraph

Saves the documents

None

In Excel what does the Data Validation feature do?

Sorts Data

Protects a worksheet

Formats cells

Ensures data entered into a cell meets specified criteria

None

In Power Point, what is the 'Animation Pane' used for?

To inserts new slide

To manage animation effects on a slide

To change the slide layout

To apply slide transitions

None

In Word, how do you change the line spacing?

Insert Tab ,Text Group

Home Tab, Paragraph Group

Design Tab, Paragraph Group

Layout Tab, Text Group

None

In Excel, What is a 'Workbook'

A single sheet of data

A type of chart

A formula

A file containing one or more worksheets

None

In Power Point, what does the 'Rehearse Timings' feature do?

Records the time spent on each slide

Inserts slide Transitions

Adds animations

Creates handouts

None

In Word, what is the purpose of 'Mail Merge'?

To send emails

To insert tables and charts

To create personalized letters and labels

To track changes in a document

None

In Excel, what does the Filter feature do?

Displays only the rows that meet certain criteria

Sorts data in ascending order

Calculates the sum of a range

Formats cells

None

In Power Point what is the 'Slide Sorter' view used for?

To Insert new slide

To add animations

To rearrange slides

To create handouts

None

In Word, how do you insert a page break?

Layout tab, Pages group

Design tab, Pages group

Home tab, Pages group

Insert tab, Pages group

None

In Excel, what is the 'SUMIF' function used for?

To sum cells that meet a specified condition

To calculate the average of a range

To count the number of cells with numbers

To find the highest value in a range

None

In Power Point, what does the 'Handout Master' view allow you to do?

Edit the layout and format of handout

Rehearse slide timings

Add animations to slides

Insert new sides

None

In word what does the 'Format Painter' tool do?

Inserts a new paragraph

Saves the document

Changing the document Layout

Copies formatting from one part of the document to another

None

In Excel, what is the purpose of 'Conditional Formatting'?

To format cells based on specific criteria

To sort data in ascending order

To calculate the sum of a range

To filter data

None

In Power Point how do you change the theme of a presentation?

Home tab, Themes group

Design tab, Themes group

Insert tab, Themes group

Slide Show tab, Themes group

None

Which of the following is a web browser?

Adobe Photoshop

Ulla

Windows 10

Microsoft Word

None

What does the acronym 'URL' stand for?

Uniform Resource Locator

Universal Resource Lucator

Uniform Resource Link

Universal Resource Link

None

Which protocol is used to transfer web pages on the internet?

FTP

HTTP

SMTP

SNMP

None

What is the purpose of a firewall in computer networks?

To store data

To perform calculations

To protect against unauthorized access

To connect to the internet

None

Which of the following is an example of a search engine

Microsoft Excel

Google

Adobe Reader

VLC Media Player

None

What does the acronym 'IP' stand for in networking?

Internal Protocol

Internet Protocol

Intranet Protocol

International Protocol

None

Which of the following is a type of malware?

Antivirus

Firewall

Trojan Horse

Router

None

What does phishing refer to in terms of cyber security?

Sending large amounts of spam emails

Attempting to obtain sensitive information by pretending to be a trustworthy entity

Scanning a computer for viruses

Blocking unauthorized access to a network

None

Which of the following is used to send an email?

FTP

HTTP

SMTP

SNMP

None

What is the primary function of a VPN?

To provide a secure connection over a public network

To speed up internet browsing

To block pop-up ads

To protect against viruses

None

Which of the following is a strong password?

12345678

password

P@ssw085*

abdef00

None

What does 'SSL' stand for in terms of web security?

Secure Storage Layer

Secure System Layer

Secure Sockets Layer

None

Which of the following is a secure way to log into an online account?

Using a public Wi-Fi network without a VPN

Using a common password across multiple accounts

Enabling two-factor authentication

Sharing your password with others

None

Well Done!
You’ve completed this mock test.
📩 Found any mistake? Contact us

Sign In

Register

Reset Password