1. The hexadecimal system of the numeration uses the numerals.....

0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F

1. What is a cell reference?

The column letter and row number to identify a cell

1. MS Excel. For performing the filtering it is necessary:

give the command Given - a Filter – Autofilitr

1. What is the definition of a data base?

A structured set of data held in a computer.

1. Information processing includes:

the methods and technology of the reception, saving, transformations, issue

studbud

ICT

100 termsStudBud Administration22 plays

FGFGGFGFGFGFGFGFGFGF

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

1
1. Where the data is stored in Excel?
In a books
In a columnus
In a sheets
In a table
2
1. What does RAM stand for?
Primary and secondary
Read Annual Memos
Rom Attack Mode
Random Access Memory
3
1. Which of the following external storage devices hold more data?
USB Flash Drive
CD-ROM
Primary
External Hard Drive
4
File extensions for animation/video files:
tpg
tif
mp4
png
5
1. Close window in WINDOWS OS, you can press:
Alt + Esc
Ctrl + F4
Alt + F4
Alt + Tab
6
1. Manipulator converting motion into a control signal
Monitor
Plotter
Printer
Mouse
7
1. The Binary Form Of Decimal Number 17 is
11101
10001
10101
10111
8
1. You control and interact with a computer using a ...?
CPU
User Output
User Interface
User Outerface
9
MS Excel Addressing on method left, right,below, above - is identified to be Relative For indication of the absolute
$
+
#
//
10
1. In what part of the computer is information stored?
The memory
An output device
The CPU
An input device
11
1. An example of a range address:
A1=B3
B5+A5
C1;B3
A1:B3
12
1. What formula should you use when adding up a lot of numbers?
ALL
SUM
COUNT
TOTAL
13
What is a field?
Row Heading
Store animals
Column Heading
Data type
14
1. The constant memory.
BIOS
CD-Rom
DVD-Rom
The Cache
15
1. File extension for spreadsheet files:
xls, xlsx
wav, mp3
jpg, .png
mov., mp4
16
How many cells are in the range B2:D7?
18
6
22
12
17
Filtration of data
none of the above
selection of data on certain criteria
a way of arranging data in a particular order
a calculation that describes the relationship between cells
18
A set of programs that help you perform a specific task such as word processing
Operating system
Application software
Device Drivers
BIOS
19
1. Chief component of the first generation computer was….
Lamp technologies
Microprocessor
Transistors
Integrated Circuits
20
4How is called a system of interrelated technical devices that perform input,storage,processing and output of informatio
HARDWARE
MS OFFICE
WINRAR
SOFTWARE
21
1. Sorting can be
a calculation that describes the relationship between cells
statistical, mathematical and logical
on increase or on decrease order
selection of data on certain criteria
22
1. The hexadecimal system of the numeration uses the numerals.....
A, B, C, D, E, F
I, II, III… D, E, F
0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F
0, 1,2,3,4,5,6,7
23
1. MS Excel .The Formula begins with sign in ….
#
//
*
=
24
1. What is a cell reference?
A cell number and row letter used to identify column
The shape of a cell
The column letter and row number to identify a cell
A cell from a text book
25
Programs that are used to create vector graphics with lines, shapes, and colors
Device Drivers
Drawing software
Translator software
Network system
26
1. What name is each row in databases?
OS
field
table
record
27
1. Choose the example of an Output Device of PC.
Speakers
RAM
CPU
The Keyboard
28
1. What number is the position system?
XXXX;
IX. X,XI;
37ñ;
0,1,2,3,4;
29
1. Which category does the function MIN in Excel belong to:
Trigonometrically
Symbol
System
Statistical
30
1. MS Excel. The Address be
mixed, true. False
filter, auto filter
mixed, true, absolute
relative, absolute and mixed
31
1. What is an operating system?
Application software
The CPU
System software
32
1. What does the term "hardware" mean?
Computer system architecture
Audio control architecture
System application architecture
It is the Application Program
33
The second Generation of Computers -
1945-1955
1955-1960
1980-Onward
1960-1980
34
1. ###### means:
None of the above
You've misspelled something.
The cell is not wide enough.
You've entered a number wrong.
35
The Computer memory is measured in….
KiloCalories
KiloBytes
KiloJoules
KiloMeters
36
1. What symbol is coded information of computer?
0 and 1
7 and 0
16 and 0
1 and 1
37
Change addressing in formula possible by key...
F3
F1
F4
F2
38
1. Application software includes?
Device drivers. Manipulator
Text editor, spreadsheet
Utilities, Computer System
Hardware, Media control
39
1. File extension for archive files:
zip
png
jpg
mp3
40
The two kinds of main Memory are:
Primary and hard dick
Real and DAM
ROM and RAM
Power and BIOS
41
1. The most wide-spread operating system for personal computer are:
LUNIX, SyS
MS WINDOWS, OS/2, UNIX.
MAC, DOC
LUNIX. OSR 2
42
1. How many bits consists one number or symbol?
15
8
16
2
43
1. The operating system is:
applied program
text editor
system applied
system program
44
1. Data in a database is stored in which of the following:
Table
File
Form
Sheet
45
1. MS Excel. For performing the filtering it is necessary:
give the command Given - a Filter – Autofilitr
confirm the choice a snub on button OK.
give the file Given - a Sorting;
select the part of table, for which is required sorting
46
1. What is the definition of a data base?
A structured set of data held in a computer.
Computers connected Query
A list of words.
Computers connected locally.
47
File extensions for graphics files:
mp3
xls
txt
jpg
48
1. Information processing includes:
problems and issues and use to information.
the methods and technology of the reception, saving, transformations, issue
the methodical advice of the reception, saving, transformations, issues
the reception, saving, transformations to network.
49
1. What name is each column in databases?
software
record
field
table
50
1. The special programs oriented for controlling and managing external and internal devices of PC?
Device drivers
New plan of PC
Computer System
Primary secondary
51
1. The main function of the CPU?
all major computing operations
image operations
translation major computing operations
audio playback
52
1. The use of electronic signals, marks, or binary digits to represent character, numeric, visual, or audio data:
Data analysis
Data OC
Data representation
Data dependence
53
1. One Byte in a Computer is a
group of bits
group of fields
group of records
group of files
54
1. Data that are entered into a cell in spreadsheet:
text, chart, formula
number, formula, text
text, graphics, pattern
formula, pattern, number
55
1. What’s a table in Access
to display the data in a form
- for storage
to search data
for report
56
1. What is the address, which will be automatically changed?
Absolute
Link
Mixed
Relative
57
1. The first global computer network had a name:
Intranet
Filenet
Arpanet
Mailnet
58
1. What program would use for a database?
Publisher
Access
PowerPoint
Word
59
Who invented the Classical Computer Structure:
Charles Babbage
John von Neumann
Basic Pascal
Howard Aiken
60
1. VGA is.....
Video Graphics Array
Volatile Game Array
Volume Graphics Array
Visual Graphics Array
61
Which sequence of sizes is correct:
Byte - Kilobytes - Megabytes - Gigabytes
Gigabytes- Kilobytes - Megabytes
Kilobytes - Gigabytes - Megabytes
Megabytes - Kilobytes - Byte
62
1 gigabyte is equal to:
1024 megabytes
1000 kilobytes
1024 kilobytes
1024 bytes
63
1. Name of the first computer…..
Mainframe
Abacus
Pascaline
ENIAC
64
1. Choose the example of an Input Device of PC.
CPU
The Screen
The Keyboard
RAM
65
1. Once you have finished populating a table, you cannot add records to it:
False
Not given
Given
Untrue
66
1. A software package to implement a data base is
Database
DASD
System analysis
DBMS
67
A database created in Access with the extension:
*.dll
*.mdb
-*.dat
*.ppt
68
1. It is a program which transfers a text of other programs to machine codes:
Translator
Driver
Utility
Operating system
69
E-Learning Tools:
E-Marketing, Telemedicine
Electronic Textbooks, Intelligent Tutorial systems.
Proprietary solutions.
Digital Signature, Open Source initiatives
70
1. Meaning of CPU?
central processing unit
computer process union
computer power up
computer plan up
71
What are the collection of the methods and devices, which used by people for information handling?
DOC
ICT
IP
DNS
72
FTP means:
Form Transitive Protocol
Functional The CPU
FTransportation Protocol
File Transfer Protocol
73
1. Other components of a computer:
System Unit
Output device
Peripheral devices
Input device
74
1. What the button do you click to close a program?
The CRTL on the top right of the program
The SHIFT on the top right of the program
The X on the top right of the program
The PRINT button
75
1. which the type of software the spreadsheet MS Excel?
Image software
Application software
System software
Video software
76
1. Which is Application software?
Type of hardware
Formatting disks
Graphic programs
Drivers
77
In most IBM PCs, the CPU, the device drives, memory expansion slots and active components are mounted on a single boar.
Net board
Motherboard
CPU board
Internet board
78
1. Which of the following is NOT a considered computer hardware?
Hard Drive
CPU
Operating System
RAM
79
File extension for webpage files:
pptx
jpg
mp3
html
80
1. The short cut for create a new file Word or Excel...
Ctrl+V
Ctrl+Z
Ctrl+N
Ctrl+C
81
Smart city” uses the main factors such as
Efficiency, ecology
Intelligence, power
Noise reduction, popularity
Safety, environmental friendliness and economy
82
Mobile technology which based on digital technology:
Data storage system
4G
Cloud technology
3G
83
1. What data type would you use for 5/10/15?
Auto number
Currency
Number
Date/Time
84
1. Which The Subject is intended for Information, Information processing and technology and Communicating.
ICT
THE INTERNET
IST
NICT
85
Which of the following is not an input device?
Scanner
Keyboard
Microphone
Monitor
86
Examples of low-level programming languages:
Java
BASIC
Assembly language, Machine language
C
87
Examples of high-level programming languages:
Assembler
Excel
Java, Python
Word
88
1. What is the sign of absolute addresses?
sign equal
sign =
sign &
sign $
89
1. MS Excel. Choose the wrong indication of the name of the cell:
AD25
F5
Z1
10A
90
1. Rows in a database table are called?
Keys
Query
Records
Fields
91
1. MS Excel Change addressing in formula possible keystroke
SHIFT+F3
F4
SHIFT+F5
F3
92
Select most popular mobile platforms:
Windows Phone
MAC
IOS, Android
PC
93
1. A term is used in the context of multimedia that refers to music, movies, television shows, and books
Text content
Media content
BIOS content
Compiler
94
1. Translate the binary number 10 0011 for decimal
25
35
36
27
95
1. File extensions for text files:
txt, .rtf
pdf, .zip
wav,.mp3
mp4,.xls
96
1. What key is Help?
F2
F3
F1
F5
97
1. Which of the following is a completely absolute cell reference?
A20
$4
$J$4
J4
98
What is a Chart?
-It is a visual way to display and compare data
A calculation that describes the relationship between cells
A way of arranging data in a particular order
A photocopy book
99
A device that produces video footage in real time for transmission over the Internet:
Web-Camera
The CPU
Monitor
Printer
100
1. The terms 'primary key' and 'unique identifier' are synonymous:
True
False
Not given
Query data

