wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

АКТ РК-2

Total questions: 85

Worksheet time: 43mins

Name
Class
Date
1.

Program designed for working with spreadsheets:

a)

Excel.

b)

Word.

c)

Access.

d)

PowerPoint

e)

Paint.

2.

A program designed to work with databases:

a)

Access.

b)

Excel.

c)

Word.

d)

Power Point.

e)

Paint.

3.

The MS Excel program is:

a)

Spreadsheet.

b)

Text editor.

c)

DBMS.

d)

Graphic editor.

e)

Operating system.

4.

The Access program is:

a)

DBMS.

b)

Spreadsheet.

c)

Text editor.

d)

Graphic editor

e)

Operating system.

5.

The objects of the spreadsheet are:

a)

Columns

b)

Formula

c)

Document

d)

diagram

e)

text

6.

the most dangerous viruses

a)

trojan Virus.

b)

Polymorphic Virus.

c)

File Infector Virus.

d)

Macro Virus

e)

Web Scripting Virus

7.

Main objects of database:

a)

Tables

b)

Graphs

c)

Slides

d)

Drawings

e)

prezi

8.

Types of cloud computing

a)

private clouds, public clouds, hybrid clouds, and multiclouds.

b)

private clouds, public clouds, network, model

c)

private clouds, public clouds, star, bus

d)

private clouds, public clouds, CAN, WAN

e)

private clouds, public clouds, hybrid clouds, tree

9.

The type of address $A$5:

a)

absolute

b)

the relative

c)

index

d)

mixed

e)

combined

10.

The type of address $A5:

a)

mixed

b)

the relative

c)

index

d)

combined

e)

tree-like

11.

The type of address A$8:

a)

mixed

b)

the relative

c)

index

d)

combined

e)

tree-like

12.

The type of address A5:

a)

the relative

b)

index

c)

mixed

d)

combined

e)

tree-like

13.

The formula always starts with a sign in MS Excel:

a)

«=»

b)

«:»

c)

«_»

d)

«-»

e)

«/»

14.

Graphical representation of numerical data is:

a)

diagram

b)

table

c)

row

d)

column

e)

form

15.

The < > sign means:

a)

is not equal to

b)

greater than

c)

equally

d)

less

e)

greater than or equal to

16.

When you copy the formula, the address is changed:

a)

the relative

b)

index

c)

mixed

d)

combined

e)

tree-like

17.

When you copy the formula, the address is partially changed:

a)

mixed

b)

the relative

c)

index

d)

combined

e)

tree-like

18.

When you copy the formula, the address does not change:

a)

absolute

b)

the relative

c)

index

d)

mixed

e)

combined

19.

Fail of MS Excel is named:

a)

book

b)

worksheet

c)

table

d)

page

e)

folder

20.

The absolute addressing of cells uses the symbol:

a)

$

b)

!

c)

#

d)

e)

21.

The columns of the worksheet in the Excel program are denoted by:

a)

AB

b)

12A

c)

FAS

d)

21

e)

A12

22.

Number of cells in the range A2:B4:

a)

6

b)

10

c)

8

d)

4

e)

2

23.

Number of cells in the range B10:C14:

a)

8

b)

10

c)

6

d)

4

e)

2

24.

The text is aligned to EXCEL by default:

a)

on the left

b)

centered

c)

on the right

d)

in width

e)

along the length

25.

The numbers are aligned in the EXCEL by default:

a)

on the right

b)

centered

c)

on the left

d)

in width

e)

along the length

26.

A database is:

a)

A systematized collection of data

b)

Drawing

c)

Graph

d)

Slide

e)

Text document

27.

The relation (∞ - 1) corresponds to the relation:

a)

many to one

b)

one to one

c)

one to many

d)

many to many

e)

all answers are correct

28.

MS Access has relationships:

a)

one to one

b)

two to two

c)

all answers are correct

d)

one to three

e)

2 to 2

29.

MS Access. The number of relationship between tables in the Access MS:

a)

3

b)

1

c)

2

d)

8

e)

5

30.

Models of databases are:

a)

Hierarchical

b)

Documentary

c)

Index

d)

Matrix

e)

Factographic

31.

The database, where the data is the objects, is called:

a)

Object-oriented

b)

Hierarchical

