Font size
WorksheetsData Operations MOCK 2025
Total questions: 67
Worksheet time: 35mins
Which of the following is NOT a component of verbal communication?
Tone of voice
Words
Pitch
Facial expressions
Active listening involves which of the following skills?
Daydreaming while nodding occasionally
Interrupting the speaker to give advice
Reflecting back what the speaker has said
Ignoring non-verbal cues
Which of the following is an example of effective verbal communication in a professional setting?
Using technical jargon to appear knowledgeable
Speaking loudly to dominate the conversation
Asking open-ended questions to encourage discussion
Using slang and informal language
Which type of verbal communication is used to clarify and understand the speaker's message?
Direct communication
Passive communication
Reflective listening
Assertive communication
Paraphrasing is an important verbal communication skill because it:
Shows you were not paying attention
Reinforces your own opinion
Demonstrates understanding of the speaker's message
Allows you to change the subject
Which of the following is considered non-verbal communication?
Body language
Phone call
Text message
What is non-verbal communication?
communicating with someone by using gestures
Getting messages across with facial expressions
Using your body language to convey something to someone else
All of the above
Which of these is NOT an example of a verbal communication skill?
The speed of our speech
Eye contact
Language used
Volume of speech
Why do we have to make sure we do not speak too fast when communicating with a customer?
They may not hear everything you've said like promotions or special products
The customer may speak fast also because you are
It may give the customer a migraine
The customer may get excited and burst into song
Reading and responding to body language, using facial expressions and using silence are all examples of what?
Open listening
Pretend listening
Clarity listening
Active listening
Facial expressions, posture and eye contact are all skills in:
Verbal communication
anti-verbal communication
post-verbal communication
non-verbal communication
Using communication skills effectively will help you do what?
understand the customer's request
provide the customer with the right information and service
make sure the customer feels look after and understood
all of the above
Two types of communication are:
Verbs and Nouns
Verbal and information
Verbal and non-verbal
Happy and sad
An example of verbal communication is:
Phone conversation
Posture
Eye contact
Writing an email
Good customer service is the ability of an organization to constantly and consistently exceed:
The speed of sound
The customer's expectations
The rainfall in South America
Their competitor's sales
We communicate by:
Speech (Telephone call, conversations, etc)
Visuals (Body language, facial expressions)
Writing (Letter, emails, newsletters, etc)
All of the above
ALL of the following are data types in MS Access Except?
Yes/NO
date/time
Integer
Text
Which of the following software is used to make a database?
MS WORD
MS EXCEL
MS DATABASE
MS ACCESS
Your Data operation teacher told you to enter one piece of data from a record in a table in your database. This piece of data to be entered is date of birth. This ONE piece of data is called a:
Row
File
Field
Record
The object that is used to produce a list of records that meet a particular criterion is a:
Form
Table
Query
Relationship
Which field type will you select if you need to enter long text in that field?
Text
Memo
Currency
Auto number
Which of the following is not a type of MS Access database object?
Table
Form
Worksheets
Report
What can be the maximum length of a text field?
120
255
265
20
The columns in a Microsoft access table are also called _______
Rows
Records
Fields
Cells
In MS Access, a field is also referred to as a _______
Record
Table
Attribute
Column
In general, which of the following cannot be used as a primary Key?
TRN number
Age number
Passport number
Telephone number
In the telephone number "876 409-2891", which data type should be used?
Memo
number
Text
yes/no
Which of the following objects stores data in MS Access?
Relationship
Table
Forms
Query
What is the first stage in creating a table in design view?
Select create tab
Select file
Select design view
Select home
What does the Internet prefix WWW stand for?
Wisconsin Wind Weather
Western Washington World
Word Wide Web
Wide Width Wickets
Facebook, WhatsApp, Twitter and Snapchat are example of:
Digital Devices
Social media
Viruses
Podcast
How can you tell if a website is secure?
you'll see a paper in the address bar.
You'll see a lock in the address bar
You'll see an address bar.
You'll see a key in the address bar
What does HTML stand for?
Heuristic Text Modelling Language
Hyper Text Markup Language
Hyper Text Modelling Language
Heuristic Text Markup Language
Chrome, Safari, Firefox and Internet Explorer are all examples of?
Web Authoring Software
Interpreters
Browsers
Compilers
A thread of glass that can transmit information using light.
USB cable
WiFi Transmission
Fiber Optic Cable
Binary code Transmission
The computer or device that is used for sending data is called____________-
Sender
Receiver
Manager
Follower
It is a set of rules that governs the data communications. It represents an agreement between the communicating devices.
Sender
Receiver
Transmission Media
Protocol
Types of communication media
Twisted and coaxial cables
duplex
Bluetooth
wired and wireless
Which network connects computers within a large geographical area?
Wide Area Network
Local Area Network
Metropolitan Area Network
None of the above
Radio-waves, microwave, infrared, satellite and bluetooth are examples of which media?
wired
television
wireless
Computer
In a spreadsheet, what is the purpose of absolute cell referencing?
To make a cell reference dynamic
To lock a cell reference so that it doesn't change when copied
To create a hyperlink to another worksheet
To format the cell with a specific color
Which symbol is used to indicate absolute cell referencing in Excel?
$
%
#
@
What does the formula =$A$1 represent in a spreadsheet?
The cell A1 with relative referencing
The cell A1 with absolute referencing
The sum of column A and row 1
A multiplication operation on cells A and 1
When you copy a formula with absolute cell references, which part of the reference remains unchanged?
Column letter
Row number
Both column letter and row number
None of the above
In Excel, what is the keyboard shortcut to insert a dollar sign ($) in a cell reference?
Ctrl + D
Alt + $
Shift + $
Ctrl + $
Which of the following is a valid example of an absolute cell reference in Google Sheets?
A1
$A1
A$1
$A$1
What is the purpose of the "Fill Handle" in Excel?
To create charts and graphs
To fill cells with a series or copy data
To format text within a cell
To change the font size
Choose the most appropriate data type for Salary
Text
Number
Date/Time
Currency
Choose the most appropriate data type for details of an accident
Text
Number
Date/Time
Currency
Choose the most appropriate data type for Date you visit the hospitals
Text
Number
Date/Time
Currency
Choose the most appropriate data type present or not at school on Friday"
Text
Yes/No
Date/Time
Currency
What is a database?
A spreadsheet used to calculate values
A collection of web pages
An organized collection of data
A programming language
Which of the following are advantages of a Database Management System (Choose TWO)?
Slower data retrieval
Data redundancy is reduced
Improved data security
Manual calculations are easier
Which of the following are disadvantages of a manual database (Choose TWO)?
Quick data retrieval
Prone to errors
Easy to update
Time-consuming
How many fields are in the table?
3
8
5
5
How many records are in the table?
4
6
10
9
What is the appropriate data type for the "CLASS" field?
Text
Number
Currrency
Yes/No
Which field would be best used as the primary key, and why?
A) CLASS - because it is alphabetical
B) NAME - because it is unique
C) ID - because it uniquely identifies each record
D) GPA - because it’s numeric
Which field is suitable as a primary key?
GPA
AGE
ID
NAME
What data type is appropriate for GPA?
Text
Number
Currency
Date/Time
How many fields are in the table?
3
5
6
2
How many records are in the table?
2
5
6
8
What is the field size for AGE likely to be?
1
2
3
4
Which of the following are examples of web browsers? (Choose THREE)
Google Chrome
Microsoft Word
Mozilla Firefox
MS Edge
Excel
What is Data Security?
Locking a file cabinet
Protection of data from unauthorized access
Using a strong password for email only
Removing data from a system
Which of the following are examples of physical access restrictions? Choose 2
Biometric scanners
Passwords
Security guards
Locks
Which of the following are careers in Information Technology? (Choose THREE)
Network Administrator
Librarian
Database Analyst
Web Developer
Farmer
