Font size
WorksheetsАКТ рубежка 2 бөлім
Total questions: 55
Worksheet time: 28mins
76.What is the organized presentation of data from a table or a query that is designed to be printed?
Reports
Forms
Macros
Queries
77.This is the foundation of any Access database. This is where the actual data resides
Queries
Tables
Reports
Macros
78.Access. The data representation model is
Binary data
Big data
hyperlinks data
output data
79.Specify a package that allows you to work with databases ...
SQL
Action
Crosstab
Parameter
80.This provides a convenient way to enter or find data in tables.
Forms
Macros
Queries
Modules
81.Which one is used to connect tables in MS Access?
Data relationships and changing connections, connection(link)
tabular form of columns and rows
Database window
Bottom status bar: Sheet labels, current worksheet
82.Allows you to view, create, edit, and modify database objects
database environments
Database window
database management system
Database reports
84. In a network DB the relationship among data is organized in ... form.
tabular form of columns and rows
Data relationships and changing connections, connection(link)
inferential analysis
prescriptive analysis
85.If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?
=IF(SUM(C1:C10)=10;"Excellent";"Bad")
=IF(SUM(C1:C1)=10;"Excellent";"Bad")
=IF(SUM(C1:C11)=11;"Excellent";"Bad")
=IF(SUM(C10:C1)=10;"Excellent";"Bad")
86.This is a particular data analysis technique that focuses on statistical modeling and knowledge discovery for predictive rather than purely descriptive purposes
data analysis
data mining
data management
database window
87.In this type of analysis, you can find different conclusions from the same data by selecting different samples.
inferential analysis
predictive analysis
prescriptive analysis
statistical analysis
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
inferential analysis
predictive analysis
prescriptive analysis
diagnostic analysis
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
inferential analysis
predictive analysis
prescriptive analysis
statistical analysis
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
predictive analysis
prescriptive analysis
diagnostic analysis
statistical analysis
91.This analysis includes collection, analysis, interpretation, presentation, and modeling of data. It analyses a set of data or a sample of data.
statistical analysis
diagnostic analysis
prescriptive analysis
inferential analysis
92.Using it, we can visualize the decisions that make it easy to understand and thus it is a popular data mining technique
a decision trees
data requierement
insert a histogram
statistical analysis
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.
window> split
insert a histogram
the column part will remain the same
group together the selected cells and center the content
94.Microsoft Excel consists of
spreadsheet program
drawing program
slide program
report program
95.Which bar does give the user information about: the current worksheet, data the worksheet contains and etc.
Bottom status bar: Sheet labels, current worksheet
Bottom status bar:Sheet labels,customization
Bottom status bar:current worksheet,reports
Bottom status bar:current worksheet,spreadsheet
96.A graphic that allows you to compare and contrast data in a visual format
• Plot
• Legend
• Chart
• Figures
97. … is an electronic spreadsheet that runs on a personal computer
Microsoft Excel
Microsoft Outlook
Word processor
Goodle chorme
98.Which command is used to check logical expression in MS Excel
1. =if (True or FALSE)
=Sum(True or FALSE)
=TrueFalse(True or FALSE)
=SumIf(True or FALSE)
99.Which expression finds the maximum of the highlighted range (R18:R20) ?
=max(R18:R20)
=max(R20R20)
=max(R1:R20)
=max(R18:R18)
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.
bandwidth
broadband
network topology
computer network
102.Which of the following performs modulation and demodulation?
Satellite
Modem
Flashcard
Fiber optics
103.A hardware device that connects multiple devices on a computer network
modem
router
switch
hub
104.A hardware device that divides the network connection among multiple devices
hub
modem
cable
router
105.Rules of an exchange of information between computers through a network
Protocol
Text editor
Spreadsheet
Standard programs
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.
• TCP/IP
• POP3
• SMPT
• FTP
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.
• TCP/IP
• HTTP
• SMPT
• FTP
108.This is an application layer protocol which moves files between a client and server on a computer network.
• TCP/IP
• HTTP
• POP3
• FTP
109.Unique address of the Web page
POP3
URL
FTP
URN
110.The geometrical scheme of computer association is called
• Network topology
• Local topology
• Ring topology
• Tire topology
111.The configuration (topology) of a local computer network in which all workstations are consistently connected with each other is called:
• Mesh
• Bus
• Ring
• Tree
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.
• Bus
• Star
• Ring
• Mesh
113.What of the given network topologies represents the closed chain?
• Bus
• Ring
• Mesh
• Star
114.This is a network model that offers centralized access to services and devices and one computer plays the role of a server.
• Peer to peer network
• Ethernet
• ATM
• Client server network
115.A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as
1computers, smartphones, tablets and personal digital assistants
telephone channels, personal computers
electronic games, personal computers
distance learning, text recognition
116.A computer network covering a small geographic area, like a home, office, or group of buildings is
LAN (Local Area Network)
WAN(Wide Area Network)
PAN(Personal Area Network)
VLN
117.A group of computers and network devices connected across large physical areas such as states or countries is called
WAN(Wide Area Network)
LAN (Local Area Network)
PAN(Personal Area Network)
CAN(Campus Area Network)
118.The basis of Metropolitan Area Network (MAN) category is a
Wimax, LTE
Gmail
GSM
FTP
119.The group of the local area networks unrolled in the compact territory of any establishment and servicing one building
• LAN
• MAN
• CAN
• PAN
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
cyber security
transision settings
auto content wizard
regional network
121.Which virus runs on computer memory
memory-resident virus
Computer virus
Stealth virus
Macrovirus
122.Most of the computer viruses are designed to
spread from host to host and has the ability to replicate itself
I still prefer to use a different password each time.
A collection of data and information that is delivered to a specific audience
Data relationships and changing connections, connection(link)
123.Which programs make it possible to automate series of operations so that they are performed as a single action
Relax, Melissa, Bablus, 097MIY2K
decision making support systems
Floppy disk, hard disk, compact discs, streamer
Keyboard, mouse, scanner.
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?
spyware
software
malware
damagedroid
125.Computer virus – is a
Program
Language
Software
Nardware
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?
I save all my different passwords in a file: when I need one, I can easily retrieve it.
I use the same password for each service that I use.
I still prefer to use a different word each time.
I still prefer to use a different password each time.
127.Set of program instructions that attaches itself to a file, reproduces itself and spreads to other files
• virus, trojan
• winrar, driver
• software, hardware
• virus, winrar
128.Stealth viruses
1) are is complex malware that hides itself after infecting a computer.
2) virus overtake computer system, when it boots and destroy information
129.Which of the following virus overtake computer system, when it boots and destroy information?
• System infectors
• Stealth virus
• Boot infectors
• Trojan
130.An ancient method of cryptography, which was used to encrypt messages by «shifting» letters alphabetically
The Caesar cipher
Press escape
Transition settings
cyber security
131.Branch of cryptology:
cryptography, cryptoanalysis
A collection of data and information that is delivered to a specific audience
The Caesar cipher
Transition settings
83.Anti-virus programs are:
