wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Information technology

Total questions: 100

Worksheet time: 58mins

Name
Class
Date
1.

Sharing of information between two or more individuals or within a group to reach a common understanding is known as.

a)

skills

b)

communication

c)

self management

d)

all of the above

2.

The skills that are essential for effective communication are ________.

a)

good reading & writing,

b)

speaking & listening

c)

None of the above

d)

All of the above

3.

The listener participates fully in the communication process in ______ listening.

a)

active

b)

passive

c)

impatient

d)

unaware

4.

From the image the brain’s ability to make sense of what

we see through our eyes is _______.

a)

Visual Perception

b)

Prejudice

c)

Feelings

d)

Communication

5.

The various methods of communication includes:

a)

non-verbal, verbal and visual

b)

non-verbal, verbal

c)

verbal and visual

d)

all of the above

6.

The main four elements of communication are:

a)

Message, sender, receiver and feedback

b)

Sender, message and receiver

c)

Message, feedback, verbal and nonverbal

d)

Books, television, computers and radio

7.

An example of verbal communication is:

a)

Phone conversation

b)

Posture

c)

Eye contact

d)

Writing an email

8.

An example of non-verbal communication is:

a)

Sleeping

b)

Face-to-face conversation

c)

Telephone conversation

d)

Eye Contact

9.

We communicate by:

a)

Speech (Telephone call, conversations, etc)

b)

Visuals (Body language, facial expressions)

c)

Writing (Letter, emails, newsletters, etc)

d)

All of the above

10.

Includes gestures, facial expressions, and body positions

a)

Feedback

b)

Verbal Communication

c)

Non-Verbal Communication

d)

Dance

11.

The use of sounds and words to express yourself

a)

Non-Verbal Communication

b)

Verbal Communication

c)

Customer Service

d)

Interpretive Dance

12.

Communication is always a ___ way process.

a)

one

b)

two

c)

three

d)

four

13.

What is self management?

a)

Letting your emotions take control of you

b)

Controlling your thoughts, behavior, and emotions.

c)

Not having choices

d)

Postponing Things

14.

What does time management mean ?

a)

To use time effectively and appropriately.

b)

To use non-verbal communication.

c)

To express ideas clearly.

d)

To complete tasks in an appropriate manner.

15.

I am aware of what I like and dislike as well as my strengths and challenges. What is this called ?

a)

Self-Awareness

b)

Self-Regulation

c)

Social Motivation

d)

Social Management

16.

__________ allows you to gather data from different worksheets into a master worksheet.

a)

Goal Seek

b)

Solver

c)

Data Consolidation

d)

Total Data

17.

Consolidate option is available under __________ menu.

a)

Tool

b)

Insert

c)

Data

d)

View

18.

We can consolidate data by ___________

a)

Row Label

b)

Column Label

c)

Both Row and Column Label

d)

None of them

19.

Which of the following functions are available in consolidate window?

a)

Max

b)

Sum

c)

Count

d)

All of the above

20.

If you select ________ then any values modified in the source range are automatically updated in the target range.

a)

Link to source data

b)

Link to sheet data

c)

Link to original data

d)

Link to source range

21.

Data can be consolidated from two sheets only (True / False).

a)

True

b)

False

22.

Which option is used to name a range of cells?

a)

Range name

b)

Cell Range

c)

Define Range

d)

Select Range

23.

Define range option is available under _________ menu.

a)

Insert

b)

View

c)

Data

d)

File

24.

SUBTOTALS ________ data arranged in an array (a group of cells)

a)

ADD

b)

CLEAR

c)

MIN

d)

AVERAGE

25.

SUBTOTAL is available in ________ menu.

a)

Tools

b)

Format

c)

Insert

d)

Data

26.

In SUBTOTALS we can select up to ________ groups of arrays.

a)

3

b)

6

c)

2

d)

4

27.

Identify the correct sequence

a)

First open subtotal window and then select the data

b)

First select the data and then open subtotal window

c)

Both are incorrect

d)

Both are correct

28.

Scenarios are tool to test ______ questions.

a)

if else

b)

what if

c)

what else

d)

do while

29.

Each SCENARIO has a name to identify (True / False)

a)

True

b)

False

