wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ИКТ

Total questions: 115

Worksheet time: 1hrs 26mins

Name
Class
Date
1.

Operation with the data which is used to arrangement

a)

sorting of data

b)

archiving of data

c)

organization of data

d)

transmission of data

e)

formalization of data

2.

MS Access. Functions of  commands in “Datasheet” tab

 

a)

Home" commands of МS Аccess

b)

are intended for working with tables

c)

provide supporting of created databases

d)

provide creating basic components of database

3.

MS Access. Connected fields have

a)

two files but different types of data

b)

one file but different type of data

c)

different names and different types of data

d)

different names but the same type of data

4.

MS Access. «Create» tab allows

a)

split the table, query and report

b)

perform auto format of the table

c)

create new table, form, report, query, macro and module

d)

create the page, form, template, report, query, slide and database

e)

create new table, template, resume, query, slide and new database

 

5.

MS Access. Change the table structure

a)

table wizard

b)

table wizard

c)

datasheet view

d)

create new table

6.

MS Access. A major database object used to display information in an attractive, easy-to-read screen format

a)

table

b)

form

c)

report

d)

query

e)

macros

7.

MS Access. For copying records it’s necessary to select records and perform following command

a)

home - font - copy

b)

create - reports - copy

c)

create - reports - copy

d)

home - clipboard - copy

e)

external data - clipboard - cut

8.

MS Access. The function of «AutoNumber» in «ID» field of database

a)

number the table

b)

sum of form numbers

c)

sum of report numbers

d)

auto input of sequential numbers

e)

number of form records in consecutive order

9.

There are in working area of MS Access:

a)

desktop, task area

b)

working area, task pane

c)

status bar, start button

d)

menu bar, toolbar

e)

database window and its objects windows

10.

Commands of "Database tools" tab

a)

forms, reports, analyze and others

b)

forms, reports, analyze and others

c)

macro, show/hide, analyze, move data

d)

rich text, clipboard, records, sort and filter, find

e)

tables, clipboard, font, show and hide, find, representation

11.

MS Access. Records are sorted in increasing order

a)

12, 144, 245, 53, 94

b)

$10, $25, $35, $50

c)

Lily, Rose, Carnation, Aster

d)

Folder, Directory, Container

e)

Folder, Directory, Container

12.

MS Access. Logical operator «not» is used to select

a)

coincident files

b)

coincident values

c)

coincident queries

d)

in coincident values

e)

coincident first symbols

13.

MS Access. Logical operator «not Т» is used for select

a)

words which contain letter «Т»

b)

words which end with letter «Т»

c)

words which begin from letter «Т»

d)

words which do not contain letter «Т»

e)

words which do not begin from letter «Т»

14.

MS Access. Logical operator «С asterics» is used for select

a)

words which contain letter «С»

b)

words which end with letter «С»

c)

words which begin from letter «С»

d)

words which do not contain letter «С»

e)

words which do not contain letter «С»

15.

MS Access. Logical operator «[B-C]» is used for select

a)

words which contain letter «D»

b)

words which begin from letter «В»

c)

words which don’t contain letter «В»

d)

words which end with letters «В», «С», «D»

e)

words which begin from letters «В», «С», «D»

16.

MS Access. Query is intended for

a)

storing the database

b)

creating relationships

c)

creating relationships

d)

present data in printing view

e)

output data and rename the document

17.

MS Access. Form is intended for

a)

printing the document

b)

extract data from tables

c)

present data in printing view

d)

output data and display on the screen

e)

input data and perform acts defined the entered data

18.

MS Access. The command of sorting text fields in descending order

a)

home – sort and filter – descending

b)

home – sort and filter – ascending

c)

datasheet view – font – sort on descending

d)

external data – sort and filter – ascending

e)

datasheet view – fields and columns – sort on ascending

19.

MS Access. Database field

a)

some area of database

b)

set of values relating to records

c)

set of values for one element of the object

d)

set of values which satisfy of a given criteria

e)

concept describing one chosen property of an object

20.

MS Access. Tables of database are intended for

a)

storing data

b)

printing data

c)

deleting of data

d)

manipulation of data

e)

output data on the screen

21.

MS Access. For deleting records it’s necessary to select records and perform

a)

create - font - delete

b)

home - records - delete

c)

home - collect data - insert

d)

home - clipboard - delete

e)

external data - records - delete

22.

MS Access. For searching data it’s necessary to perform command

a)

home - find - find

b)