c)

Relational

d)

Matrix

e)

Index

32.

Hybrid database is a combination of:

a)

the relational and object-oriented databases

b)

the relational and hierarchical databases

c)

hierarchical and object-oriented databases

d)

Index and object-oriented databases

e)

Index and the relational databases

33.

Table of database consists of:

a)

fields

b)

tabs

c)

tools

d)

buttons

e)

graphs

34.

The name of database field is:

a)

The column header of the table

b)

Command

c)

The record header of the table

d)

Type date

e)

Number of record

35.

A database object used for printing data is:

a)

Report

b)

Macros

c)

Modules

d)

Form

e)

Request

36.

An object that allows you to obtain the necessary data by any criterion:

a)

Request

b)

Macros

c)

Report

d)

Modules

e)

Form

37.

A blank designed for entering data with the name of database field is:

a)

Form

b)

Table

c)

Modules

d)

Macros

e)

Report

38.

Router is

a)

a device that knows the address of each segment , determines the best route and filters the broadcast messages.

b)

a device integrating the information networks using different protocols.

c)

a device that enhances the electric signal.

d)

a device to connect segments or networks.

e)

conventionally called the initiator of the connection session.

39.

In the design mode you can enter, change:

a)

criterion

b)

the field names

c)

query criterion

d)

report

e)

macros

40.

FTP protocol

a)

file transfer protocol;

b)

domain name system;

c)

virtual terminal;

d)

Simple Mail Transfer Protocol.

e)

all correct

41.

find the domain

a)

.com

b)

http

c)

https

d)

ftp

e)

mailtoo

42.

192.168.0.1. IP address, what does it means the number 192?

a)

country

b)

city

c)

district

d)

region

e)

computer number

43.

192.158.1.38. IP address, what does it means the number 158?

a)

city

b)

country

c)

region

d)

number PC

e)

district

44.

The record number is shown in the:

a)

navigator

b)

record

c)

column

d)

scrool bars

e)

field

45.

The computer uses:

a)

binary system

b)

decimal system

c)

roman numeral system

d)

greek system

e)

hex system

46.

A Binary system is made up of only:

a)

0

b)

0-9

c)

0-7

d)

A, B, C, D, E,F

e)

G, H, I, K, L, M

47.

An octal system is made up of only:

a)

0-7

b)

0

c)

0-9

d)

1

e)

A, B, C, D, E,F

48.

A hexadecimal system is made up of only:

a)

0

b)

0-9

c)

1

d)

0-7

e)

A, B, C, D

49.

Computers are directly connected to a single cable in the topology:

a)

Bus topology

b)

Mesh topology

c)

Star topology

d)

Tree topology

e)

Hybrid

50.

types of cloud computing services:

a)

IaaS, PaaS, SaaS.

b)

Bus, star, tree

c)

Star, IaaS, PaaS

d)

Tree, SaaS, Paas

e)

Hybrid, SaaS, bus

51.

Computers are connected to a single hub through a cable in the topology:

a)

Star topology

b)

Mesh topology

c)

Bus topology

d)

Tree topology

e)

Hybrid

52.

Advantages of Mesh Topology:

a)

It is robust

b)

Every node has its own connection to the hub

c)

It transmits data only in one direction

d)

Every device is connected to a single cable

e)

Cabling cost is more

53.

Multimedia is

a)

the use of a computer to present and combine text, graphics, audio, and video with links and tools that let the user navigate, interact, create, and communicate

b)

a global network of billions of computers and other electronic devices.

c)

is a technology which uses big data analysis, machine learning

d)

an acronym for 5 elements of a goal: specific, measurable, achievable, relevant, and time-based.

e)

an acronym that stands for Specific, Measurable

54.

The absolute addressing of cells uses the symbol:

a)

$

b)

c)

d)

( )

e)

>

55.

It is :

a)

Ring topology

b)

Hybrid topology

c)

Bus topology

d)

A circle topology

e)

Mesh topology

56.

It is :

a)

Star topology

b)

Moon topology

c)

Bus topology

d)

A circle topology

e)

Mesh topology

57.

It is :

a)

Mesh topology

b)

Moon topology

c)

Bus topology

d)

A circle topology

e)

TREE topology

58.

It is :

a)

Bus topology

