Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Tests on subject 'Information and communication technologies'

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

Tests on subject 'Information and communication technologies' 1. ICT stands for:

a)

Information and Communication Technology

b)

International Communication Technology

c)

Intera Common Terminology

d)

Interconnected Terminals

e)

Internet Communication Technology

2.

Tests on subject 'Information and communication technologies' 2. Key for deleting the symbol to the left of the cursor:

a)

Backspace

b)

Shift

c)

CapsLock

d)

Delete

e)

Space bar

3.

What sign writes after formula in spreadsheet?

a)

after the sign =

b)

after the space

c)

after the number

d)

after the sign #

e)

after the sign ""

4.

What program works with databases?

a)

MS Access

b)

MS PowerPoint

c)

MS Word V

d)

MS Explorer

e)

MS Excel

5.

What programs are anti-virus:

a)

Kaspersky, Doctor Web

b)

MS Word, MS Excel, MS Access

c)

ARJ, ZIP, RAR

d)

MS PowerPoint

e)

Microsoft Internet Explorer, Netscape Navigator

6.

Tests on subject 'Information and communication technologies' 6. Program MS Excel is ...

a)

Spreadsheet

b)

Database

c)

Text editor

7.

What maximum number has a name of file or folder in Windows?

a)

255

b)

10

c)

8

d)

23

e)

256

8.

E-mail is

a)

Electronic mail.

b)

Work with text.

c)

Database.

d)

A game.

e)

Testing tool.

9.

Translate the decimal system to hexadecimal: 555

a)

22B

b)

45B

c)

20B

d)

A4

e)

145

10.

What symbol replaces any number of any symbols?

a)

*

b)

?

c)

\

d)

?

e)

()

11.

How writes: "All files without exception"?

a)

*.*

b)

?.?

c)

*?

d)

?

e)

:

12.

Which expansion has Excel document?

a)

.xls

b)

.txt

c)

.jpg

d)

.pdf

13.

Which expansion has Word document?

a)

.doc

b)

.pcx

c)

.cdr

d)

.bmp

e)

.txt

14.

Which expansion has PowerPoint document?

a)

.ppt

b)

.pcx

c)

.cdr

d)

.bmp

e)

.txt

15.

Add numbers 101 + 101 in the binary system

a)

1010

b)

1110

c)

1111

d)

1001

e)

2100

16.

Calculate 1011 - 111 in the binary system

a)

100

b)

110

c)

98

d)

101

e)

210

17.

Translate number from decimal system to octal: 658

a)

1222

b)

157

c)

799

d)

1333

e)

1204

18.

Storage Device

a)

HDD

b)

Power Supply

c)

Mouse

d)

Monitor

e)

Keyboard

19.

What does it mean = SUM (A2: A5) in MS Excel?

a)

The summation contents of cells A2, A3, A4, A5.

b)

Select cells from A2 to A5.

c)

Dividing the value of the cell A2 to A5 cell value.

d)

Summation A2 and A5 cell contents.

e)

Highlight cells A2 and A5 block

20.

Which of these programs is a graphical editor?

a)

CorelDraw

b)

WinZip

c)

Microsoft Word

d)

AVP, Kaspersky

e)

DoctorWeb

21.

Enter the correct form of the address Internet site:

a)

http://www.mail.ru

b)

http: //www.mail.ru

c)

http //www.mail-ru

d)

http / www.mail .-- ru

e)

http: //www.mail

22.

How calls document in Excel spreadsheet?

a)

Book

b)

DoctorWeb

c)

page

d)

presentations

e)

package

23.

The formula means = A2 + B5:

a)

Adds contents of cells B5 and A2

b)

Specify a range of cells B5 and A2

c)

Subtract the contents of cells B5 and A2

d)

Subtract the contents of cell A2 B5 cell content

e)

Highlights cells A2 and B5

24.

Selection E8:

a)

A column of row 1

b)

row in column 8

c)

column E row 4

d)

row 8

25.

The object that allows you to make a selection in MS Access:

a)

Inquiry

b)

Table

c)

The form

d)

Module

e)

Macro

26.

How can you copy active window as a graphic element?

a)

Alt + Print Screen

b)

Ctrl + C

c)

Ctrl + V

d)

Shift + F12

e)

Ctrl + X

27.

Formula. How writes summation of cells from D2 to D7 in MS Excel:

a)

= Sum (D2:D7)

b)

= Sum (D2 \ D7)

c)

= Sum (D2-D7)

d)

= Sum (D2, D3, D7)

e)

= Sum (D2, D7)

28.

The command for uncompress the file:

a)

Extract

b)

