WorksheetsАКТ РК-2
Total questions: 85
Worksheet time: 43mins
Program designed for working with spreadsheets:
Excel.
Word.
Access.
PowerPoint
Paint.
A program designed to work with databases:
Access.
Excel.
Word.
Power Point.
Paint.
The MS Excel program is:
Spreadsheet.
Text editor.
DBMS.
Graphic editor.
Operating system.
The Access program is:
DBMS.
Spreadsheet.
Text editor.
Graphic editor
Operating system.
The objects of the spreadsheet are:
Columns
Formula
Document
diagram
text
the most dangerous viruses
trojan Virus.
Polymorphic Virus.
File Infector Virus.
Macro Virus
Web Scripting Virus
Main objects of database:
Tables
Graphs
Slides
Drawings
prezi
Types of cloud computing
private clouds, public clouds, hybrid clouds, and multiclouds.
private clouds, public clouds, network, model
private clouds, public clouds, star, bus
private clouds, public clouds, CAN, WAN
private clouds, public clouds, hybrid clouds, tree
The type of address $A$5:
absolute
the relative
index
mixed
combined
The type of address $A5:
mixed
the relative
index
combined
tree-like
The type of address A$8:
mixed
the relative
index
combined
tree-like
The type of address A5:
the relative
index
mixed
combined
tree-like
The formula always starts with a sign in MS Excel:
«=»
«:»
«_»
«-»
«/»
Graphical representation of numerical data is:
diagram
table
row
column
form
The < > sign means:
is not equal to
greater than
equally
less
greater than or equal to
When you copy the formula, the address is changed:
the relative
index
mixed
combined
tree-like
When you copy the formula, the address is partially changed:
mixed
the relative
index
combined
tree-like
When you copy the formula, the address does not change:
absolute
the relative
index
mixed
combined
Fail of MS Excel is named:
book
worksheet
table
page
folder
The absolute addressing of cells uses the symbol:
$
!
#
№
“
The columns of the worksheet in the Excel program are denoted by:
AB
12A
FAS
21
A12
Number of cells in the range A2:B4:
6
10
8
4
2
Number of cells in the range B10:C14:
8
10
6
4
2
The text is aligned to EXCEL by default:
on the left
centered
on the right
in width
along the length
The numbers are aligned in the EXCEL by default:
on the right
centered
on the left
in width
along the length
A database is:
A systematized collection of data
Drawing
Graph
Slide
Text document
The relation (∞ - 1) corresponds to the relation:
many to one
one to one
one to many
many to many
all answers are correct
MS Access has relationships:
one to one
two to two
all answers are correct
one to three
2 to 2
MS Access. The number of relationship between tables in the Access MS:
3
1
2
8
5
Models of databases are:
Hierarchical
Documentary
Index
Matrix
Factographic
The database, where the data is the objects, is called:
Object-oriented
Hierarchical
Relational
Matrix
Index
Hybrid database is a combination of:
the relational and object-oriented databases
the relational and hierarchical databases
hierarchical and object-oriented databases
Index and object-oriented databases
Index and the relational databases
Table of database consists of:
fields
tabs
tools
buttons
graphs
The name of database field is:
The column header of the table
Command
The record header of the table
Type date
Number of record
A database object used for printing data is:
Report
Macros
Modules
Form
Request
An object that allows you to obtain the necessary data by any criterion:
Request
Macros
Report
Modules
Form
A blank designed for entering data with the name of database field is:
Form
Table
Modules
Macros
Report
Router is
a device that knows the address of each segment , determines the best route and filters the broadcast messages.
a device integrating the information networks using different protocols.
a device that enhances the electric signal.
a device to connect segments or networks.
conventionally called the initiator of the connection session.
In the design mode you can enter, change:
criterion
the field names
query criterion
report
macros
FTP protocol
file transfer protocol;
domain name system;
virtual terminal;
Simple Mail Transfer Protocol.
all correct
find the domain
.com
http
https
ftp
mailtoo
192.168.0.1. IP address, what does it means the number 192?
country
city
district
region
computer number
192.158.1.38. IP address, what does it means the number 158?
city
country
region
number PC
district
The record number is shown in the:
navigator
record
column
scrool bars
field
The computer uses:
binary system
decimal system
roman numeral system
greek system
hex system
A Binary system is made up of only:
0
0-9
0-7
A, B, C, D, E,F
G, H, I, K, L, M
An octal system is made up of only:
0-7
0
0-9
1
A, B, C, D, E,F
A hexadecimal system is made up of only:
0
0-9
1
0-7
A, B, C, D
Computers are directly connected to a single cable in the topology:
Bus topology
Mesh topology
Star topology
Tree topology
Hybrid
types of cloud computing services:
IaaS, PaaS, SaaS.
Bus, star, tree
Star, IaaS, PaaS
Tree, SaaS, Paas
Hybrid, SaaS, bus
Computers are connected to a single hub through a cable in the topology:
Star topology
Mesh topology
Bus topology
Tree topology
Hybrid
Advantages of Mesh Topology:
It is robust
Every node has its own connection to the hub
It transmits data only in one direction
Every device is connected to a single cable
Cabling cost is more
Multimedia is
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
a global network of billions of computers and other electronic devices.
is a technology which uses big data analysis, machine learning
an acronym for 5 elements of a goal: specific, measurable, achievable, relevant, and time-based.
an acronym that stands for Specific, Measurable
The absolute addressing of cells uses the symbol:
$
№
“
( )
>
It is :
Ring topology
Hybrid topology
Bus topology
A circle topology
Mesh topology
It is :
Star topology
Moon topology
Bus topology
A circle topology
Mesh topology
It is :
Mesh topology
Moon topology
Bus topology
A circle topology
TREE topology
It is :
Bus topology
Moon topology
Hybrid topology
Mesh topology
TREE topology
Network topology are:
Bus
Moon
A circle
Line
Bush
Define result of the following formula in Excel: =СУММ(A1:A5)
= A1+A2+A3+A4+A5
0
0,2
A1/A5
Adds values of A1 and A5
Computers are connected to a root node forming a hierarchy:
Tree
Moon
Bus
A circle
Ring
Software for create video:
Adobe Premiere Pro
Fine Reader
Fox Pro
MS Excel
MS Word
FTP is used for:
for transferring files from one computer to another
to view information on the World Wide Web
to transfer e-mail from one node to another
for data transfer between Internet nodes.
For conducting teleconferences on the Internet
A multimedia program is a program that uses:
sound
function
formula
C++
Python
Types of clouds:
public
common
toral
combine
tables
Address of cell consists of:
name of column and name of raw
name of column
name of raw
name of raw and name of column
name of worksheet
In the cloud you can create:
document
formula
video
music
videofilms
A computer network can be divided into the following types, based on the geographical area that they cover, they are:
MAN, CAN,WAN, LAN,GAN
STAR, Bus, Ring
Mesh, Tree, CAN
CAN,WAN, RING
MAN, CAN, STAR
Correct e-mail address:
aika@mail.ru
Aika.mail.ru
Gulnaz_@98mail.com
www.gulnaz_98.kz
Gulnaz_98@gmail@com
The cloud provides the following levels:
infrastructure
window
hardware
interface
translator
By the nature of ownership, cloud structures are divided into the types:
private
graphical
numerical
close
tree
Primitive interface is:
interface between user and computer
interface between user and Internet
interface between user and devices
interface between computer and Internet
interface between computers
The networks are:
two or more computer systems or electronics devices that are connected together
electronics devices
several computers
the protocol
the e-mail address
Classification of computer networks by territory occupied:
local
corporate
custom
parent
specialized
For transferring in a network of web-pages the protocol is used:
http
doc
ftp
dns
xls
Browsers are:
web viewer
Internet servers
antivirus software
programming language translators
text editor
The basic protocol on the Internet is:
TCP/IP
HTTP
HTML
TCP
WWW
Types of IP addresses
static and dynamic.
CAN and MAN
MAN and LAN
WAN and LAN
CAN and WAN
Search engines are:
yandex.ru
kaz.net
mail.ru
list.ru
buketov.edu
Search engines are:
altavista.com
kaz.net
mail.ru
list.ru
buketov.edu
There are browsers:
Internet Explorer
FTP
Djv
Internet service
choose correct E-mail address
diana@mail.ru
Diana@ru.mail
@Usernamediana
diana@Internetservice
Iinternet service@diana
The Internet is:
a global computer network
a local computer network
a regional computer network
Campus computer network
Corporate computer network
Internet service are:
World Wide Web
HTML
TC
IP
TCP
The tag of HTML <a>:
for the link
for titles
for paragraph
to style part of text
for images in document
