Worksheetsикт сессия
Total questions: 200
Worksheet time: 1hrs 18mins
A monitor displays information
True
False
Not sure
Depends on system
A microphone is used as an input device
False
Output device
Storage device
True
The binary equivalent of the octal number 13 is:
1011
1101
1110
1001
Which of the following are audio file extensions?
.jpg
.txt
.mp3
.exe
What software is used to create slideshows?
MS Excel
MS Word
MS Paint
MS PowerPoint
What would you use to find information online?
Spreadsheet
Search Engine
Antivirus
Firewall
Presentation Graphics may contain:
Text only
Images only
Graphs only
All of these
Most popular Spreadsheet Editor is:
Google Chrome
MS PowerPoint
MS Excel
Adobe Reader
For creating documents, you use:
MS Excel
VLC Player
Google Docs, MS Word
File Manager
What number is represented by the OFF state in binary?
2
1
0
-1
What is computer software?
Physical parts of computer
Input devices
Application of computers for data operations
Storage hardware
What is computer hardware?
Data storage methods
Software programs
Data transmission
Physical parts of computer
Terabyte (TB) equals:
1000 GB
1024 MB
1024 GB
2048 MB
Kilobyte (KB) equals:
1024 Kilobytes
1024 Bytes
512 Bits
2048 Bytes
Shortcut for Bold is:
Ctrl+C
Ctrl+V
Ctrl+B
Ctrl+Z
The smallest measurement of memory is:
Bit
Byte
KB
MB
Shortcut key for Copy:
Ctrl+X
Ctrl+V
Ctrl+C
Ctrl+B
Shortcut for Undo:
Ctrl+U
Ctrl+Z
Ctrl+A
Ctrl+Y
Shortcut for Cut:
Ctrl+X
Ctrl+C
Ctrl+Z
Ctrl+P
How many bits are in a byte?
2
4
8
16
A valid e-mail address is:
Decimal 16 to Hexadecimal is:
F
1A
10
100
When pasting from clipboard, you ___ it.
Write
Paste
Share
Shortcut key for Paste:
Ctrl+P
Ctrl+V
Ctrl+C
Ctrl+Z
Times New Roman, Comic Sans and Calibri are called:
Colors
Fonts
Graphics
Templates
What happens when you cut text?
It is copied
It is printed
It is deleted
It is removed and placed on clipboard
Not a topic in computer science:
Algorithms
Programming
Thermodynamics
Databases
Binary digits are called:
Bytes
Bits
Numbers
Symbols
Binary equivalent of Hex 74A is:
11101001010
100100101
110011000
111001011
Why do we use Excel?
Write code
Watch movies
Processing tables
Send email
Binary equivalent of Hex 7BD is:
11110111101
1001100110
101010111
111100111
ON state in binary is:
0
2
1
-1
What does "$" mean in Excel?
Currency
No change in cell reference
Error
Division
To make address ABSOLUTE, we:
Use %
Use #
Use $
Use =
Meaning of "C$5" in Excel:
Column changes
Row changes
Both change
Neither changes
Excel "Master Function" button:
Format text
Add chart
Insert formulas
Open help
Valid cell address:
B&B
BB1
1B1
B1B
Valid cell address:
A2
2A
AA
22
MIN() function:
Returns max value
Returns text
Returns smallest number
Calculates sum
MAX() function:
Returns maximum
Returns minimum
Returns average
Returns sum
AVERAGE() function:
Returns total
Returns average
Returns maximum
Returns minimum
All formulas start with:
+
-
=
*
Invalid Excel expression:
A1+B2
50x10
A3*10
B1/2
Correct Excel expression
A3x10
A310
A310
10A3
A1=500, A2=450, autofill A3 = ?
400
450
550
350
A1=300, A2=350, autofill A3 = ?
350
300
400
450
Can we rotate text in Excel cell?
no
yes
maybe
Only with plugin
Address $C$1 is:
Mixed
Relative
Absolute
Incorrect
Address C$1 is:
Absolute
Mixed
Relative
Invalid
Address C1 is:
Absolute
Mixed
Relative
None
<51> "######" means:
Question mark
Invalid format
Successful result
You have entered a wrong number
<52> In Excel, which symbol is used for multiplication?
A) %
B) /
C) *
D) +
<53> If A1=90; A2=85; A3=80; A4=75; A5=75, which formula is INCORRECT to get the total?
A) =A1+A2+A3+A4+A5
B) =SUM(A1:A5)
C) =SUM(A1,A2,A3,A4,A5)
D) =AVERAGE(A1:A5)
<54> If cell E10 = 75, and the rule is: if higher than 74, show "PASSED", otherwise "FAILED", choose the correct formula:
=IF(E10>74,"passed","failed")
=IF(E10<74,"passed","failed")
=IF(E10>=75,"failed","passed")
=IF(E10=75,"passed")
What is the e-Government portal of Kazakhstan?
<56> EDS stands for:
Electronic Data System
Electronic Digital Signature
Electronic Document Service
<58> HTML stands for:
Hyper Text Markup Language
Hyperlink Text Management Language
High-level Text Management Language
<59> Which HTML tag sets background color to yellow and text color to blue?
<body bgcolor=yellow text=blue>
<body background="yellow" color="blue">
`<text=blue background
<59> What HTML tag sets a yellow background and blue text?
<html bgcolor="yellow" text="blue">
<body bgcolor=yellow text=blue>
<background=yellow, text=blue>
<61> How to identify numbered and unnumbered lists in HTML?
<NL> and <UL>
B) <NUM> and <LIST>
C) <OL> and <UL>
<62> How to identify italic and bold text in HTML?
<I>…</I> and <B>…</B>
<EM> and <BLD>
<IT> and <BO>
<63> How to identify headers in HTML?
C) <H1>…</H1> and <H2>…</H2>
D) <TITLE1> and <TITLE2>
A) <P1> and <P2>
<64> How to start a new paragraph in HTML?
A) <NEW>
B) <P>
C) <BR>...<BR>
<65> How to insert a hyperlink to "Task1.html"?
A) <A HREF="Task1.html">TEXT</A>
B) <LINK="Task1.html">TEXT</LINK>
C) <HYPERLINK HREF="Task1.html">TEXT</HYPERLINK>
<66> In HTML, every piece of code is called as…
A) command
B) script
C) tags
<67> What diagram is used to visualize workflow?
A) Flowchart
B) Gantt chart
C) UML diagram
D) PERT chart
<68> A computer file created using hypertext markup language HTML
A) Document
B) File
C) Web page
<69> Web-site
collection of web pages, which are united by some principle
database
HTML file
<70> What is identifying a resource, provides information on the location of this resource?
A) IP
B) URL
C) DNS
<71> Choose tags to create a table in HTML?
A) TABLE, TR, TD
B) BODY, HEAD, TITLE
C) UL, OL, LI
<72> Choose tags to enter the window’s title in HTML?
A) HEAD, TITLE
B) BODY, TITLE
C) TITLE, SCRIPT
<73> … - application layer protocol of data transmission.
A) FTP
B) SMTP
C) Hypertext transfer protocol (http)
<74> … - standardized markup language for documents on the world wide web.
A) Hypertext markup language (html)
B) CSS
C) XML
<75> … - technology of description of the appearance of a document executed by the markup language.
A) HTML
A) HTML
C) Cascading Style Sheets (CSS)
<76> … is the integrated mechanism of interaction between the state and citizens, state agencies with each other, ensuring consistency with the help of informational technologies.
A) Electronic government
B) Digital economy
C) Internet banking
<77> What is PowerPoint?
A) It is a computer program that allows you to create and show slides to support a presentation.
B) It is a photo editor
C) It is a programming IDE
<78> PowerPoint can be used to:
A) organise and structure your presentation
B) edit audio
C) develop apps
<79> In what mobile generation was appeared Wi-Fi technology?
A) 2G
B) 3G
C) 4G
<80> Android is best classified as one of the fastest growing of these
A) desktop software
B) web browsers
C) mobile operating systems
<81> How much space Google gives users as free?
A) 5GB
B) 10GB
C) 15GB
<82> Conversion of a hexadecimal number 3D to binary number is
A) 111101
B) 110011
C) 101010
<83> The decimal equivalent of the binary number 100101 is
A) 37
B) 45
C) 52
<84> Conversion of an octal number 106 to binary number is
A) 1000110
B) 1100111
C) 1010101
<85> Conversion of an octal number 73 to binary number is
A) 111011
B) 101010
C) 110111
<86> The decimal equivalent of the binary number 1010100 is
A) 74
B) 94
C) 84
<87> Conversion of a hexadecimal number D8 to binary number is
A) 11011000
B) 11010100
C) 10101000
<88> The octal equivalent of the number 10011.1101 is
A) 23.64
B) 21.55
C) 24.61
<89> The decimal equivalent of the binary number 101011 is
A) 43
B) 41
C) 47
<90> HTML file’s type?
A) media viewer
B) text editor or <input type="file">
C) PDF
<91> Format of the HTML document.
A) .doc
A) .doc
C) .html
<92> … - is a program to create video.
A) WS Movie Maker
B) Excel
C) Notepad
<93> Select the function to display records that meet certain criteria in Excel.
A) filter
B) print
C) align
<94> Find the NAME whose 2nd letter is “m” using the text filter in Excel.
A) equals ?m*
B) equals m?*
C) equals m
<95> Tag for background’s color of the document in HTML?
A) BODY BGCOLOR
B) HTML COLOR
C) STYLE BG
<96> an example of numbered list in HTML.
A) <OL>
B) <UL>
C) <LI>
<97> Tag of unnumbered list in HTML.
A) <OL>
B) <UL>
C) <LI>
<98> Tag for the first level, size of words in HTML.
A) H1
B) H2
C) P
<99> Tag for the second level, size of words in HTML.
A) H1
B) H2
C) H3
<100> Tag for the third level, size of words in HTML.
A) H2
B) H3
C) H4
<101> Tag for the fourth level, size of words in HTML.
A) H3
B) H4
C) H5
<102> Tag for the fifth level, size of words in HTML.
A) H4
B) H5
C) H6
<103> Tag for the sixth level, size of words in HTML.
A) H6
B) H5
C) H4
<104> Tag for italic words in HTML.
A) <I>
B) <EM>
C) <IT>
<105> Tag for bold words in HTML.
A) <B>
B) <STRONG>
C) <BLD>
<106> Tag for underline words in HTML.
A) <U>
B) <UL>
C) <UNDER>
<107> Tag for superscript words in HTML.
A) <sup>
B) <high>
C) <up>
<108> Tag for subscript words in HTML.
A) <sub>
B) <low>
C) <under>
<109> Tag for beginning of a new paragraph in HTML.
A) <BR>
B) <P>
C) <NEW>
Tag for scrolling text in HTML.
<scroll>
<slide>
<marquee>
<move>
Tag to insert picture in HTML.
<image>
<pic>
<img src>
<photo>
Tags to skip three lines in HTML.
<BR><BR>
<BR><BR><BR><BR>
<BR><BR><BR>
<BR><HR><BR>
Tags to skip two lines in HTML.
<BR>
<BR><BR>
<BR><BR><BR>
<P><P>
Tags to skip four lines in HTML.
<BR><BR><BR>
<BR><BR><BR><BR>
<BR><HR><BR><HR>
<P><P><P><P>
Tag to insert a hyperlink in HTML.
<link>
<hyper>
<a href=" "> and </a>
<url>
Tag to insert background’s picture in HTML.
<bgimg>
<body image>
body background
<background src>
Function in Excel filter, which shows text finishes with letter “z”?
begins with z
end with z
match z
contains z
Function in Excel filter, which shows text starts with letter “a”?
begins with a
starts from a to z
end with a
filter A
The valid format of MS Word is
.xlsx
.doc
.pptx
The valid format of MS Excel is
.doc
.xls
.ppt
.txt
Line spacing is in the ____ of MS Word Home Tab.
Font group
Paragraph group
Styles group
Editing group
Arial, Cambria, Verdana, Times New Roman are the name of ____
Font size
Font style
Font face
Font color
Which file format cannot be added to a Word document using Special Paste?
.jpg
.gif
.ppz
.bmp
Which of the following is not an option in clipboard?
Paste
Cut
Copy
Page setup
We can insert a page number at both
Left and Right
Top and Bottom
Footer only
Header only
We can remove / hide border of a shape by selecting … no border
remove shape
border none
no border
delete border
Google Docs is most similar to which application? MS Word
Excel
MS Word
PowerPoint
Paint
Google Sheets is most similar to which application?
Word
MS Excel
PowerPoint
Access
Google Slides is most similar to which application?
Word
Excel
MS PowerPoint
OneNote
Google Docs allows you to insert or upload images from which source(s)?
Device only
Web only
Google Drive only
All of them
To add text boxes or shapes to your document, you will need to ________. insert a special character
insert a special character
enable ruler
use page layout
format tab
Year of invention of the telegraph?
1820
1850
1837
1845
Year of invention of the telephone?
1870
1876
1880
1865
When did World Wide Web introduce?
1989
1990
1991
1995
When does IBM announce its Systems Network Architecture (SNA)?
1970
1974
1975
1980
The electronic transmission of signals for communications
Telephone, Radio, television
Phone, Internet, Email
Signal, Cable, Satellite
Wifi, Router, Fiber
What does share hardware, programs, and databases across the organization?
Server
computer network
Switch
Cloud
What Internet networking technologies are being used as technology platform
TCP/IP
web browser suites, html
Network cables
OSI model
First ARPANET appeared in …
1965
1969
1971
1970
First e-mail program created in ...
1970
1971
1975
1973
ARPANET stopped to exist in …
1991
1990
1995
1989
How many generations of computers you now?
4
5
3
6
The third generation of computers covers the period:
1960-1965
1965-1970
1970-1980
1955-1960
First generation computers are characterized by
Vacuum tubes and magnetic drum
Transistors
Microchips
Silicon
The transistorized computer circuits were introduced in the 1950 or Second generation computer
First generation
Second generation computer
Third generation
Fifth generation
Integrated circuit (ICs) as basic electronic component (SSIC and MSIC) THIRD Generation of Computers
Fourth
Second
THIRD Generation of Computers
Fifth
The monitor of a computer is connected to it by
Bluetooth
cable
Wireless
Infrared
Which of the following is still useful for adding numbers?
abacus
calculator
computer
notepad
When was built the first computer and how is called?
In the 1940's, ENIAC
1930, UNIVAC
1950, Z1
1920, ABC
Computer understands _________________ language binary or machine
Assembly
C++
binary or machine
English
Which of the following are file extensions for text editor files?
.doc
.txt
.xls
.html
What does ICT stand for?
International Communication Technology
Internet and Computer Technology
Information and Communication Technology
Internal Computer Terminal
What is the main function of an operating system?
Design web pages
Manage hardware and provide services for applications
Type documents
Provide internet services
Which of the following is an example of hardware?
Microsoft Word, Excel
CPU, monitor, keyboard
Google Chrome, Firefox
Wi-Fi connection
What is the primary purpose of a database?
Send emails
Store, organize, and manage data
Design websites
Connect to networks
What does CPU stand for?
Central Power Unit
Core Processor Unit
Central Processing Unit
Central Programming Unit
Which one of the following is an example of cloud storage?
Google Drive, Dropbox
USB Flash Drive
Local Disk (C:)
DVD-ROM
Which one of the following is an example of cloud storage?
Google Drive, Dropbox
USB Flash Drive
Local Disk (C:)
DVD-ROM
What is the full form of Wi-Fi?
Wireless Fiber
Wireless Fidelity
Wired File
Wide Frequency
What does a firewall do?
Monitors and controls network traffic for security
Heats up the computer
Connects printers
Formats hard drives
What is malware?
Machine learning software
Email tool
Malicious software (e.g., viruses, spyware)
Hardware management system
Which one of these is an operating system?
Windows, macOS, Linux
Excel
What is the role of a router in a network?
Stores files
Directs data between networks and connects to the internet
Charges devices
Translates languages
What does DNS stand for?
Digital Network System
Domain Name System
Data Navigation Server
Dynamic Name Software
Which of the following is NOT a type of computer memory?
RAM
ROM
CPU
Cache
What is the primary function of a web browser?
Retrieve and display web pages
Design databases
Manage user accounts
Protect against viruses
What is cloud computing?
Sharing files via Bluetooth
On-demand internet-based computing services
Installing software
Coding mobile apps
Which of the following is a search engine?
Google, Bing
Windows
Outlook
Which programming language is widely used for web development?
HTML, CSS, JavaScript
Python, Java
C++, C#
SQL
What is the main function of RAM in a computer?
Temporary data storage for fast access
Permanent storage of files
Managing emails
Connecting devices
What is a domain name?
IP address
Human-readable website address (e.g., example.com)
Folder on desktop
Cloud storage unit
What does HTML stand for?
Hyperlink Text Management Language
HighText Machine Language
HyperText Markup Language
Home Tool Markup Language
What is the primary function of an antivirus program?
Manage internet connections
Detect and remove malware
Open documents
Monitor screen brightness
What is a VPN (Virtual Private Network)?
Very Private Node
Virtual Public Net
Virtual Private Network
Visual Protocol Network
What is the function of a modem?
Modulates and demodulates signals for internet access
Stores website data
Encrypts hard drives
Connects USB devices
Which of the following is a type of software?
Keyboard
Monitor
Operating systems, applications, utilities
Cable
What is a "cookie" in the context of web browsing?
Small data stored by websites to track user activity
A snack you eat while browsing
Computer hardware
Network connector
What does IoT stand for?
Internet of Technology
Interface of Tools
Internet of Things
Input of Transmissions
What is a URL shortener used for?
Create new websites
Creates short versions of long URLs
Delete spam emails
Store passwords securely
What is the function of a database management system (DBMS)?
Create websites
Connect printers
Manage and organize databases
Edit videos
What is e-commerce?
Programming language
Buying and selling goods/services online
Editing documents
Playing online games
What is the main difference between RAM and ROM?
RAM is volatile, ROM is non-volatile
RAM is hardware, ROM is software
RAM stores videos, ROM stores images
RAM is slower than ROM
What is an algorithm?
A type of virus
A file format
Step-by-step procedure for solving a problem
Computer part
Which of the following is NOT a function of a network?
Word processing
Data sharing
Communication
Resource sharing
What does the term “bandwidth” refer to in networking?
Screen size
Maximum data transfer rate of a network
File compression tool
Antivirus feature
What is encryption?
Secures data by converting it into an unreadable format
Deletes temporary files
Creates backups
Makes the screen brighter
What is a spreadsheet used for?
Designing websites
Data organization and analysis
Drawing diagrams
Editing images
What is a blog?
Regularly updated website with informal content
Programming code
Online game
Email client
What is the function of a computer's motherboard?
Display graphics
Connects and allows communication between components
Stores internet history
Charges the battery
What is SEO (Search Engine Optimization)?
Search Engine Optimization (improves web visibility)
Software Engineering Organization
Secure Email Option
System Error Output
Which of these is a type of online transaction?
B2B, B2C, C2C
ISP
HTML
What does the term "big data" refer to?
Small files on a computer
Deleted information
Large and complex datasets requiring advanced processing
Basic operating systems
What is a system analyst responsible for?
Repairing hardware
Analyzing business needs and designing IT solutions
Writing novels
Playing games
What is Bluetooth used for?
Watching TV
Short-range wireless communication
Antivirus scanning
Printing documents remotely
Which of the following is a common web development language?
Python, C++, Java
Excel, Access
HTML, CSS, JavaScript, PHP
Google, Yahoo
What is the purpose of the "cloud" in cloud computing?
Create rain simulations
Remote access to computing resources and services
Increase processor speed
Store videos offline
What is the difference between a static and a dynamic website?
Static shows fixed content; dynamic changes based on user input
Static uses Wi-Fi; dynamic uses LAN
Static needs no hosting
Dynamic is slower
What is a search engine?
Software that retrieves information from the internet (e.g., Google)
A printer
A spreadsheet
A keyboard
What is the purpose of a backup in data management?
Slow down the system
Protect data against loss or corruption
Delete unnecessary files
Share internet
What is the purpose of a printer in computing?
Clean viruses
Display websites
Produces hard copies of digital documents
Increase screen brightness
What does a computer virus do?
Malicious software designed to harm or disrupt systems
Cleans your hard drive
Speeds up internet
Helps organize files