View

c)

New

d)

Open Save

e)

Add

29.

How calls the coordinates of a cell in Excel spreadsheet?

a)

Address

b)

Cell

c)

Letter

d)

Numeral

e)

Room

30.

What is used for connecting Computer to the LAN

a)

Servers

b)

Network adapter

c)

Network filters

d)

Topolgii network

e)

Cable

31.

Function "Minimum value" in Excel is:

a)

MIN

b)

ZNACHMIN

c)

MINE

d)

MINZNACH

e)

MAX

32.

Function "Maximum value" in Excel is:

a)

MAX

b)

MIN

c)

ZNACHMIN

d)

MINE

e)

MINZNACH

33.

Choose the correct answer of e-mail address:

a)

KasGMA@astana.kz

b)

KasGMA @. kz

c)

@ Astana.kz KasGMA

d)

KasGMA. astana. @.

e)

KasGMA. astana. kz

34.

Calculating by the formula in Excel "= B1 * C1-B2 / A2", if | A | B | C | | 1 | 3 | 5 | 2 | | 2 | 3 | 12 | 1 |

a)

6

b)

7

c)

13/4

d)

-7

e)

-13/4

35.

Result of sum 1+0=?

a)

1

b)

0

c)

10

d)

11

e)

0,1

36.

What domain is used in RK?

a)

kz

b)

uz

c)

su

d)

fr

e)

ru

37.

Calculate " "?

a)

21

b)

7

c)

13/4

d)

-7

e)

-13/4

38.

Result of =ОКРУГ(A2,1)?

a)

3.8

b)

3.7

c)

3.75

d)

3.76

e)

3.8

39.

Calculate numbers by this function =CP3HAΨ(A1:D2)

a)

-1

b)

-8

c)

1

d)

20

e)

8

40.

Calculate numbers by this function =ABS(A1)+ABS(B1)-A2*B2

a)

33

b)

-64

c)

4

d)

-4

e)

120

41.

Find the right expansion of sound file

a)

*.AVI, *.MID, *.WAV

b)

*AVI, *MID, *TXT

c)

*.BMP *AVI, *MID, *.DOC

d)

*AVI, *MID, *.WAV, *.BMP, *.DOC

e)

*AVI, *TXT, *.WWW, *.BMP, *.DOC

42.

Which device is required for the Internet connection?

a)

Modem

b)

Joystick

c)

CD Drive

d)

NIC Card

e)

Printers

43.

CPU contains:

a)

control unit and an arithmetic logic unit

b)

analytical engine and a control unit

c)

card reader anda printing device

d)

arithmetic logic unit and a card reader

e)

compact Disk Read Only Memory

44.

Which technology is used in a CDROM Drive?

(a)  

45.

The analytical Engine developed during First Generation of computers used....as a memory unit:

a)

Counter Wheels

b)

RAM

c)

Cards

d)

Floppies

e)

Driver

46.

WAN stands for:

a)

Wide Area Network

b)

Wap Area Network

c)

Wide Array Net

d)

Wireless Area Network

e)

Disk memory

47.

Second Generation computers were developed during:

a)

1956-1965

b)

1949-1955

c)

1965-1970

d)

1970-1990

e)

1986-1999

48.

A collection of related files is called a....

a)

database

b)

field

c)

character

d)

record

e)

network

49.

What menu is selected to print?

a)

File

b)

Special

c)

Edit

d)

Tools

e)

None of these

50.

The..........performs simple mathematics for the CPU.

a)

ALU

b)

DIMM

c)

BUS

d)

Register

e)

None of these

51.

What is e-commerce?

a)

Buying and selling products and services over the Internet

b)

Buying and selling computer products

c)

Buying and selling products and services not found in stores

d)

Buying and selling international goods

e)

Buying and selling computer software

52.

e-commerce

a)

typically refers to business transactions that are conducted electronically over a computer network.

b)

gets your electronic mailbox set up on an e-mail server.

c)

is an electronic document transmitted over a computer network.

d)

a computer that essentially acts as a central post office for a group of people.

e)

is created by the Web site that you are visiting.

53.

Whether you use local e-mail or Webmail, your e-mail account has a unique

a)

e-mail address

b)

Flash cookie

c)

first-party cookie

d)

e-mail server

e)

e-mail message

54.

HTML (Hypertext Markup Language) is a set of specifications for creating documents that a browser can display as a Web page.

a)

also called a local shared object, is the Flash equivalent of a conventional Web cookie.

b)

overlays the content on a Web page, sometimes obscuring it until you click the ad or its timer expires and the ad disappears.

c)