30.

SCENARIO option is available in ________ menu.

a)

Data

b)

Tools

c)

Insert

d)

Windows

31.

We can shift from one SCENARIO to another by _________

a)

Navigator

b)

Find and Replace

c)

Data Source

d)

None of the above

32.

We can create a maximum of 3 scenario for a given example (True / False)

a)

False

b)

True

33.

__________________ communication means communicating without the use of words, oral or written.

a)

Verbal

b)

Non-Verbal

c)

Written

d)

Oral

34.

__________________ is an idea or opinion that is not based on fact, logic or experience.

a)

Prejudice

b)

Communication

c)

Perspective

d)

Attitude

35.

________________ is the mindset that decides how an individual perceives an idea or a situation and responds to it.

a)

Behavior

b)

Attitude

c)

Perception

d)

None of these

36.

What is the best form of backup?

a)

regular backup to reliable medium

b)

cloud storage

c)

USB storage

d)

c:/backup

37.

Hardware examples are?

a)

mouse, keyboard, speakers, office 365

b)

RAM, ROM, USB, DVD

c)

mouse, screen, keyboard, skype

d)

facebook, screen, mouse, touchpad

38.
What is Google Drive?
a)
A free service from Google that allows you to store files online and access them anywhere using the cloud. 
b)
The street that Google's main headquarters building is located on.
c)
A special program for controlling an automobile.
d)
A very expensive golf club.
39.

Computers and related devices, such as keyboards, monitors and speakers

a)

Hardware

b)

Software

c)

Google chrome

d)

Microsoft Word

40.

The use of systems for storing, retrieving and sending information

a)

Hardware

b)

Software

c)

Multimedia

d)

Information Technology

41.

What are some of the jobs for people working in this pathway?

a)

they fix computers

b)

they help users with applications

c)

they make sure computers are running

d)

All of these

42.

Other skills needed to work in these careers are:

a)

Good communication

b)

Collaboration

c)

Both

d)

None of these

43.

Working with computer errors/problems could be very challenging. What do these professionals need to do this job?

a)

Passion

b)

Patience

c)

Be a long life learner

d)

All of these

44.

A CPU does not consist of _______________

a)

ALU

b)

HDD

c)

CU

d)

MU

45.

Which of these is not a peripheral device?

a)

Register

b)

Printer

c)

Bluetooth

d)

Printer

46.

In an email message, CC stands for _______________

a)

Carbon Copy

b)

Cannot Copy

c)

Can Copy

d)

Contains Copy

47.

Which device scans images, documents and saves them on a computer as a digital images?

a)

MICR

b)

Joystick

c)

Scanner

d)

Plotter

48.

__________________is free video sharing website, where videos on all subjects and topics can be found.

a)

Twitter

b)

Facebook

c)

Youtube

d)

Whatsapp

49.

Data is stored temporarily in ___________.

a)

ROM

b)

Hard Disk

c)

DVD

d)

RAM

50.

______________ skill is needed to speak and write properly.

a)

Communication

b)

Writing

c)

ICT

d)

Management

51.

An effective speaker is the one who is __________

a)

a. speaking appropriately whilst maintaining eye contact with the audience.

b)

using varied vocabulary.

c)

using varied articulate speech to suit the need of the audience.

d)

All of the above

52.

Computer takes data as _____________, processes it and produces the results as ________.

a)

Output, Input

b)

Input, Output

c)

Both of the above

d)

None of the above

53.

Raw facts and figures is called ____________________

a)

Information

b)

Processed Data

c)

Data

d)

None of these

54.

Which of the following are benefits of IT in business?

a)

IT helps in reaching more potential customers

b)

IT provides better service to customers

c)

Both of the above

d)

None of the above

55.

ITeS is also called __________________that cover the entire operations which exploit Information Technology for improving the efficiency of an organisation.

a)

web-enabled services

b)

remote services

c)

both of the above

d)

none of the above

56.

BPO Service Industry is doing exceptionally well in India because ______________________________

a)

BPO service providers in India invest in hi-tech hardware and software.

b)

Government of India is encouraging the BPO Industry in India

c)

Both of the above

d)

None of the above

57.

2. For an interview, you should not:

a)

A. shake hands

