wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

IT Mid Term Examination

Total questions: 70

Worksheet time: 35mins

Name
Class
Date
1.

Which of the following enables a computer to temporarily store data and instructions?

a)

Memory

b)

Input device

c)

Hardware

d)

Peripheral devices

2.
Which of these is a an ADVANTAGE of a PAN?
a)
As the devices are in a small area they cannot be hacked 
b)
Data is automatically synchronised between devices
c)
The range is very short which removes any interference from other devices
d)
Removes the need for Local Area Networks completely
3.
Which of these is most likely to use a WAN?
a)
School
b)
University
c)
Multi-National Company
d)
Local Company
4.
Which of these is a use of a VPN
a)
Used by employees access to their work network from outside of the office
b)
Home use for personal security when browsing the internet
c)
Encrypting data when transmitting it
d)
All of the above
5.
WANs connect to multiple LANs
a)
True
b)
False
6.
VPN is a lot cheaper than a WAN
a)
True 
b)
False
7.
Which of these is an example of a device which would be used in a PAN?
a)
Mobile Device
b)
Keyboard
c)
Monitor
d)
Mouse
8.

Which of these are a wireless connection?

a)

Bluetooth

b)

Ethernet

c)

DSL

d)

VPN

9.

What does a computer network allow computers to share?

a)

Electricity

b)

Nothing

c)

Mice

d)

Printers and Resources

10.
One of my workstations has gone down and my entire network has gone down. Which topology am I using?
a)
Ring
b)
Star
c)
Bus
11.
Every device in my network is connected via a switch. Which topology am I using?
a)
Ring
b)
Star
c)
Bus
12.
What type of network is this?
a)
Star
b)
Bus
c)
LAN
d)
WAN
13.
What type of network is this?
a)
Star
b)
Bus
c)
LAN
d)
WAN
14.
Why use a network?
a)
Share viruses
b)
To lose data
c)
To easily share documents
d)
To install cables
15.

A computer network is ___ connected together.

a)

One computer

b)

Two or more computers

c)

Three or more computers

d)

Four or more computers

16.

Which of these is a Ring Network?

a)
b)
c)
d)
17.

What is this button?

a)

Save

b)

Undo

c)

Return

d)

Print

18.
a)
Font name
b)
Font size
c)
Font color
d)
Save
19.
A horizontal line that is placed beneath characters.
a)
Bold
b)
Italics
c)
Underline
d)
Subscript
20.

Which tab would I go under to set the margins?

a)

Layout

b)

Design

c)

Insert

d)

Home

21.

Which would you click on to add a border?

a)

A

b)

B

c)

C

d)

D

22.

Which would you select to center a selection?

a)

A

b)

B

c)

C

d)

D

23.

The Tab used to Create/Insert a Table into Word.

a)

Insert Tab

b)

Design Tab

c)

Layout Tab

24.

Allows you to sort text from Z to A or largest to smallest

a)

Split Sort

b)

Ascending Sort

c)

Descending Sort

d)

Merge Sort

25.

The feature that combines or joins cells together in a table.

a)

Split Cells

b)

Merge Cells

c)

Distribute Rows

d)

Distribute Columns

26.

Ribbon is

a)

Contains related groups of different tools and commands.

b)

Allows you to choose a command from a list

c)

An interactive tool that activates its feature when clicked.

d)

Groups of related tools organized within a set of tabs

27.

Tabs

a)

are dividers.

b)

is the same as group box settings.

c)

Contains related groups of different tools and commands to perform the most common tasks.

d)

a machine that processes and stores information.

28.

Hardware is

a)

The physical equipment of a computer.

b)

Microsoft Office

c)

Microsoft Word

29.

Software is

a)

Monitor

b)

the programs or applications on a computer

c)

Mouse

d)

Keyboard

30.

Central Processing Unit (CPU) is

a)

A chip that acts like the brain of the computer.

b)

a part of the keyboard.

c)

Located centrally

31.

Examples of inputs are

a)

Keyboard

b)

Scanner

c)

Mouse

d)

Monitor

32.

Examples of outputs are

a)

Microsoft Word

b)

Speakers

c)

Printer

d)

Monitor