adds HTML tags to a document, spreadsheet, or other text-based file to create an HTML document that can be displayed by a browser.

d)

which is similar to a word processing file, but has an .htm or .html extension.

55.

HTTP

a)

is a protocol that works with TCP/IP to get Web resources to your desktop.

b)

uses the

tag to accept typed input.

c)

is a term used for e-mail messages containing HTML tags that produce bold, italicized, and underlined text; fancy fonts; embedded graphics; and various font sizes.

d)

that specify how the document should appear when displayed on a computer screen or printed.

e)

the current version was introduced in 2010.

56.

SMTP (Simple Mail Transfer Protocol) handles outgoing mail.

a)

is an abstract concept that represents one end of a connection.

b)

because it is the source of the HTML tags used to construct a Web page.

57.

A hardware device that is capable of executing a sequence of instructions, is known as

a)

Hard disk

b)

ALU

c)

Processor

d)

Cache memory

e)

CU

58.

The operating system of a computer serves as a software interface between the user and

a)

Hardware

b)

Peripheral

c)

Memory

d)

Screen

e)

Processor

59.

What is the Cloud Computing replacing?

a)

Corporate data centers

b)

Expensive personal computer hardware

c)

Expensive software upgrades

d)

All of the above

e)

Web browser

60.

What is a hybrid cloud?

a)

A blend of public and private cloud services with orchestration between them

b)

A cloud service deployed across multiple offices or locations

c)

A blend of private cloud and legacy on-premises hardware

d)

None of the above

e)

WS_FTP, CuteFTP

61.

What is the public cloud?

a)

A cloud formation that can be seen across the globe

b)

A cloud service that can only be accessed from a publicly shared computer

c)

A multi-tenant cloud environment accessed over the internet

d)

A cloud environment owned, operated and controlled by a public company

e)

None of the above

62.

The function of TCP in Internet communication is to:

a)

Ensure reliable data transmission between devices

b)

Assign IP addresses to devices

c)

Encrypt all Internet traffic

d)

Provide wireless connectivity

63.

VoIP works by transmitting voice over the internet and offers advantages such as cost savings and flexibility compared to traditional phone systems.

a)

VoIP transmits voice over the internet, offering cost savings and flexibility.

b)

VoIP uses satellite signals for voice transmission, making calls more expensive.

c)

VoIP relies on analog signals, resulting in higher maintenance costs.

d)

VoIP requires dedicated phone lines, limiting mobility.

64.

WAP (Wireless Application Protocol) is a communications protocol that provides Internet access from handheld devices, such as cell phones. What is the purpose of WAP and how does it enable mobile Internet access?

a)

WAP allows handheld devices to access the Internet by defining a standard protocol for wireless communication.

b)

WAP is used to increase the battery life of mobile devices.

c)

WAP is a hardware component required for mobile phones to function.

d)

WAP is a security protocol for encrypting mobile calls.

65.

Fill in the blank: A WiFi hotspot is an area in which the public can access a _______ network that offers Internet service.

a)

WiFi

b)

Bluetooth

c)

Ethernet

d)

Cellular

66.

Which of the following is a technology in which a broadband Internet connection is used to place telephone calls instead of the regular phone system?

a)

WiFi hotspot

b)

Voice over Internet Protocol (VoIP)

c)

Wireless Application Protocol (WAP)

d)

Trojan horse

67.

Fill in the blank: In computer lingo, 'Graphics' refers to any picture, drawing, sketch, photograph, image, or icon that appears on your _______.

a)

computer screen

b)

keyboard

c)

printer

d)

mouse pad

68.

Which of the following is NOT a cloud technology model listed in the worksheet?

a)

Private

b)

Public

c)

Community

d)

Spreadsheet

69.

Fill in the blank: Mathematical operators include the multiplication symbol (*), the division symbol (/), the addition symbol (+), and the _______ symbol.

a)

subtraction

b)

percentage

c)

exponent

d)

equals

70.

A Trojan horse is a computer program that seems to perform one function while actually doing something else.

a)

True

b)

False

71.

Web application (or Web app) is software that is accessed with a ________.

a)

Web browser

b)

Mobile phone

c)

Desktop application

d)

Command line interface

72.

Which type of system software is designed to help you monitor and configure settings for your digital gear, its operating system, or application software?

a)

Application software

b)

System software

c)

Web application

d)

Antivirus software

73.

A number that you want to use in a calculation is called a ________.

a)

value

b)

label

c)

cell

d)

range

74.

Virus signatures and other information that antivirus software uses to identify and eradicate malware are stored in one or more files usually referred to as a ________.

a)

virus database

b)