b)

B. make eye contact

c)

C. wear ripped jeans and t-shirt

58.

1. An impression is:

a)

A. a feeling about someone

b)

B. what is said when first meeting someone

c)

C. being excited or happy

59.

8. Which behavior below is good in the workplace?

a)

A. talking to friends on the phone during work hours

b)

B. returning late from lunch

c)

C. arriving to work on time

60.

9. Which one is not a good communication skill?

a)

A. respect others

b)

B. make eye contact

c)

C. interrupt the other person

61.

17. If an internet address has the suffix ".edu" what kind of institution does it refer too?

a)

A. a foreign country

b)

B. a university or college

c)

C. a commercial business

62.

18. When you post comments and pictures on the internet, you create a digital legacy that can last for:

a)

A. four months

b)

B. four years

c)

C. forever

63.
Joy is looking into many different career choices. She is leaning toward the Information Technology cluster. Why would this be a better career choice than some of the other options she was looking into?
a)
IT jobs are projected to increase fourteen percent between 2010 and 2020.
b)
IT jobs are projected to increase twenty-two percent between 2010 and 2020.
c)
IT jobs are projected to increase thirty-five percent between 2010 and 2020.
d)
IT jobs are projected to increase forty-seven percent between 2010 and 2020.
64.
Which best describes the similarities and differences between the Interactive Media pathway and Network Systems pathway?
a)
Both are designed to create webpages, while Interactive Media would focus mainly on communication methods in the webpage.
b)
Both are designed to help employees with computer problems, while Interactive Media would focus mainly on webinars and online communication.
c)
Both are designed to create new software, while Network Systems would focus mainly on designing databases.
d)
Both are designed to help protect computers from viruses, while Interactive Media would focus more on research and maintenance.
65.
Which career professional designs and creates large databases and makes the database work with other systems?
a)
Computer Network Architect
b)
Database Architect
c)
Database Administrator
d)
Computer Network Support Specialist
66.
A local company is expanding its range from one state to fifteen states. They will need an advanced method of online communication and someone to design an advanced and thorough database to store a lot of information. Who should they hire to assist with both these goals?
a)
a Database Architect and a Computer System Analyst who focuses in interactive media
b)
a Computer Hardware Engineer and a Software Developer who focuses in interactive media
c)
a Software Developer and a Web Developer who focuses in programming and software development
d)
a Web Administrator and a Computer System Analyst who focuses in information support and services
67.
Which person would be the best fit for a career in the Information Technology field?
a)
a social person with a logical mind
b)
a confident person with a quick mind
c)
a creative person with a flexible mind
d)
a strong person with a methodical mind
68.
A main reason careers in Information Technology are growing faster than average is
a)
the government has provided funding to boost educational programs.
b)
it has a large customer base of people, businesses, and organizations.
c)
large corporations have turned to computers to handle their business.
d)
the Internet has led to more people and businesses needing computer experts.
69.
Steve is good at setting up and managing groups of computers for large cities. In which Information Technology career pathway is he most likely to get a job?
a)
Information Support
b)
Programming Development
c)
Interactive Media
d)
Network Systems
70.
What is one difference between what a Computer Programmer and an Information Support Specialist does?
a)
A Computer Programmer oversees the design and maintenance of websites, while an Information Support Specialist designs computer codes for websites.
b)
A Computer Programmer designs computer codes for websites, while an Information Support Specialist oversees the design and maintenance of websites.
c)
A Computer Programmer oversees information technology projects, while an Information Support Specialist designs videos games and creates documentation for them.
d)
A Computer Programmer analyzes ways to create or improve computer systems, while an Information Support Specialist helps computer users with problems.
71.
An Information Technology worker who follows the Programming and Software development pathway most likely enjoys
a)
overseeing computer and information system projects.
b)
setting up and maintaining computer networks and databases.
c)
helping others with computer applications and operating system problems.
d)
writing code for computer applications and operating systems.
72.
A major software corporation has decided that its operating system is too difficult for the average user. Who should they hire to make the system easier to understand?
a)
Maureen, an applications software developer
b)
Timothy, a systems software developer
c)
Cody, a computer systems analyst
d)
Tammy, a computer programmer
73.
Juan is an Information Technology expert who writes software that controls electronic components in cars and hardware that provides faster ways to process information. Juan is most likely a
a)
Computer and Information Research Scientist.
b)
Computer and Network Research Scientist.
c)
Computer Hardware Engineer and Database Architect.
d)
Computer Network Architect and Support Specialist.
74.
At many information technology workplaces, Information Technology employees can work in areas that other employees are not allowed.This is because the area is the main access point for all computers on the network. What is this area referred to as?
a)
the cubicle
b)
the server
c)
the Internet
d)
the IT office
75.
Why would Network Systems employees be employed by the government?
a)
because they provide communication and data security
b)
because they are associated with a charitable organization
c)
because they create and sell software
d)
because they hire self-employed workers
76.
An employee was watching Jessica, an IT employee, typing in many different confusing terms. Jessica explained that she needed to fix the code and test a couple of programs before she could train the employee on how to use the software. Which IT career would be responsible for these tasks?
a)
Network Systems
b)
Programming and Software Development
c)
Information Support and Services
d)
Interactive Media
77.

