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