Font size
WorksheetsАружан 109+ ИКТ 2
Total questions: 53
Worksheet time: 35mins
The right arrow key is used
to move left one cell at a time
to move right one cell at a time
to move up one cell at a time
to move down one cell at a time
The left arrow key is used
to move right one cell at a time
to move left one cell at a time
to move up one cell at a time
to move down one cell at a time
The up arrow key is used
to move right one cell at a time
to move up one cell at a time
to move left one cell at a time
to move down one cell at a time
The down arrow key is used
to move right one cell at a time
to move down one cell at a time
to move up one cell at a time
to move up and down one cell at a time
The Menu bar is located
directly near the Title bar
directly below the Title bar
directly before the Title bar
directly behind the Title bar
This bar is located at the very top of the screen
The Menu bar
the Title bar
The status bar
The formula bar
How many pages does The ribbon contain in MS Excel
5
8
10
3
Where does Microsoft Excel display the name of the workbook you are currently using.
On the Status bar
On the Title bar
On the ribbon
0
On the Formula bar
How do you rename the spreadsheet in MS Excel
By clicking on file
By clicking on the name twice
By using the start bar
By clicking on Formula bar
If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?
=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C10:C1)=10;”Bad’;”Excellent”;”Bad”)
=IF(C1:C10)=10;”Excellent”;”Bad”)
How is the combination of a column coordinate and a row coordinate called?
A formula bar
A cell address
A title bar
A worksheet name
What does “test!” mean in the following expression:
=IF(test!D11=1;1;0).
The reference to the worksheet ”test”
The name of the workbook
The coordinate of the cell
Which expression give the “ИСТИНА” value if A3=20 and A4=40?
=ИЛИ(A3>20;A4<50)
=И(A3>19;A4<50)
=И(A3<19;A4<50)
=И(A5>19;A6<50)
Which expression gives the “ЛОЖЬ” value if A3=20 and A4=40?
=ИЛИ(A3=20;A4=40)
=ИЛИ(A3>50;A4<40)
=НЕТ(A5>19;A6<50)
=И(A3=20;A4=40)
Which expression calculates the SUM of the highlighted range (R1:R17) ?
=AVR(R3:R17)
=SUM(R3:R17)
=MAX(R3:R17)
=AUTOSUM(R3:R17)
Which expression calculates the average of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=AVR(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
Which expression finds the maximum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MAX(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
Which expression finds the minimum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MIN(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
Each worksheet contains
Records
columns and rows
Numbers
Symbols
The trunk-modular principle of the architecture of modern personal computers implies such a logical organization of its hardware components, in which:
they all communicate with each other via the highway;
each device communicates with others directly;
each device communicates with others directly, and also through one central highway;
devices communicate with each other in a certain fixed sequence (ring);
Specify the devices that are part of the processor:
random access memory, printer, video memory;
arithmetic logic unit, control unit;
cachememory, videomemory;
scanner, ROM;
Audio is …
sequence
animation
Music
speech
other sound
Display devices
Scanners
LED Monitors
Cathode Ray Tube (CRT) monitors
Liquid Crystal Display (LCD) monitors / Flat-panel displays
Light Pen
The System Unit of the computer contains the major electronic components such as
Scanners
printers
The Central processing Unit
hard disk
Random access memory
The motherboard contains …
The Central processing Unit
Basic Input/output system
serial/parallel ports
microphone
Light Pen
… are located inside the System Unit
Floppy Disk Drive
Power Supply unit
CD-ROM Drive
Light Pen
microphone
System software functions:
running alternative operating systems
opening, executing, running, applications
storing, retrieving, and copying files
reducing file sizes
Allocate resources to the jobs
OS goals:
Delete/remove user/application programs
Install user/application programs
Make the computer system convenient to use
Ease the solving of user problems
Difficult the solving of user problems
Tasks of Multi –user multi-task OSs :
Each user logged outfrom to the system, their workspace and so on
Each user logged on to the system, their workspace and so on
Allocate resources to the jobs they want to run
Keep logs of how much processing time and resources they use
Swap logs of how much processing time and resources they use
Utility program’s tasks
Hiding files
Uninstallingsoftware
Checkingforviruses
Backing up files and disks
Compressing discs
The translators translate source code into machine code and program translating approaches according to them:
Pascal
C++
Assembler
Interpreter
Compiler
The popular file compressions
Borland Pascal
WinRAR
WinZIP
7ZIP
Windows Explorer
The main characteristics of a file:
The second part of a file’s name
Full name
Volume of file in byte
Date and time of creating a file
Date and time of deleting a file
File attributes:
Undefined file
Read only
Hidden
system
Deleted file
Human–computer interaction is a field of study that deals with:
Only software
Users
Technology
Any communication
All Information about a computer
On the machine side, relevant techniques are …
communication theory
computer graphics
operating systems
development environments
linguistics
On the human side, relevant techniques are …
communication theory
computer graphics
linguistics
social sciences
programming languages
Classical database models are
Hierarchical model
Network model
Relational model
Star model
Triple model
Hierarchical database modeling
data is organized into an inverted tree-like structure
Each record has a single parent
structure arranges the various data elements in a hierarchy
tends to store records with links to other records
Each record in the database can have multiple parents
Networkdatabase modeling
tends to store records with links to other records
each record in the database can have multiple parents
is an expansion to the hierarchical structure
data is organized into an inverted tree-like structure
structure arranges the various data elements in a hierarchy
Relational database modeling
data is organized into an inverted tree-like structure
each unit in the model is a report which is also known as a node
The basic data structure is a table
Based on relational data structure
data is represented in columns and rows
Object-oriented modeling
data is organized into an inverted tree-like structure
each unit in the model is a report which is also known as a node
Uses object orientation as a basis of modeling
Models a system as a set of objects that interact with each others
No semantic gap (or impedance mismatch)
A Database Management System (DBMS) is
manage and control budgets to ensure maximum value for money and provide information to aid effective panel review of requests
for formatting strips with graphic materials and then printed
computer software designed for the purpose of managing databases based on a variety of data models
complex set of software programs that controls the organization, storage, management, and retrieval of data in a database
categorized according to their data structures or types
Relationship between tables:
More – to – one
One – to – one
Many – to – many
One – to – many
One – to – more
Quality control includes (Analysis and data management):
Implementing and unselecting errors in data through logical procedures, training, physical procedures, and avoidance of due complexity
Preventing and detecting errors in data through written procedures, training, verification procedures, and avoidance of undue complexity
Avoiding or eliminating inconsistencies, errors, and missing data through review of data collection forms and datasets
Assessing the quality of the data through notes kept by interviewers, coders, and data editors, through debriefing of subjects
Assessing the quality of the data through notes kept by customers, recorders, and text editors, through debriefing of subjects
Examples of end network devices include:
router
hub
Computers,laptops, file servers, web servers
Network printers
Security cameras
An intermediary devices include:
Computers,laptops,
Switches and wireless access points
Routers and modems
Firewalls
microphone
An intermediary devices include:
Computers,laptops,
Switches and wireless access points
Routers and modems
Firewalls
microphone
What is a hub?
It’s the central controlling device
A device used to extend a network so that additional workstations can be attached
This device typically provides from 4 to 24connections
A device used to reduce a network so that additional workstations cannot be attached
a device or application that uses the services provided by a server
Specify main features of network bridges?
connects multiple network segments at the data link layer (layer 2) of the OSI model
do not promiscuously copy traffic to all ports
do send broadcasts to all ports except the one on which the broadcast was received
A device used to extend a network so that additional workstations can be attached
a PC or a workstation on a network using services provided from the network file server
Computer networks can be classified by considering following different aspects as the basis
thescale
theconnectionmethod
the functional relationship (Network Architectures)
The usage technologies
The computer numbers
Network topology
bus
star
ring
polygon
single
The purpose of the data management system is to ensure:
high quality data
lower quality data
to ensure that the variability in the data derives from the phenomena under study and not from the data collection process
accurate, appropriate, and defensible analysis and interpretation of the data
accurate, appropriate, and indefensible analysis and interpretation of the data