create - find - find

c)

home - find - delete

d)

home - data collection - insert

e)

external data - records - find

23.

MS Access. The command of sorting text fields in ascending order

a)

home – sort and filter – descending

b)

home – sort and filter – ascending

c)

datasheet view – font – sort on descending

d)

external data – sort and filter – ascending

e)

datasheet view – fields and columns – sort on ascending

24.

MS Access. Query is intended for

a)

input data and delete the document

b)

rename the document and input data

c)

output data and rename the document

d)

filter data, perform calculations and summarize the data

e)

delete unnecessary data and display other data on the screen

25.

MS Access. Group "Forms" is located on tab

a)

home

b)

create

c)

external data

d)

datasheet mode

26.

MS Access. According to formation method queries are grouped

a)

currency, simple, linear

b)

text, with a parameter, an auto query, numeric

c)

linear, auto reports, auto forms, simple, dependent

d)

on a sample, with a parameter, crosstab, simple

e)

circle, the linear, numeric, an auto request, monetary, the report

27.

MS Access. The sequence of commands for formation of queries of the Create tab

a)

list – datasheet

b)

others – report design

c)

others – query design

d)

tables – query design

e)

views – query design

28.

MS Access. Logical operator

a)

dor

b)

eqv

c)

null

d)

true

e)

not

29.

Creating of database

a)

toolbar – create the database

b)

file – create – open the database

c)

edit – create – open the database

d)

"Office" button- create – new database

e)

create – "Office" button – create the database

30.

Database management systems

a)

Ms Excel, Supercalc, Turbopascal, Ms Access

b)

Clipper, Paradox, Foxpro, Foxbase, Ms Access

c)

Inereader, Prompt98, Qtrans, Foxbase, Excel, Paradox

d)

Ms Word, Wordperfect, Total Commander, Ms Access

e)

Ms Powerpoint, Ms Access, Outlook Express, Total Commander

31.

МS Access. Group "Fields&Columns" is located on​ ​​​​__tab​

a)

home

b)

create

c)

datasheet view

d)

external data

32.

MS Аccess. Short keys of "Minimize and maximize the ribbon"

a)

ShiftF6

b)

Alt Tab

c)

CtrlF1

d)

ShiftTab

e)

ShiftF10

33.

MS Access. Set of tools which is displayed when choosing «Home» tab

a)

clipboard, paragraph, text, views, font

b)

create, records, sort and filter, alignment, find, styles

c)

clipboard, tables, views, text, find, pages, editing

d)

views, clipboard, font, text, records, sort and filter, find

e)

font, pages, views, clipboard, styles, alignment, find, text

34.

МS Аccess. "Open" command of  "Оffice" button allows to

a)

save data in a table

b)

look at data in a table

c)

open the created table

d)

open the «editing» window

e)

open the created database

35.

Database which can be used in several spheres of human activity

a)

universal

b)

specialized

c)

public

d)

single purpose

e)

multipurpose

36.

How to type criteria «<80 or >50» in a query?

a)

<80, >50

b)

<80 or >50

c)

<80=>50

d)

less than 80 and greater than 50

e)

less than 80 or greater than 50

37.

Query design window has two parts. The upper part shows   

a)

criteria

b)

sorting check boxes

c)

name of fields, field type and size

d)

properties and format of the field

e)

tables with fields and relationships between tables

38.

To change the size of text field from 255 to 50 symbols in MS Access table it’s necessary:

a)

in design view change fields type

b)

in design view change the criteria

c)

in design view change fields property

d)

in datasheet view change fields property

e)

in datasheet view change format of the field

39.

To create parameter query which displays name of the doctor, it’s necessary to write:

a)

[Enter doctor’s name]

b)

(Enter doctor’s name)

c)

{Enter doctor’s name}

d)

/Enter doctor’s name/

e)

<Enter doctor’s name>

40.

МS Аccess is

a)

a shell

b)

system

c)

teaching tool

d)

accessory program

e)

application software

41.

Columns and rows in MS Access are called

a)

forms, fields

b)

cells, records

c)

fields, records

d)

columns, records

e)

columns, fields

42.

MS Аccess. The extension of database

a)

.txt, .doc

b)

.exe, .mdb

c)

.bat, .accdb

d)

.bmp, .accdb

e)

.mdb, .ассdb

43.

Database management system represents the program which is included into

a)

hardware

b)

operating system

c)

system of programming

d)

unique program software

e)

application program software

44.

MS Аccess. «Asterisk» symbol means

a)

new field

b)

new file

c)

new number

d)

new record

e)

new column

45.

MS Access. The type of a field is set in

a)

pages

b)

pages

c)

reports

d)

design View

e)

datasheet View

46.

MS Аccess. The maximum number of text field signs

a)

225

b)

155

c)

355

d)

455

e)

255

47.

MS Аccess. Command «Rename the table»

a)

F6

b)

F1

c)

F4

d)

F5

e)

F2

48.

MS Access. Name of the field with space

a)

6 signs

b)

4 signs

c)

50 signs

d)

10 signs

e)

64 sign

49.

MS Аccess. Data type

a)

reporting

b)

number

c)

symbol

d)

cycle

e)

graphic

50.

MS Аccess. Maximum numbers of symbols in «Memo» field

a)

65 500

b)

65 000

c)

65 536

d)

650 563

e)

65 564

51.

Relational database is the database which

a)

has file structur

b)

describes spreadsheets

c)

has Boolean algebra as a base of it

d)

connects data by means of physical indicators

e)

consists of two dimensional table connected with themselves logically

52.

The following operation is performed with records

a)

sort

b)

projecting

c)

forecasting

d)

exploitation

e)

searching on key

53.

MS Access program is constructed on the base

a)

С++

b)

Lisp

c)

Html

d)

MS Excel spreadsheets

e)

relational model of database management

54.

The main object of database is

a)

form

b)

table

c)

macro

d)

module

e)

template

55.

Creating of database includes

a)

stage of copying slides

b)

stage of output and project data

c)

stage of database project and input data

d)

stage of defining and deleting information

e)

stage of transmission and deleting of document

56.

The main types of MS Access models

a)

basic

b)

cyclic   

c)

standard

d)

application

e)

relational

57.

MS Аccess. Objects of database

a)

sort, filter

b)

book, sheets

c)

records, fields

d)

queries, tables

e)

investment, model

58.

MS Аccess. Types of data

a)

text

b)

financial

c)

graphical

d)

fractional

e)

percentage

59.

MS Access. Type of query

a)

logic

b)

classic

c)

empty

d)

separate

e)

parameter

60.

MS Access. Methods of creating tables

a)

table wizard

b)

simple table

c)

project table

d)

classic table

e)

table design

61.

MS Access. Types of reports

a)

number

b)

project

c)

simple report

d)

classic

e)

report design

62.

MS Access. Possible size of number field

a)

serial

b)

number

c)

integer

d)

financial

e)

percentage

63.

MS Access. To start program it’s necessary

a)

Start – Accessories – MS Office – MS Office Access

b)

Start – All programs – MS Office – MS Office Access

c)

Start – All programs – Accessories – MS Office Access

d)

Context menu – Create – MS Office Access 2007 Database

e)

Start – Accessories – Application programs – MS Office Access

64.

MS Access. The following operation is performed with queries

a)

filtration

b)

projecting

c)

forecasting

d)

exploitation

e)

searching on key

65.

MS Access. Methods of creating query

a)

classic

b)

simple

c)

project

d)

query wizard

e)

Share Point lists

66.

MS Access. Methods of creating forms

a)

form wizard

b)

simple form

c)

project form

d)

logic form

e)

logic form

67.

Technology which distributes information from the server to the client, used on mobile devices

a)

virtualization

b)

online conference

c)

computing clouds

d)

mobile push-notification messages

e)

micronuclear architecture of a hypervisor

68.

A model of providing cloud computing for access to use of operating systems and database management system

a)

Software as a Service

b)

Infrastructure as a Service

c)

Platform as a Service

d)

Storage as a Service

e)

Management as a Service

69.

To create profiles in the cloud use Google Docs

a)

documents

b)

tables

c)

presentations  

d)

forms

e)

my cards

70.

To work with one Google Document in online mode it is necessary for group of users

a)

remove the restriction

b)

create a conference

c)

open online chat

d)

create "circles friends"

e)

open shared access

71.

To create Google Presentation in the cloud it is necessary

a)

create mail.ru

b)

have a Google account

c)

be a Google Hangout User

d)

have access to social networks

e)

know the programming language

72.

The place where various information on the user is stored

a)

cloud

b)

browser

c)

account

d)

mailservice

e)

questionnaire

73.

Defect of a cloud computing is

a)

flexibility

b)

renting

c)

economyy

d)

availability and mobility

e)

not controllability of data

74.