33.
Mail Merge is the automatic addition of names and addresses from a data source to letters, lists, envelopes, etc. 
a)
True
b)
False
34.
There are _________steps to a mail merge? 
a)
Five
b)
Six
c)
Seven
d)
Four
35.
If you use an excel file for your data source you must make sure you _________ excel first. 
a)
Format
b)
Resave
c)
Close
d)
Share
36.
Do you save a mail merge?
a)
Yes
b)
No
37.
The first step to create a mail merge is to click on the _________ribbon. 
a)
Home
b)
Insert
c)
Design
d)
Mailings
38.
The merge document can also be referred to as the __ document.
a)
Main
b)
Data Source
c)
Field
d)
Record
39.
The ____ is the file that contains all the addresses that you want to merge with a letter.
a)
Main Document
b)
Data Source
c)
Field
d)
Merged Document
40.
After you have selected the recipients, you need to add ___ into your document so Word knows where to put the data.
a)
Merge Fields
b)
Records
c)
Characters
d)
Text
41.
When creating a mail merge, which of the following is not an option:
a)
Letters
b)
Envelopes
c)
Directory
d)
Flyer
42.
When creating a mail merge, you will end up with __ files.
a)
1
b)
2
c)
3
d)
4
43.
The individual pieces of information (such as Name or City)that you include in your data source are referred to as:
a)
Records
b)
Fields
c)
Data Source
d)
Row
44.

What is a data source

a)

A spreadsheet/database containing all information for the Mail Merge

b)

A spreadsheet that contains all the information for Prices of Candy Bars at Twix

c)

The internet

d)

A Word document containing a letter

45.

Why would you use a mail merge?

a)

To create multiple letters that are the exact same, but have different address and Names

b)

To create a label that can be used in a letter

c)

For guessing someones address online

d)

To add a name and address to a letter manually

46.
If the parenthesis is removed, what will 9.5% be multiplied by? 
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
47.
Which response best completes the following statement: A formula is used to 
a)
perform calculations or other actions.
b)
find averages.
48.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
49.
When calculating the tax per item the formula to use it
a)
= Total * sales tax%
b)
= Total +(Total * sales tax%)
50.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

51.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

52.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

53.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

54.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

55.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

56.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

57.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

58.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
59.

Which formula would you use to calculate how many sales are over $20 from a series.

a)

sum

b)

sumif

c)

count

d)

countif

60.

A ______ check compares the contents of two or more fields to make sure that they make sense..

a)

consistency

b)

range

c)

data type

d)

format

61.

Which of the following checks is used to detect doubtful data?

a)

length

b)

range

c)

data type

d)

reasonableness

62.

An area code must contain three digits only. The following checks are suitable EXCEPT:

a)

data type

b)

format

c)

length

d)

range

63.

The access method that calculates the exact address (location) of a record is most suitable for which type of file structure?

a)

serial

b)

sequential

c)

fully indexed

d)

direct access

64.

A fully indexed file contains the record key and the storage address of the:

a)

average key value

b)

exact key value

c)

highest key value

d)

lowest key value

65.
What program is needed to view web pages?
a)
Browser
b)
Interpreter
c)
Compiler
d)
Web Authoring Software
66.
A collection of web pages.
a)
server
b)
website
c)
www
d)
web links
67.
What does www stand for?
a)
width website web
b)
web world while
c)
web weld with
d)
world wide web
68.
ALWAYS consider and determine your intended ____________
a)
audience
b)
website
c)
layout
d)
anchor
69.
A good web site design has many moving images and animations with lots of different colors and fonts to keep the user interested.
a)
True
b)
False
70.
The process of defining, designing, creating, and producing web sites.
a)
HTML
b)
CSS
c)
Parsing
d)
Web Design

Similar Resources on Wayground

Latihan Soal Microsoft Word

68 questions

Latihan Soal Microsoft Word

quiz

Worksheet

•

KG - 12th Grade

ÔN TẬP TIN HỌC 7 HK2-2024

70 questions

ÔN TẬP TIN HỌC 7 HK2-2024

quiz

Worksheet

•

7th Grade

Ôn Tập Căn Bản Về Công Nghệ (Phần 1,2)

74 questions

Ôn Tập Căn Bản Về Công Nghệ (Phần 1,2)

quiz

Worksheet

•

6th - 8th Grade

DIAGNOSTICO DE MANTENIMIENTO DE COMPUTADORAS

65 questions

DIAGNOSTICO DE MANTENIMIENTO DE COMPUTADORAS

quiz

Worksheet

•

10th Grade

PTS Informatika 2 (analisa data, algoritma dan pemrograman)

65 questions

PTS Informatika 2 (analisa data, algoritma dan pemrograman)

quiz

Worksheet

•

9th - 12th Grade

Final Review Activity

70 questions

Final Review Activity

quiz

Worksheet

•

9th - 12th Grade

Всё об Excel

72 questions

Всё об Excel

quiz

Worksheet

•

1st - 12th Grade