system log

c)

firewall rule

d)

user profile

75.

A new virus on the loose usually arrives as an ________ containing dire warnings.

a)

e-mail message

b)

phone call

c)

textbook

d)

handwritten letter

76.

The binary number system has only two digits: ________ and ________.

a)

0 and 1

b)

1 and 2

c)

2 and 3

d)

8 and 9

77.

Which of the following requires only seven bits for each character?

a)

Binary number system

b)

Extended ASCII

c)

ASCII

d)

Unicode

78.

Extended ASCII is a superset of ASCII that uses ________ bits to represent each character.

a)

eight

b)

six

c)

four

d)

ten

79.

The system unit is the case that holds the computer’s main circuit boards, microprocessor, memory, power supply, and ________.

a)

storage devices

b)

keyboard

c)

monitor

d)

mouse

80.

The sound system can output digital music, digitally recorded speech, and a variety of ________.

a)

sound effects

b)

musical notes

c)

radio waves

d)

visual images

81.

A computer printer is an ______ device that produces computer generated text or graphical images on paper.

a)

output

b)

input

c)

storage

d)

processing

82.

An optical drive is a ______ device that works with CDs, DVDs.

a)

storage

b)

input

c)

output

d)

processing

83.

A hard disk drive is the main ______ device on many computer systems.

a)

storage

b)

input

c)

output

d)

display

84.

A laptop computer is a small, lightweight portable computer that opens like a ______ to reveal a screen and keyboard.

a)

clamshell

b)

drawer

c)

bookcase

d)

envelope

85.

A smartphone is an enhanced mobile phone that also functions as a portable ______ player and has the capability to access the Internet.

a)

media

b)

game

c)

video

d)

radio

86.

A tablet computer

a)

is often placed under the monitor

b)

is a small, lightweight portable computer that opens like a clamshell to reveal a screen and keyboard

c)

is an enhanced mobile phone that also functions as a portable media player and has the capability to access the Internet.

d)

is integrated into the case that holds the screen.

87.

The PC platform

a)

is based on the original IBM PC.

b)

is based on a proprietary design for a personal computer called the Macintosh (or Mac), manufactured almost exclusively by Apple Inc.

c)

uses a standard PC or Mac to run operating system.

d)

processor powered the original IBM PC.

e)

is Intel’s chief rival in the PC chip market.

88.

Intel’s 8088

a)

is based on the original IBM PC

b)

is based on a proprietary design for a personal computer called the Macintosh (or Mac), manufactured almost exclusively by Apple Inc.

c)

uses a standard PC or Mac to run operating system.

d)

is Intel’s chief rival in the PC chip market.

89.

A storage medium

a)

is the mechanical apparatus that records and retrieves data from a storage medium

b)

refers to a storage device and the media it uses.

c)

stores data by magnetizing microscopic particles on a disk or tape surface

d)

is a technologies CD, DVD, and Bluray

90.

Music software

a)

provides a set of tools for creating video productions from raw footage

b)

is designed to help you create, manipulate, and print graphics

c)

offers many ways to work with music, sound effects, and narration from your desktop, laptop, or handheld computer.

91.

Video editing software provides a set of tools for creating video productions from ________.

a)

raw footage

b)

audio tracks

c)

finished movies

d)

storyboards

92.

Which software is designed to help you create, manipulate, and print graphics?

a)

Video editing software

b)

Graphics software

c)

CAD software

d)

Word processing software

93.

CAD software is a special type of 3-D graphics software designed for ________ and engineers who use computers to create blueprints and product specifications.

a)

architects

b)

doctors

c)

chefs

d)

musicians

94.

Word processing software has replaced ________ for producing many types of documents, including reports, letters, memos, papers, and book manuscripts.

a)

typewriters

b)

televisions

c)

calculators

d)

projectors

95.

Which software provides a set of tools for creating wireframes that represent three-dimensional objects?

a)

Video editing software

b)

Graphics software

c)

CAD software

d)

Word processing software

96.

Word processing software helps you enter, find, organize, update, and report information stored in a ________.

a)

database

b)

spreadsheet

c)

presentation

d)

browser

97.

Name one file extension that is used for text files.

a)

.txt

b)

.jpg

c)

.exe

d)

.mp3

98.

Name one file extension that is used for sound files.

a)

.mp3

b)

.txt

c)

.jpg

d)

.pdf

99.

Name one file extension that is used for graphics files.

a)

.jpg

b)

.txt

c)

.exe

d)

.mp3

100.

Name one file extension that is used for animation/video files.

a)

.mp4

b)

.docx

c)

.jpg

d)

.pdf