ICT Flashcards | StudBud

ICT

100 termsStudBud Administration22 plays

FGFGGFGFGFGFGFGFGFGF

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

1
1. Where the data is stored in Excel?
In a books
In a columnus
In a sheets
In a table
2
1. What does RAM stand for?
Primary and secondary
Read Annual Memos
Rom Attack Mode
Random Access Memory
3
1. Which of the following external storage devices hold more data?
USB Flash Drive
CD-ROM
Primary
External Hard Drive
4
File extensions for animation/video files:
tpg
tif
mp4
png
5
1. Close window in WINDOWS OS, you can press:
Alt + Esc
Ctrl + F4
Alt + F4
Alt + Tab
6
1. Manipulator converting motion into a control signal
Monitor
Plotter
Printer
Mouse
7
1. The Binary Form Of Decimal Number 17 is
11101
10001
10101
10111
8
1. You control and interact with a computer using a ...?
CPU
User Output
User Interface
User Outerface
9
MS Excel Addressing on method left, right,below, above - is identified to be Relative For indication of the absolute
$
+
#
//
10
1. In what part of the computer is information stored?
The memory
An output device
The CPU
An input device
11
1. An example of a range address:
A1=B3
B5+A5
C1;B3
A1:B3
12
1. What formula should you use when adding up a lot of numbers?
ALL
SUM
COUNT
TOTAL
13
What is a field?
Row Heading
Store animals
Column Heading
Data type
14
1. The constant memory.
BIOS
CD-Rom
DVD-Rom
The Cache
15
1. File extension for spreadsheet files:
xls, xlsx
wav, mp3
jpg, .png
mov., mp4
16
How many cells are in the range B2:D7?
18
6
22
12
17
Filtration of data
none of the above
selection of data on certain criteria
a way of arranging data in a particular order
a calculation that describes the relationship between cells
18
A set of programs that help you perform a specific task such as word processing
Operating system
Application software
Device Drivers
BIOS
19
1. Chief component of the first generation computer was….
Lamp technologies
Microprocessor
Transistors
Integrated Circuits
20
4How is called a system of interrelated technical devices that perform input,storage,processing and output of informatio
HARDWARE
MS OFFICE
WINRAR
SOFTWARE
21
1. Sorting can be
a calculation that describes the relationship between cells
statistical, mathematical and logical
on increase or on decrease order
selection of data on certain criteria
22
1. The hexadecimal system of the numeration uses the numerals.....
A, B, C, D, E, F
I, II, III… D, E, F
0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F
0, 1,2,3,4,5,6,7
23
1. MS Excel .The Formula begins with sign in ….
#
//
*
=
24
1. What is a cell reference?
A cell number and row letter used to identify column
The shape of a cell
The column letter and row number to identify a cell
A cell from a text book
25
Programs that are used to create vector graphics with lines, shapes, and colors
Device Drivers
Drawing software
Translator software
Network system
26
1. What name is each row in databases?
OS
field
table
record
27
1. Choose the example of an Output Device of PC.
Speakers
RAM
CPU
The Keyboard
28
1. What number is the position system?
XXXX;
IX. X,XI;
37ñ;
0,1,2,3,4;
29
1. Which category does the function MIN in Excel belong to:
Trigonometrically
Symbol
System
Statistical
30
1. MS Excel. The Address be
mixed, true. False
filter, auto filter
mixed, true, absolute
relative, absolute and mixed
31
1. What is an operating system?
Application software
The CPU
System software
32
1. What does the term "hardware" mean?
Computer system architecture
Audio control architecture
System application architecture
It is the Application Program
33
The second Generation of Computers -
1945-1955
1955-1960
1980-Onward
1960-1980
34
1. ###### means:
None of the above
You've misspelled something.
The cell is not wide enough.
You've entered a number wrong.
35
The Computer memory is measured in….
KiloCalories
KiloBytes
KiloJoules
KiloMeters
36
1. What symbol is coded information of computer?
0 and 1
7 and 0
16 and 0
1 and 1
37
Change addressing in formula possible by key...
F3
F1
F4
F2
38
1. Application software includes?
Device drivers. Manipulator
Text editor, spreadsheet
Utilities, Computer System
Hardware, Media control
39
1. File extension for archive files:
zip
png
jpg
mp3
40
The two kinds of main Memory are:
Primary and hard dick
Real and DAM
ROM and RAM
Power and BIOS
41
1. The most wide-spread operating system for personal computer are:
LUNIX, SyS
MS WINDOWS, OS/2, UNIX.
MAC, DOC
LUNIX. OSR 2
42
1. How many bits consists one number or symbol?
15
8
16
2
43
1. The operating system is:
applied program
text editor
system applied
system program
44
1. Data in a database is stored in which of the following:
Table
File
Form
Sheet
45
1. MS Excel. For performing the filtering it is necessary:
give the command Given - a Filter – Autofilitr
confirm the choice a snub on button OK.
give the file Given - a Sorting;
select the part of table, for which is required sorting
46
1. What is the definition of a data base?
A structured set of data held in a computer.
Computers connected Query
A list of words.
Computers connected locally.
47
File extensions for graphics files:
mp3
xls
txt
jpg
48
1. Information processing includes:
problems and issues and use to information.
the methods and technology of the reception, saving, transformations, issue
the methodical advice of the reception, saving, transformations, issues
the reception, saving, transformations to network.
49
1. What name is each column in databases?
software
record
field
table
50
1. The special programs oriented for controlling and managing external and internal devices of PC?
Device drivers
New plan of PC
Computer System
Primary secondary
51
1. The main function of the CPU?
all major computing operations
image operations
translation major computing operations
audio playback
52
1. The use of electronic signals, marks, or binary digits to represent character, numeric, visual, or audio data:
Data analysis
Data OC
Data representation
Data dependence
53
1. One Byte in a Computer is a
group of bits
group of fields
group of records
group of files
54
1. Data that are entered into a cell in spreadsheet:
text, chart, formula
number, formula, text
text, graphics, pattern
formula, pattern, number
55
1. What’s a table in Access
to display the data in a form
- for storage
to search data
for report
56
1. What is the address, which will be automatically changed?
Absolute
Link
Mixed
Relative
57
1. The first global computer network had a name:
Intranet
Filenet
Arpanet
Mailnet
58
1. What program would use for a database?
Publisher
Access
PowerPoint
Word
59
Who invented the Classical Computer Structure:
Charles Babbage
John von Neumann
Basic Pascal
Howard Aiken
60
1. VGA is.....
Video Graphics Array
Volatile Game Array
Volume Graphics Array
Visual Graphics Array
61
Which sequence of sizes is correct:
Byte - Kilobytes - Megabytes - Gigabytes
Gigabytes- Kilobytes - Megabytes
Kilobytes - Gigabytes - Megabytes
Megabytes - Kilobytes - Byte
62
1 gigabyte is equal to:
1024 megabytes
1000 kilobytes
1024 kilobytes
1024 bytes
63
1. Name of the first computer…..
Mainframe
Abacus
Pascaline
ENIAC
64
1. Choose the example of an Input Device of PC.
CPU
The Screen
The Keyboard
RAM
65
1. Once you have finished populating a table, you cannot add records to it:
False
Not given
Given
Untrue
66
1. A software package to implement a data base is
Database
DASD
System analysis
DBMS
67
A database created in Access with the extension:
*.dll
*.mdb
-*.dat
*.ppt
68
1. It is a program which transfers a text of other programs to machine codes:
Translator
Driver
Utility
Operating system
69
E-Learning Tools:
E-Marketing, Telemedicine
Electronic Textbooks, Intelligent Tutorial systems.
Proprietary solutions.
Digital Signature, Open Source initiatives
70
1. Meaning of CPU?
central processing unit
computer process union
computer power up
computer plan up
71
What are the collection of the methods and devices, which used by people for information handling?
DOC
ICT
IP
DNS
72
FTP means:
Form Transitive Protocol
Functional The CPU
FTransportation Protocol
File Transfer Protocol
73
1. Other components of a computer:
System Unit
Output device
Peripheral devices
Input device
74
1. What the button do you click to close a program?
The CRTL on the top right of the program
The SHIFT on the top right of the program
The X on the top right of the program
The PRINT button
75
1. which the type of software the spreadsheet MS Excel?
Image software
Application software
System software
Video software
76
1. Which is Application software?
Type of hardware
Formatting disks
Graphic programs
Drivers
77
In most IBM PCs, the CPU, the device drives, memory expansion slots and active components are mounted on a single boar.
Net board
Motherboard
CPU board
Internet board
78
1. Which of the following is NOT a considered computer hardware?
Hard Drive
CPU
Operating System
RAM
79
File extension for webpage files:
pptx
jpg
mp3
html
80
1. The short cut for create a new file Word or Excel...
Ctrl+V
Ctrl+Z
Ctrl+N
Ctrl+C
81
Smart city” uses the main factors such as
Efficiency, ecology
Intelligence, power
Noise reduction, popularity
Safety, environmental friendliness and economy
82
Mobile technology which based on digital technology:
Data storage system
4G
Cloud technology
3G
83
1. What data type would you use for 5/10/15?
Auto number
Currency
Number
Date/Time
84
1. Which The Subject is intended for Information, Information processing and technology and Communicating.
ICT
THE INTERNET
IST
NICT
85
Which of the following is not an input device?
Scanner
Keyboard
Microphone
Monitor
86
Examples of low-level programming languages:
Java
BASIC
Assembly language, Machine language
C
87
Examples of high-level programming languages:
Assembler
Excel
Java, Python
Word
88
1. What is the sign of absolute addresses?
sign equal
sign =
sign &
sign $
89
1. MS Excel. Choose the wrong indication of the name of the cell:
AD25
F5
Z1
10A
90
1. Rows in a database table are called?
Keys
Query
Records
Fields
91
1. MS Excel Change addressing in formula possible keystroke
SHIFT+F3
F4
SHIFT+F5
F3
92
Select most popular mobile platforms:
Windows Phone
MAC
IOS, Android
PC
93
1. A term is used in the context of multimedia that refers to music, movies, television shows, and books
Text content
Media content
BIOS content
Compiler
94
1. Translate the binary number 10 0011 for decimal
25
35
36
27
95
1. File extensions for text files:
txt, .rtf
pdf, .zip
wav,.mp3
mp4,.xls
96
1. What key is Help?
F2
F3
F1
F5
97
1. Which of the following is a completely absolute cell reference?
A20
$4
$J$4
J4
98
What is a Chart?
-It is a visual way to display and compare data
A calculation that describes the relationship between cells
A way of arranging data in a particular order
A photocopy book
99
A device that produces video footage in real time for transmission over the Internet:
Web-Camera
The CPU
Monitor
Printer
100
1. The terms 'primary key' and 'unique identifier' are synonymous:
True
False
Not given
Query data