The convenient environment for processing and storage of various formats information with user support of the Internet

a)

social networks

b)

development environment

c)

mobile services

d)

operating system

e)

cloud technologies

75.

Information and communication technologies are

a)

social science

b)

applied science

c)

medical science

d)

humanity

e)

fundamental science

76.

Technology which distributes information from the server to the client, used on mobile devices

a)

virtualization

b)

online conference

c)

computing clouds

d)

mobile push-notification messages

e)

micronuclear architecture of a hypervisor

77.

It is possible to change a profile photo, entering in service

a)

play

b)

disc

c)

email

d)

google

e)

translator

78.

To work with the documents of GOOGLE you need to enter in service

a)

email

b)

search

c)

disk

d)

calendar

e)

my account

79.

To create questionnaires are used Google documents

a)

forms

b)

tables

c)

my cards

d)

documents

e)

presentations

80.

To work with one Google document in online mode group of

users has to:

a)

lift a limit

b)

open an online chat

c)

create a conference

d)

open shared access

e)

create "circles friends"

81.

Mobile application is:

a)

service

b)

software

c)

data storage

d)

cloud calculation

e)

developing environment

82.

Portable multi-function device of mobile communication

a)

netbook

b)

tablet (pad)

c)

bluetooth

d)

monoblock

e)

smartphone

83.

The international organization defining recommendations in the field of telecommunications and radio

a)

ITU

b)

LTE

c)

APPLE

d)

GPS

e)

IES

84.

The largest software developer, the creator a web - service Elastic Computer Cloud (EC2):

a)

Kcell

b)

Apple

c)

Gmail 

d)

Amazon

e)

EPAM Systems 

85.

How many levels of  cloud technologies are exist:

a)

2

b)

4

c)

5

d)

3

e)

6

86.

Level of cloud technologies. Platform as a Service - PaaS)

a)

auxiliary level

b)

infrastructure level

c)

top level of appendices

d)

the lowest level of a platform

e)

intermediate level of a platform

87.

Global system of coordinates determination

a)

GPS

b)

GSM

c)

LTE

d)

Gmail

e)

FTP

88.

The system which allows to make calls and send messages

a)

GPS

b)

GSM

c)

Symbian

d)

Tizen

e)

iOS

89.

Google services

a)

ICQ, Internet

b)

Cloud

c)

Mailing, E-services

d)

Google+, My account

e)

Documents

90.

In GOOGLE.com it is possible to create

a)

report, schemes

b)

queries, reports

c)

catalogs, books

d)

programs, documents

e)

documents, presentations

91.

Cybersecurity. Information security from illegal access

a)

installation of the anti-virus program

b)

each user of system shall have the personal password

c)

assignment of responsible persons for information output

d)

to define an information access only for a manual of MPI

e)

each user shall have the computer for operation with system

92.

Cybersecurity. The main types of computer viruses

a)

hardware, file

b)

load, resident

c)

non-resident, not dangerous

d)

program, load, macro viruses

e)

file - load, not dangerous, resident

93.

Cybersecurity. Antivirus programs

a)

Eset, MS Access

b)

MS Word, MS Excel

c)

ZIP, MS Power Point

d)

AidsTest,  Kaspersky Kav

e)

MS DOS,  DoctorWeb, RAR

94.

Cybersecurity. Formats of executed files

a)

.doc, .bat

b)

.jpg, .txt, .doc

c)

.bmp, rar, html

d)

.exe, .com, .bat

e)

xls, zip, .doc, .bat

95.

Cybersecurity. Depending on the habitat computer viruses are divided as

a)

resident, non-resident

b)

harmless, dangerous, very dangerous

c)

network, file, loading, file and loading

d)

detectors, doctors, auditors, filters, vaccines

e)

parasitic, replicators, invisible beings, mutants, trojan

96.

Cybersecurity. On a way of infection computer viruses are divided as

a)

resident, non-resident

b)

harmless, dangerous, very dangerous

c)

network, file, loading, file and loading

d)

detectors, doctors, auditors, filters, vaccines

e)

parasitic, replicators, invisible beings, mutants, trojan

97.

Cybersecurity. MS Windows. File characteristics

a)

changing, moving and deleting the file

b)

copying, moving, deleting file and attributes

c)

date of moving of the file, creation date and time

d)

renaming, moving, deleting file and time of creation

e)

file name, creation date and time, file size and attributes

98.

Cybersecurity. Stealth viruses

a)

