wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

АКТ рубежка 2 бөлім

Total questions: 55

Worksheet time: 28mins

Name
Class
Date
1.

76.What is the organized presentation of data from a table or a query that is designed to be printed?

a)

Reports

b)

Forms

c)

Macros

d)

Queries

2.

77.This is the foundation of any Access database. This is where the actual data resides

a)

Queries

b)

Tables

c)

Reports

d)

Macros

3.

78.Access. The data representation model is

a)

Binary data

b)

Big data

c)

hyperlinks data

d)

output data

4.

79.Specify a package that allows you to work with databases ...

a)

SQL

b)

Action

c)

Crosstab

d)

Parameter

5.

80.This provides a convenient way to enter or find data in tables.

a)

Forms

b)

Macros

c)

Queries

d)

Modules

6.

81.Which one is used to connect tables in MS Access?

a)

Data relationships and changing connections, connection(link)

b)

tabular form of columns and rows

c)

Database window

d)

Bottom status bar: Sheet labels, current worksheet

7.

82.Allows you to view, create, edit, and modify database objects

a)

database environments

b)

Database window

c)

database management system

d)

Database reports

8.

84. In a network DB the relationship among data is organized in ... form.

a)

tabular form of columns and rows

b)

Data relationships and changing connections, connection(link)

c)

inferential analysis

d)

prescriptive analysis

9.

85.If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?

a)

=IF(SUM(C1:C10)=10;"Excellent";"Bad")

b)

=IF(SUM(C1:C1)=10;"Excellent";"Bad")

c)

=IF(SUM(C1:C11)=11;"Excellent";"Bad")

d)

=IF(SUM(C10:C1)=10;"Excellent";"Bad")

10.

86.This is a particular data analysis technique that focuses on statistical modeling and knowledge discovery for predictive rather than purely descriptive purposes

a)

data analysis

b)

data mining

c)

data management

d)

database window

11.

87.In this type of analysis, you can find different conclusions from the same data by selecting different samples.

a)

inferential analysis

b)

predictive analysis

c)

prescriptive analysis

d)

statistical analysis

12.

88.In this analysis shows "what is likely to happen" by using previous data. So here, this Analysis makes predictions about future outcomes based on current or past data

a)

inferential analysis

b)

predictive analysis

c)

prescriptive analysis

d)

diagnostic analysis

13.

89.This analysis combines the insight from all types of analysis to determine which action to take in a current problem or decision, because predictive and descriptive analysis are not enough to improve data performance

a)

inferential analysis

b)

predictive analysis

c)

prescriptive analysis

d)

statistical analysis

14.

90.This analysis is useful to identify behavior patterns of data. If a new problem arrives, then you can look into this analysis to find similar patterns of that problem

a)

predictive analysis

b)

prescriptive analysis

c)

diagnostic analysis

d)

statistical analysis

15.

91.This analysis includes collection, analysis, interpretation, presentation, and modeling of data. It analyses a set of data or a sample of data.

a)

statistical analysis

b)

diagnostic analysis

c)

prescriptive analysis

d)

inferential analysis

16.

92.Using it, we can visualize the decisions that make it easy to understand and thus it is a popular data mining technique

a)

a decision trees

b)

data requierement

c)

insert a histogram

d)

statistical analysis

17.

93.There are times when you need to compare values that are far away from each other. What button used to split the screen in two vertically and/or horizontally and place the values close to each other on the screen.

a)

window> split

b)

insert a histogram

c)

the column part will remain the same

d)

group together the selected cells and center the content

18.

94.Microsoft Excel consists of

a)

spreadsheet program

b)

drawing program

c)

slide program

d)

report program

19.

95.Which bar does give the user information about: the current worksheet,  data the worksheet contains and etc.

a)

Bottom status bar: Sheet labels, current worksheet

b)

Bottom status bar:Sheet labels,customization

c)

Bottom status bar:current worksheet,reports

d)

Bottom status bar:current worksheet,spreadsheet

20.

96.A graphic that allows you to compare and contrast data in a visual format

a)

•    Plot

b)

•    Legend

c)

•    Chart

d)

•    Figures

21.

97. … is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Excel

b)

Microsoft Outlook

c)

Word processor

d)

Goodle chorme

22.

98.Which command is used to check logical expression in MS Excel

a)

1.     =if (True or FALSE)

b)

=Sum(True or FALSE)

c)

=TrueFalse(True or FALSE)

d)

=SumIf(True or FALSE)

23.

99.Which expression finds the maximum of the highlighted range (R18:R20) ?

a)

=max(R18:R20)

b)

=max(R20R20)

c)

=max(R1:R20)

d)

=max(R18:R18)

24.

101.A system that connects computers and other devices (e.g., printers) via communications media so that data and information can be transmitted among them.

a)

bandwidth

b)

broadband

c)

network topology

d)

computer network

25.

102.Which of the following performs modulation and demodulation?

a)

Satellite

b)

Modem

c)

Flashcard

d)

Fiber optics

26.

103.A hardware device that connects multiple devices on a computer network

a)

modem

b)

router

c)

switch

d)

hub

27.

104.A hardware device that divides the network connection among multiple devices

a)

hub

b)

modem

c)

cable

d)

router

28.

105.Rules of an exchange of information between computers through a network

a)

Protocol

b)

Text editor

c)

