Font size
WorksheetsUntitled Quiz
Total questions: 152
Worksheet time: 1hrs 16mins
A monitor displays information.
Input
Storage
Output
Processing
A microphone is used an input device.
Input
Output
Storage
Control
The binary equivalent of the Octal number 13 is
1011
1101
1001
1110
Which of the following are file extensions for audio files?
.jpg, .png
.txt, .docx
.mp3, .wav
.html, .css
What software is needed to create slideshows?
Microsoft PowerPoint
Microsoft Word
Microsoft Excel
Notepad
Which of the following would you use to find information on the internet?
Web browser
Word processor
Spreadsheet
Presentation software
Presentation Graphics may contain
Only text
Only images
Text, images, audio, video
Only tables
Most popular Spreadsheet Editor
Microsoft Excel
Microsoft Word
Adobe Photoshop
Microsoft Access
Create text-based documents, reports, letters, and memos
Word processor
Spreadsheet
Database
Presentation software
The computer translates the condition of each switch to a number. What number is represented by the OFF state?
0
1
2
-1
What is Computer software?
A set of instructions and programs that tell the computer what to do.Programs and applications
The physical parts of a computer that you can touch.Physical parts of a computer
Electrical power supplied to the computer.Cables and wires
Data stored in files only.Electronic circuits
What is Computer hardware?
The physical components of the computer system
Programs and applications running on the computer
Network services provided over the internet
Binary data processed by the CPU
Terabyte (TB) =
1024 GB
100 GB
1024 MB
1,000,000 KB
Kilobyte (KB) =
1024 bytes
100 bytes
1024 bits
8 bytes
Short cut key for Bold is
Ctrl+B
Ctrl+I
Ctrl+U
Ctrl+Shift+B
The smallest measurement of memory is
Bit
Byte
Kilobyte
Nibble
Short cut key for Copy is
Ctrl+C
Ctrl+X
Ctrl+V
Ctrl+Z
Short cut key for Undo is
Ctrl+Z
Ctrl+Y
Ctrl+U
Ctrl+Shift+Z
Short cut key for Cut is
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+A
How many bits is a byte?
8
4
16
2
Which of these is a valid e-mail address?
alex@example.com
alex.example.com
alex@exam_ple
@example.com
Convert hexadecimal value 16 to decimal
22
16
26
20
You can take a selection that you have cut or copied from the clipboard and ___ it into a document
paste.Insert copied or cut data
save.Move data
delete.Delete data
close.Format text
Short cut key for Paste is
Ctrl+V
Ctrl+P
Ctrl+C
Ctrl+Shift+V
Times New Roman, Comic Sans and Calibri are called __
fonts
files
icons
protocols
What happens in a document when the "cut" command is used?
The selection is removed and placed on the clipboard
The selection is copied but remains in place
The selection is deleted permanently with no clipboard copy
The document is printed
Which of the following is not currently a topic in computer science?
Ancient history
Algorithms
Operating systems
Data structures
The 0 and 1 in the binary numbering system are called binary digits or
bits
bytes
nibbles
words
The binary equivalent of the Hexadecimal number 74A is
011101001010
011010011010
011111001010
010101001010
Why we need a program Excel?
To organize data and perform calculations using spreadsheets
To edit photos and graphics
To compile source code into machine language
To browse the internet
The binary equivalent of the Hexadecimal number 7BD is
011110111101
011100111101
011110101101
011111111101
The computer translates the condition of each switch to a number. What number is represented by the ON state?
1
0
2
-1
What is the meaning of "$" in the program Excel
It fixes the referenced row or column to create an absolute reference
It multiplies two numbers
It denotes currency formatting only
It inserts a function automatically
To make a cell ABSOLUTE address, we should..
Place $ before the column and/or row in the reference
Start the reference with #
Type the word ABSOLUTE before the address
Use parentheses around the cell address
What is the meaning of "C$5" in the program Excel
Column C is relative and row 5 is absolute
Column C is absolute and row 5 is relative
Both column C and row 5 are absolute
Both column C and row 5 are relative
What "Master function" button used for in the Excel?
To insert and select functions for calculations FX
To sort data ascending AUTOFILL
To format cells as currency SUM
To create charts automatically SORT
What "Master function" button used for in the Excel?
To insert and select functions for calculations ,Fx
To sort data ascending,SORT
To format cells as currency,SUM
To create charts automatically,AutoFill
Choose the right cell address
B12
1B2
BB
B0
Choose the right cell address
C5
5C
CC
C0
What is MIN() function
Returns the smallest value in a set of numbers
Returns the largest value in a set of numbers
Returns the average of numbers
Counts non-empty cells
What is MAX() function
Returns the largest value in a set of numbers
Returns the smallest value in a set of numbers
Returns the average of numbers
Counts non-empty cells
What is AVERAGE() function
Returns the mean of a set of numbers
Returns the largest value in a set of numbers
Returns the smallest value in a set of numbers
Returns the sum of numbers only
Before we start writing any formula to a cell, we select it and press the symbol....
=
+
;
?
Choose wrong expression in the Excel
=A1+B1
=SUM(A1:B1)
A1B1
=A1*B1
Choose right expression in the Excel
=A1+B1
A1++B1
SUM(A1,,B1)
A1**B1
What will we get in cell A3, if the cells are A1=500; A2=450, then select these two cells and use autofill?
400
450
500
350
What will we get in cell A3, if the cells are A1=300; A2=350, then select these two cells and use autofill?
400
350
300
450
Can a cell be transferred from horizontal position to vertical in the Excel?
Yes
No
Only texts
Only numbers
What kind of address C C$1 is
Relative cell reference
Absolute cell reference
Mixed reference with absolute row
Mixed reference with absolute column
What kind of address C$1 is
Relative cell reference
Absolute cell reference
Mixed reference with absolute row
Mixed reference with absolute column
What kind of address $C1 is
Relative cell reference
Absolute cell reference
Mixed reference with absolute row
Mixed reference with absolute column
What kind of address C1 is
Relative cell reference
Absolute cell reference
Mixed reference with absolute row
Mixed reference with absolute column
##### means
The cell contains a formula error
The column is too narrow to display the cell content
The workbook is protected
The cell format is set to Text
In order to multiply items in Excel you would use
The PRODUCT function *
The SUM function -
The AVERAGE function=
The CONCAT function/
If cells A1=90; A2=85; A3=80; A4=75; A5=75, what will be your formula if you are going to get the total? Choose INCORRECT answer!
=SUM(A1:A5)
=A1+A2+A3+A4+A5
=AVERAGE(A1:A5)
=SUM(A1;A5)+SUM(A2:A4)
The value in cell E10 = 75. If student's mark (E10) is higher than 74, the results will be "PASSED" or "FAILED". Possible correct formula:
=IF(E10>74,"PASSED","FAILED")
=IF(E10>=75,"FAILED","PASSED")
=IF(E10<74,"PASSED","FAILED")
=IF(E10>74;PASSED;FAILED)
E-Government portal of Kazakhstan
egov.kz
gov.kz
e-kaz.kz
kazgov.kz
EDS stands for
Electronic data storage
Electronic digital signature
Encrypted document service
Enterprise directory system
HTML stands for
HyperText Modeling Language
HyperTransfer Markup Language
HyperText Markup Language
Hyperlink Text Management Language
… determines that the document background is yellow and the text will be blue (HTML)
<body bgcolor="yellow" text="blue">
<body bg="yellow" color="blue">
<font yellow blue>
<html style>
… determines that the document background is an image and the text will be red (HTML)
<body image="img.jpg">
<img background>
<body background="img.jpg" text="red">
<bg img>
How to identify the numbered and unnumbered lists (HTML)
<li>
<p>
<ol> and <ul>
<br>
How to identify the italic and bold text (HTML)
<u> <p>
<i> <b>
<font>
<strong> only
How to identify the Headers of paragraph (HTML)
<p>
<head>
<h1>–<h6>
<title>
How to identify the beginning of a new paragraph (HTML)
<div>
<br>
<p>
<hr>
How to insert a hyperlink to a document of this type to Task1.html (HTML)
<a src="Task1.html">
<a href="Task1.html">
<link Task1.html>
<link =Task1.html>
In the HTML every code called as
element
tag
script
block
This diagram is used as a tool to visualize the workflow
Network diagram
Flowchart
Entity-relationship diagram
Histogram
… is a computer file created using a special hypertext markup language HTML
Web server
Web browser
Web page
Web cache
Web-site …
is a single document stored on a computer
is a collection of related web pages under one domain name
is a program to view web pages
is a protocol used to transfer files
What is identifying a resource, provides information on the location of this resource?
IP address
URL
DNS
URI scheme
Choose tags to create a table in HTML
<table> <tr> <td>
<ul> <li>
<p> <br>
<div>,
Choose tags to enter the window’s title in HTML
<head>
<meta>
<title>
<body>
… - application layer protocol of data transmission
TCP
IP
HTTP
FTP
… - standardized markup language for documents on the world wide web
CSS
XML
HTML
HTTP
… - technology of description of the appearance of a document executed by the markup language
JavaScript
CSS
XML
HTTP
… is the integrated mechanism of interaction between the state and citizens, state agencies with each other, ensuring consistency with the help of informational technologies
E-commerce
E-government
Social network
Cloud computing
What is PowerPoint?
A database management system
A spreadsheet application
A presentation program
A web browser
PowerPoint can be used to
Design and deliver slide-based presentations
Edit raster images
Develop database schemas
Write and compile code
In what mobile generation was appeared Wi‑Fi technology?
1G
2G
3G
4G
Android is best classified as one of the fastest growing of these
Programming languages
Mobile operating systems
Web browsers
Database systems
How much space Google gives users as free
5 GB
10 GB
15 GB
50 GB
Conversion of a hexadecimal number 3D to binary number is
00111101
11011100
101101
111101
The decimal equivalent of the binary number 100101 is
35
36
37
38
Conversion of an octal number 106 to binary number is
1100010
1000110
1010110
1100110
Conversion of an octal number 73 to binary number is
111010
111011
110111
101111
The decimal equivalent of the binary number 1010100 is
72
80
84
90
Conversion of a hexadecimal number D8 to binary number is
11011000
11001000
10111000
11101000
The octal equivalent of the number 10011.1101 is
23.61
23.64
26.34
21.64
The decimal equivalent of the binary number 101011 is
41
42
43
44
HTML file’s type
.docx
.pptx
.html
.css
Format of the HTML document
Binary
Audio
Markup
Graphic
… - is a program to create video
Windows Movie Maker
Adobe Acrobat Reader
Notepad
WinZip
Select the function to display records that meet certain criteria in Excel
Sort
Filter
Freeze Panes
Find & Replace
Find the NAME whose 2nd letter is “m” using the text filter in Excel
Use begins with m
Use equals m*
Use contains m
Use pattern ?m*
Tag for background’s color of the document in HTML
<bg>
<color>
<body bgcolor="">
<font>
An example of numbered list in HTML.
<ul><li>One</li></ul>
<ol><li>One</li></ol>
<li>One</li>
<list>
Tag of unnumbered list in HTML.
<ol>
<li>
<ul>
<p>
Tag for the first level, size of words in HTML.
<h1>
<h2>
<h3>
<h4>
Tag for the second level, size of words in HTML.
<h1>
<h2>
<h3>
<h4>
Tag for the third level, size of words in HTML.
<h2>
<h3>
<h4>
<h5>
Tag for the fourth level, size of words in HTML.
<h5>
<h2>
<h3>
<h4>
Tag for the fifth level, size of words in HTML.
<h3>
<h4>
<h5>
<h6>
Tag for the sixth level, size of words in HTML.
<h3>
<h4>
<h5>
<h6>
Tag for italic words in HTML.
<b>
<u>
<i>
<emph>
Tag for bold words in HTML.
<emph>
<m>
<u>
<b>
Tag for underline words in HTML.
<i>
<u>
<line>
<h>
Tag for superscript words in HTML.
<sub>
<sup>
<small>
<top>
Tag for subscript words in HTML.
<sub>
<low>
<down>
<top>
Tag for beginning of a new paragraph in HTML.
<p>
<br>
<div>
<top>
Tag for scrolling text in HTML.
<scroll>
<move>
<marquee>
<slide>
Tag to insert picture in HTML.
<picture>
<img>
<src>
<photo>
Tags to skip three lines in HTML.
<br><br>
<p>
<br><br><br>
<hr>
Tags to skip two lines in HTML.
<hr>
<br>
<br><br>
<br>
Tags to skip four lines in HTML.
<br><br>
<br>
<br><br><br><br>
<hr>
Tag to insert a hyperlink in HTML.
<link>
<url>
<a>
<href>
Tag to insert background’s picture in HTML.
<img bg>
<body background="">
<background>
<bg>
Function in Excel filter, which shows text finishes with letter “z”?
Ends With "z" *z
Begins With "z"z*
Contains "z"?z
Equals "z"z
Function in Excel filter, which shows text starts with letter “a”?
Begins With "a"
Ends With "a"
Contains "a"
Equals "a"
The valid format of MS Word is
.docx
.xlsx
.pptx
The valid format of MS Excel is
.xlsx
.docx
.pptx
.txt
Line spacing is in the ____ of MS Word.
Paragraph
Font
Styles
Review
Arial, Cambria, Verdana, Times New Roman are the name of ____.
fonts
paragraphs
templates
styles
Which file format cannot be added to a Word document using Special Paste?
PDF video
Unformatted Text
HTML Format
Picture (Enhanced Metafile)
Which of the following is not an option in clipboard?
Paste All
Clear All
Options
We can insert a page number at
Insert tab Header or Footer
Home tab Body only
Design tab Title only
View tab Margins
We can remove / hide border of a shape by selecting …
No Outline
No Fill
Transparent Border
Remove Fill
Google Docs is most similar to which application?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
Google Sheets is most similar to which application?
Microsoft Excel
Microsoft Word
Microsoft PowerPoint
Microsoft Access
Google Slides is most similar to which application?
Microsoft PowerPoint
Microsoft Word
Microsoft Excel
Microsoft Access
Google Docs allows you to insert or upload images from which source(s)?
Only from a scanner
Only from Google Drive
Only from a computer
From multiple sources (computer, Drive, web, URL
To add text boxes or shapes to your document, you will need to ________.
insert a drawing
turn on spell check
create a table
use headers and footers
Year of invention of the telegraph?
1837
1876
1946
1969
Year of invention of the telephone?
1876
1837
1946
1969
When did World Wide Web introduce?
1991
1989
1995
2004
When does IBM announce its Systems Network Architecture (SNA)?
1974
1969
1983
1991
The electronic transmission of signals for communications
telecommunication
compilation
computation
standardization
What does share hardware, programs, and databases across the organization?
computer network
operating system
compiler
printer
What Internet networking technologies are being used as technology platform?
TCP/IP
SMTP
FTP
SQL
First ARPANET appeared in …
1969
1971
1990
1991
First e-mail program created in….
1971
1969
1983
1990
ARPANET stopped to exist in …
1990
1983
1974
1991
How many generations of computers you now?
five
three
four
six
The third generation of computers covers the period:
1965–1971
1946–1959
1959–1965
1971–1980
First generation computers are characterized by
vacuum tubes
transistors
integrated circuits
microprocessors
The transistorized computer circuits were introduced in the
second generation
first generation
third generation
fourth generation
Integrated circuit (ICs) as basic electronic component (SSIC and MSIC)
third generation
first generation
second generation
fourth generation
The monitor of a computer is connected to it by a
VGA cable
USB cable
RJ-45 cable
parallel cable
Which of the following is still useful for adding numbers?
abacus
typewriter
joystick
modem
When was built the first computer and how is called?
ENIAC, built in 1945
Colossus, built in 1943
Z3, built in 1941
IBM PC, built in 1981
Computer understands ______ language.
machine language
natural language
high-level language
assembly language
Text editor file extensions
.jpg, .png
.exe, .dll
.txt, .docx
.mp3, .wav
