Font size
WorksheetsИКТ 101-150 (2 деңгей)
Total questions: 48
Worksheet time: 48mins
MS Excel. The MIN function is
automatically finds a maximum value of numbers
automatically finds a minimum value of numbers
automatically finds an average value of numbers
automatically adds a column of numbers
automatically counts an amount of numbers
MS Excel. The AVR function is
automatically adds a column of numbers
automatically finds an average value of numbers
automatically finds a minimum value of numbers
automatically finds a maximum value of numbers
automatically counts an amount of numbers
MS Excel. The Count function is
automatically counts of the number of items in a list
automatically finds a maximum value of numbers
automatically finds an average value of numbers
automatically adds a column of numbers
automatically finds a minimum value of numbers
MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet
adds the highlighted diapason
appears a new column
appears a new row
finds an average value of numbers
removes the highlighting
MS Excel. The F5 function key is
The “Home” key
The “End” key
the "Go To" key
The “ESC” key
The “Delete” key
The right arrow key is used
to move left one cell at a time
to move up one cell at a time
to move down one cell at a time
to move right one cell at a time
to move up and down one cell at a time
The left 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
to move up and 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
to move up and down one cell at a time
The down arrow key is used
to move down one cell at a time
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 up and down one cell at a time
The Menu bar is located
directly near the Title bar
directly before the Title bar
directly behind the Title bar
directly over the Title bar
directly below the Title bar
This bar is located at the very top of the screen
The status bar
the Title bar
The formula bar
The cell address
The Menu bar
How many pages does The ribbon contain in MS Excel
5
10
9
8
3
Where does Microsoft Excel display the name of the workbook you are currently using
On the Status bar
On the ribbon
On the Title bar
On the Formula bar
On the Quick Access tool bar
How do you rename the spreadsheet in MS Excel
By clicking on the name twice
By clicking on file
By using the start bar
By clicking on Formula bar
By using Quick Access tool 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(C10:C1)=10;”Bad’;”Excellent”;”Bad”)
=IF(C1:C10)=10;”Excellent”;”Bad”)
=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)
=IF(SUM(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
Acolumncoordinate
What does “test!” mean in the following expression:
=IF(test!D11=1;1;0).
The name of the workbook
The address of the worksheet
The reference to the worksheet ”test”
The coordinate of the cell
Which expression give the “ИСТИНА” value if A3=20 and A4=40?
=ИЛИ(A3>20;A4<50)
=И(A3<19;A4<50)
=И(A5>19;A6<50)
=И(A3>19;A4<50)
=И(A3=19;A4=50)
Which expression gives the “ЛОЖЬ” value if A3=20 and A4=40?
=ИЛИ(A3=20;A4=40)
=НЕТ(A5>19;A6<50)
=ИЛИ(A3>50;A4<40)
=И(A3=20;A4=40)
=И(A3>19;A4<50)
Which expression calculates the SUM of the highlighted range (R1:R17) ?
=SUM(R3:R17)
=AVR(R3:R17)
=MAX(R3:R17)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
Which expression calculates the average of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
=AVR(R18:R20)
Which expression finds the maximum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=MAX(R18:R20)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MAX(R3:R17)
Which expression finds the minimum of the highlighted range (R18:R20) ?
=AVR(R3:R17)
=AUTOSUM(R3:R17)
=SIN(R3:R17)
=MIN(R18:R20)
=MIN(R3:R17)
Each worksheet contains
Records
columns and rows
Numbers
data types
Symbols
The trunk-modular principle of the architecture of modern personal computers implies such a logical organization of its hardware components, in which:
each device communicates with others directly;
each device communicates with others directly, and also through one central highway;
they all communicate with each other via the highway;
devices communicate with each other in a certain fixed sequence (ring);
the devices communicate with each other through the central processor, to which they are all connected.
Specify the devices that are part of the processor:
arithmetic logic unit, control unit;
random access memory, printer, video memory;
cache memory, video memory;
scanner, ROM;
display processor, video adapter.
Audio is …
other sound
Music, speech
sequence, picture
animation
sentence
Display devices
LED Monitors
Scanners, microphone
Cathode Ray Tube (CRT) monitors
Animation tools, Light Pen
Liquid Crystal Display (LCD) monitors / Flat-panel displays
The System Unit of the computer contains the major electronic components such as
Scanners, printer
Random access memory
hard disk
The Central processing Unit
microphone, Light Pen
The motherboard contains …
The Central processing Unit
Scanners, printers
Basic Input/output system
microphone, Light Pen
serial/parallel ports
… are located inside the System Unit
CD-ROM Drive
Floppy Disk Drive
Power Supply unit
Scanners, printers
microphone, Light Pen
System software functions:
running alternative operating systems, acts as an intermediary/interface
Allocate resources to the jobs, Translating to the machine code
storing, retrieving, and copying files
opening, executing, running, applications
reducing file sizes
OS goals:
Delete/remove user/application programs, Make the computer system inconvenient to use
Make the computer system convenient to use
Delete/remove user/application programs
Install user/application programs, Difficult the solving of user problems
Ease the solving of user problems
Tasks of Multi –user multi-task OSs :
Allocate resources to the jobs they want to run
Each user logged out from to the system, their workspace and so on, Remove resources to the jobs they want to run
Each user logged on to the system, their workspace and so on
Work in the most efficient use of computer processing cycles, Swap logs of how much processing time and resources they use
Keep logs of how much processing time and resources they use
Utility program’s tasks
Hiding files, Uncompressing files
Uninstalling software
Backing up files and disks
Checking for viruses
Compressing discs, All answers are correct
The translators translate source code into machine code and program translating approaches according to them:
Assembler
Interpreter
Pascal, C++
Compiler
System Software, Basic software
The popular file compressions
Borland Pascal, Dev C++
WinRAR
WinZIP
Avast, Windows Explorer
7ZIP
The main characteristics of a file:
Full name
The second part of a file’s name, Allocation of a file
Volume of file in byte
Date and time of deleting a file, All Information about a file
Date and time of creating a file
File attributes:
Undefined file, Measurable file
Read only
Hidden
Deleted file, All Information about a file
system
Human–computer interaction is a field of study that deals with:
Users
Only software, Only hardware
Technology
An intersection of hardware and software, All Information about a computer
Any communication
On the machine side, relevant techniques are …
communication theory, graphic and industrial design disciplines
linguistics, social sciences
computer graphics
operating systems
development environments
On the machine side, relevant techniques are …
computer graphics
operating systems
development environments
communication theory, graphic and industrial design disciplines
linguistics, social sciences
On the human side, relevant techniques are …
computer graphics, operating systems
communication theory
linguistics
programming languages, development environments
social sciences
Classical database models are
Classical database models are
Double model, Triple model
Network model
Bus model, Star model
Relational 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
Each unit in the model is a report which is also known as a node, tends to store records with links to other records
Each record in the database can have multiple parents, the relationships among data elements can have a many to many relationships
Network 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
each record has a single parent, structure arranges the various data elements in a hierarchy
is an expansion to the hierarchical structure
each record in the database can have multiple parents
tends to store records with links to other records
Relational database modeling
The basic data structure is a table
data is organized into an inverted tree-like structure, each unit in the model is a report which is also known as a node
data is represented in columns and rows
each record has a single parent
Based on relational data structure
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
each record has a single parent
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)