Spreadsheet

d)

Standard programs

29.

106.This protocol specifies how data is exchanged over the internet by providing end-to-end communications that identify how it should be broken into packets, addressed, transmitted, routed and received at the destination.

a)

•    TCP/IP

b)

•    POP3

c)

•    SMPT

d)

•    FTP

30.

107.The service intended for data communication for the World Wide Web, where hypertext documents include hyperlinks to other resources that the user can easily access.

a)

•    TCP/IP

b)

•    HTTP

c)

•    SMPT

d)

•    FTP

31.

108.This is an application layer protocol which moves files between a client and server on a computer network.

a)

•    TCP/IP

b)

•    HTTP

c)

•    POP3

d)

•    FTP

32.

109.Unique address of the Web page

a)

POP3

b)

URL

c)

FTP

d)

URN

33.

110.The geometrical scheme of computer association is called

a)

•    Network topology

b)

•    Local topology

c)

•    Ring topology

d)

•    Tire topology

34.

111.The configuration (topology) of a local computer network in which all workstations are consistently connected with each other is called:

a)

•    Mesh

b)

•    Bus

c)

•    Ring

d)

•    Tree

35.

112.Basic topology of a computer network in which all computers of network are attached to central node (usually the switch), forming physical network segment.

a)

•    Bus

b)

•    Star

c)

•    Ring

d)

•    Mesh

36.

113.What of the given network topologies represents the closed chain?

a)

•    Bus

b)

•    Ring

c)

•    Mesh

d)

•    Star

37.

114.This is a network model that offers centralized access to services and devices and one computer plays the role of a server.

a)

•    Peer to peer network

b)

•    Ethernet

c)

•    ATM

d)

•    Client server network

38.

115.A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as

a)

1computers, smartphones, tablets and personal digital assistants

b)

telephone channels, personal computers

c)

electronic games, personal computers

d)

distance learning, text recognition

39.

116.A computer network covering a small geographic area, like a home, office, or group of buildings is

a)

LAN (Local Area Network)

b)

WAN(Wide Area Network)

c)

PAN(Personal Area Network)

d)

VLN

40.

117.A group of computers and network devices connected across large physical areas such as states or countries is called

a)

WAN(Wide Area Network)

b)

LAN (Local Area Network)

c)

PAN(Personal Area Network)

d)

CAN(Campus Area Network)

41.

118.The basis of Metropolitan Area Network (MAN) category is a

a)

Wimax, LTE

b)

Gmail

c)

GSM

d)

FTP

42.

119.The group of the local area networks unrolled in the compact territory of any establishment and servicing one building

a)

•    LAN

b)

•    MAN

c)

•    CAN

d)

•    PAN

43.

120.This is the practice of protecting systems, networks, and programs from digital attacks. These are usually aimed at accessing, changing, or destroying sensitive information; extorting money from users; or interrupting normal business processes

a)

cyber security

b)

transision settings

c)

auto content wizard

d)

regional network

44.

121.Which virus runs on computer memory

a)

memory-resident virus

b)

Computer virus

c)

Stealth virus

d)

Macrovirus

45.

122.Most of the computer viruses are designed to

a)

spread from host to host and has the ability to replicate itself

b)

I still prefer to use a different password each time.

c)

A collection of data and information that is delivered to a specific audience

d)

Data relationships and changing connections, connection(link)

46.

123.Which programs make it possible to automate series of operations so that they are performed as a single action

a)

Relax, Melissa, Bablus, 097MIY2K

b)

decision making support systems

c)

Floppy disk, hard disk, compact discs, streamer

d)

Keyboard, mouse, scanner.

47.

124.Usually this type of cybersecurity threat aims to track and sell your internet usage data, capture your credit card or bank account information, or steal your personal identity. What is term for malicious software, which collects personal information from your devices?

a)

spyware

b)

software

c)

malware

d)

damagedroid

48.

125.Computer virus – is a

a)

Program

b)

Language

c)

Software

d)

Nardware

49.

126.Working at your desk, you have received an email from Microsoft explaining that your password it out of date and you must set a new one.  The link within the email will guide you through it.  Your next step is?

a)

I save all my different passwords in a file: when I need one, I can easily retrieve it.

b)

I use the same password for each service that I use.

c)

I still prefer to use a different word each time.

d)

I still prefer to use a different password each time.

50.

127.Set of program instructions that attaches itself to a file, reproduces itself and spreads to other files

a)

•    virus, trojan

b)

•    winrar, driver

c)

•    software, hardware

d)

•    virus, winrar

51.

128.Stealth viruses

a)

1) are is complex malware that hides itself after infecting a computer.

b)

2)   virus overtake computer system, when it boots and destroy information

52.

129.Which of the following virus overtake computer system, when it boots and destroy information?

a)

•    System infectors

b)

•    Stealth virus

c)

•    Boot infectors

d)

•    Trojan

53.

130.An ancient method of cryptography, which was used to encrypt messages by «shifting» letters alphabetically

a)

The Caesar cipher

b)

Press escape

c)

Transition settings

d)

cyber security

54.

131.Branch of cryptology:

a)

cryptography, cryptoanalysis

b)

A collection of data and information that is delivered to a specific audience

c)

The Caesar cipher

d)

Transition settings

55.

83.Anti-virus programs are:

a)
b)
c)
d)