Below is a list of tasks performed by four different employees. Which employee could work both in Interactive Media and in Programming and Software Development?

a)

Employee 1

b)

Employee 2

c)

Employee 3

d)

Employee 4

78.
A software development company wants to reorganize its office so that managers and the Computer Programmers they supervise can better collaborate. How should they rearrange the workplace?
a)
Remove the private offices and cubicles and replace them with large desks and conference tables out in the open.
b)
Remove the private offices and replace them with cubicles for the managers and large desks out in the open for workers.
c)
Remove the cubicles and conference tables out in the open and replace them with larger private offices for all employees.
d)
Remove the cubicles and conference tables and replace them with couches and comfortable chairs out in the open.
79.
Most Information Technology careers require workers to perform their jobs in
a)
a home office.
b)
a business office.
c)
a secure office.
d)
an off-site office.
80.
Amber is an Information Support Specialist for a large medical company with offices in three cities. Why would it be hard to find Amber at her desk during business hours?
a)
She spends most of her time in the server room making sure medical records are kept confidential.
b)
She spends most of her time at a home office where she is able to complete her job requirements.
c)
She spends most of her time traveling between the three offices to fix computers and answer questions.
d)
She spends most of her time giving presentations and training new employees on the office’s computer system.
81.
What kind of company would hire an Information Support and Service employee?
a)
software development
b)
computer repair
c)
website development
d)
network administration
82.
A Computer Programmer who wants to be surrounded by a large number of like-minded coworkers should take a job with one of the nation’s largest
a)
retail sellers of computers and related accessories.
b)
in-store computer repair and service companies.
c)
developers of computer operating systems.
d)
makers of computer networking equipment.
83.
Which entity might hire a Computer Systems Analyst to help it catch criminals?
a)
a law enforcement agency controlled by the government
b)
a private investigator who used to work for the government
c)
a credit card company that does business with the government
d)
a financial management firm with ties to the government
84.
Read the job description: A top-notch IT company is seeking an experienced leader to direct a team of experts in the development, creation, and modification of general computer applications software. This person must also train and advise customers on how to use software. Based on these tasks, a worker in which Information Technology pathway should consider applying for this job?
a)
Program and Software Development
b)
Information Support and Services
c)
Network Systems
d)
Interactive Media
85.
A regional trucking company landed a contract to supply products for a major retailer. To do this, it needs to hire an IT professional to create a shipment database. The new hire should be able to complete which tasks? Check all that apply.
a)
set up the computer hardware for the database
b)
set up the computer software for the database
c)
train designated employees to use the database
d)
design a help page to show people how to use the database
e)
protect the confidentiality of the database
86.
Smith wants to get a job in network systems. Which major should he choose to give him the best chance of getting a job?
a)
computer engineering
b)
communications
c)
liberal arts
d)
business management
87.
Which career professionals typically have some college experience but no degree?
a)
IT Project Managers, Computer Hardware Engineers, and Computer and Information Research Scientists
b)
Web Administrators, Computer Operators, and Video Game Designers
c)
Information Systems Managers, Software Developers, and Web Administrators
d)
Computer Programmers, Network Systems Workers, and Computer and Information Research Scientists
88.
Which job qualifications are typical for someone who wants to work in Information Support and Services?
a)
math skills, communication skills, time management skills
b)
integrity, research skills, attention to detail for maintaining databases
c)
ability to write error-free codes, ability to design new features, independence
d)
flexibility, problem-solving skills, and accuracy for maintaining databases
89.

The table is an excerpt from an interviewer’s notes about three applicants applying to the IT department. Which best describes the role the applicants can fill in the company?

a)

Applicants 1 and 3 are best suited to work in network systems, while Applicant 2 could work in programming, information support, or interactive media.

b)

Applicants 2 and 3 are best suited to work in network systems, while Applicant 1 could work in programming, information support, or interactive media.

c)

Applicant 1 is best suited to work in network systems, while Applicants 2 and 3 could work in programming, information support, or interactive media.

d)

Applicant 3 is best suited to work in network systems, while Applicants 2 and 3 could work in programming, information support, or interactive media.

90.
A company that designs video games has decided to expand and needs to hire Software Developers, Web Administrators, and Computer Programmers. Where would this company most likely recruit?
a)
a university’s computer science department
b)
a career fair sponsored by the government
c)
a technical school that specializes in computer training
d)
a community college’s computer engineering program
91.
William’s dad taught him how to write computer codes from a young age. Now, the high school senior wants to work as a programmer. How can he best position himself to do this?
a)
William should go to work as an intern for his father’s software company to get experience before enrolling in a community college.
b)
William should go to an educational seminar sponsored by a private software company to get experience before enrolling in a career college.
c)
William should enroll at a four-year university as a computer science major and go to work as an intern for a software company.
d)
William should enroll at a technical school that specializes in computer programming and go to work as an intern for a software company.
92.
A company has two finalists in mind to run its computer network: Bill, a college graduate in computer science with little experience, and Sam, a computer science student with a decade of on-the-job training. Why might the company hire Sam?
a)
He has a positive attitude.
b)
He has a lot of experience.
c)
He is willing to be trained.
d)
He might work for less money.
93.
Which position most likely requires a master’s degree for success?
a)
Computer Programmer
b)
Website Designer
c)
IT Project Manager
d)
Computer Scientist
94.
A large computer software firm promised a client that it could deliver a new operating system on a tight deadline and put Keith in charge of the project. Which best explains why Keith qualifies for such a position?
a)
He has a deep understanding of operating systems, is creative, works well with others, and can break down large projects into small pieces.
b)
He is a good communicator and motivator, can keep a secret when dealing with confidential material, and can quickly learn about operating systems.
c)
He has a deep understanding of network systems, is a problem solver who can make decisions on his own, and stays focused when working alone.
d)
He has a deep understanding of website design, can quickly identify and fix errors, and can break down large projects into small pieces.
95.
Zachary finished an internship as a Software Quality Assurance Engineer. For which job is he best qualified?
a)
A large computer firm needs someone to answer customers’ questions about its products.
b)
A software development firm needs someone to find and fix bugs on multiple computer platforms.
c)
A website development firm needs someone to find and fix coding errors in its work.
d)
A network systems firm needs someone to create and maintain multiple databases.
96.
Which qualities does an Interactive Media worker need when creating video conference or other multimedia projects for customers?
a)
ability to keep secrets and information private
b)
leadership and motivational skills
c)
creativity for developing ideas and designs
d)
knowledge of how to set up databases
97.
Which traits are common in all four career pathways of the Information Technology field? Check all that apply.
a)
accuracy and attention to detail
b)
problem-solving and critical-thinking skills
c)
knowledge of programming language
d)
ability to work independently
e)
ability to learn quickly
98.

Physical exercise in the form of ____________ relieves stress. (1 Mark)

a)

Walking

b)

Dreaming

c)

Sleeping

d)

None of these

99.

is not an instant messaging service. (1 Mark)

a)

Skype

b)

Yahoo! Messenger

c)

Firefox

d)

WhatsApp

100.

Amar wants to insert his School logo at the top of every page in his long document. Which option will you suggest to him to fulfill his task? (1 Mark)

a)

Footer

b)

Margin

c)

Header

d)

Headings