infect drivers

b)

infect boot sectors

c)

hide their presence

d)

destroy all information

e)

display the graphic drawing

99.

Cybersecurity. The way of virus detection includes

a)

scanning

b)

copying files

c)

heuristic analysis

d)

record of all files volume

e)

checking of executing files

100.

Cybersecurity. Computer can be infected with the virus

a)

on incorrect loading

b)

when loading drivers

c)

when text program is working

d)

when executing the infected program

e)

when inserting a floopy disk into the disk drive

101.

Cybersecurity. Detector programs

a)

modify programs

b)

find the infected files

c)

find changes and treat

d)

treat the infected files

e)

only find changes in files

102.

Cybersecurity. The computer virus is

a)

the program providing compression of files

b)

the program intended for creation of the presentation

c)

the program used for increase in speed of operation of a disc

d)

the program for coercion of the archived file to an initial look

e)

specially written program of small volume which spoils them

103.

Cybersecurity. The main two groups of viruses

a)

network, file

b)

macro, micro

c)

loading, dangerous

d)

resident, non-resident

e)

dangerous, not dangerous

104.

Cybersecurity. The viruses using errors and inaccuracies in a complex of software

a)

worms

b)

trojan horses

c)

propagandists

d)

logical bombs

e)

viruses interceptors

105.

Cybersecurity. Anti-virus programs

a)

MS DOS, NC

b)

ARJ, RAR, ZIP

c)

AutoCAD, CorelDraw

d)

MS Word, MS Excel, MS Access

e)

AidsTest, Doctor Web, Kaspersky KAV

106.

Cybersecurity.In what case the computer can be infected with virus

a)

when formatting a disk

b)

when testing the computer

c)

when loading of the computer

d)

at start of the DoctorWeb program

e)

during the work with the infected program

107.

Cybersecurity. Doctor Program

a)

Finds suspicious actions

b)

Prevents infection of files

c)

Prevents infection of files

d)

Looks for viruses with the known signature

e)

Compares an initial condition of the file to current

108.

Cybersecurity. Infection with loading viruses occurs at

a)

Closing of the file

b)

Opening of the file

c)

Data recording in the file

d)

Reading of information from the file

e)

Turning on the computer with busy floppy

109.

Cybersecurity. Loading viruses can infect

a)

еxe-files

b)

OBJ-files

c)

batch-files

d)

COM-files

e)

Boot-Strap program

110.

Cybersecurity. Replicators

a)

Find a virus

b)

Delete a virus

c)

Transfer a virus

d)

Destroy a virus program

e)

Warning infection with a virus

111.

Cybersecurity. Auditor programs

a)

Treat a disk

b)

Use vaccines

c)

Treat all computer

d)

Delete only the infected files of Windows

e)

Remember data on a condition of programs

112.

Cybersecurity. Macro viruses are

a)

Network files

b)

Package files

c)

Dialogue files

d)

Loading files

e)

Macros

113.

Cybersecurity. AVP is

a)

graphics editor

b)

anti-virus program

c)

the program spreading virus

d)

program of defragmentation

e)

the program, the pressing the file for saving of the place on a disk

114.

Cybersecurity. The computer virus is

a)

text editor

b)

graphic editor

c)

programming language

d)

the program damaging computer programs and data

e)

the program which is carrying out start of the computer

115.

Cybersecurity. Distinctive features of a computer virus are

a)

ease of recognition

b)

considerable volume of a program code

c)

small volume ability to independent start and repeated copying of a code, to creation of noise to correct operation of the computer

d)

need of start of the program from the user

e)

ability to increase in a noise stability of an operating system

Similar Resources on Wayground

Ақпараттық-коммуникациялық технологиялар

112 questions

Ақпараттық-коммуникациялық технологиялар

quiz

Worksheet

•

University

UASMPP25

110 questions

UASMPP25

quiz

Worksheet

•

University

C2. Tong quan TMĐT

112 questions

C2. Tong quan TMĐT

quiz

Worksheet

•

University

ktxn

119 questions

ktxn

quiz

Worksheet

•

University

акт рк-1

110 questions

акт рк-1

quiz

Worksheet

•

University

C Basic Data Types & Operators

110 questions

C Basic Data Types & Operators

quiz

Worksheet

•

University

Final Exam

115 questions

Final Exam

quiz

Worksheet

•

University

mid-term exam in SPETLE2

110 questions

mid-term exam in SPETLE2

quiz

Worksheet

•

University