b)

Moon topology

c)

Hybrid topology

d)

Mesh topology

e)

TREE topology

59.

Network topology are:

a)

Bus

b)

Moon

c)

A circle

d)

Line

e)

Bush

60.

Define result of the following formula in Excel: =СУММ(A1:A5)

a)

= A1+A2+A3+A4+A5

b)

0

c)

0,2

d)

A1/A5

e)

Adds values of A1 and A5

61.

Computers are connected to a root node forming a hierarchy:

a)

Tree

b)

Moon

c)

Bus

d)

A circle

e)

Ring

62.

Software for create video:

a)

Adobe Premiere Pro

b)

Fine Reader

c)

Fox Pro

d)

MS Excel

e)

MS Word

63.

FTP is used for:

a)

for transferring files from one computer to another

b)

to view information on the World Wide Web

c)

to transfer e-mail from one node to another

d)

for data transfer between Internet nodes.

e)

For conducting teleconferences on the Internet

64.

A multimedia program is a program that uses:

a)

sound

b)

function

c)

formula

d)

C++

e)

Python

65.

Types of clouds:

a)

public

b)

common

c)

toral

d)

combine

e)

tables

66.

Address of cell consists of:

a)

name of column and name of raw

b)

name of column

c)

name of raw

d)

name of raw and name of column

e)

name of worksheet

67.

In the cloud you can create:

a)

document

b)

formula

c)

video

d)

music

e)

videofilms

68.

A computer network can be divided into the following types, based on the geographical area that they cover, they are:

a)

MAN, CAN,WAN, LAN,GAN

b)

STAR, Bus, Ring

c)

Mesh, Tree, CAN

d)

CAN,WAN, RING

e)

MAN, CAN, STAR

69.

Correct e-mail address:

a)

aika@mail.ru

b)

Aika.mail.ru

c)

Gulnaz_@98mail.com

d)

www.gulnaz_98.kz

e)

Gulnaz_98@gmail@com

70.

The cloud provides the following levels:

a)

infrastructure

b)

window

c)

hardware

d)

interface

e)

translator

71.

By the nature of ownership, cloud structures are divided into the types:

a)

private

b)

graphical

c)

numerical

d)

close

e)

tree

72.

Primitive interface is:

a)

interface between user and computer

b)

interface between user and Internet

c)

interface between user and devices

d)

interface between computer and Internet

e)

interface between computers

73.

The networks are:

a)

two or more computer systems or electronics devices that are connected together

b)

electronics devices

c)

several computers

d)

the protocol

e)

the e-mail address

74.

Classification of computer networks by territory occupied:

a)

local

b)

corporate

c)

custom

d)

parent

e)

specialized

75.

For transferring in a network of web-pages the protocol is used:

a)

http

b)

doc

c)

ftp

d)

dns

e)

xls

76.

Browsers are:

a)

web viewer

b)

Internet servers

c)

antivirus software

d)

programming language translators

e)

text editor

77.

The basic protocol on the Internet is:

a)

TCP/IP

b)

HTTP

c)

HTML

d)

TCP

e)

WWW

78.

Types of IP addresses

a)

static and dynamic.

b)

CAN and MAN

c)

MAN and LAN

d)

WAN and LAN

e)

CAN and WAN

79.

Search engines are:

a)

yandex.ru

b)

kaz.net

c)

mail.ru

d)

list.ru

e)

buketov.edu

80.

Search engines are:

a)

altavista.com

b)

kaz.net

c)

mail.ru

d)

list.ru

e)

buketov.edu

81.

There are browsers:

a)

Internet Explorer

b)

FTP

c)

Djv

d)

Mail

e)

Internet service

82.

choose correct E-mail address

a)

diana@mail.ru

b)

Diana@ru.mail

c)

@Usernamediana

d)

diana@Internetservice

e)

Iinternet service@diana

83.

The Internet is:

a)

a global computer network

b)

a local computer network

c)

a regional computer network

d)

Campus computer network

e)

Corporate computer network

84.

Internet service are:

a)

World Wide Web

b)

HTML

c)

TC

d)

IP

e)

TCP

85.

The tag of HTML <a>:

a)

for the link

b)

for titles

c)

for paragraph

d)

to style part of text

e)

for images in document