NEW
Font size
Worksheets50-100
Total questions: 50
Worksheet time: 25mins
51. WHAT KIND OF ADDRESS C1 IS
Relative address
Absolute address
Mixed address
###### MEANS
It indicates the value is too large for the cell
It indicates the cell is too narrow to display the value
It means the value is incorrect
53. IN ORDER TO MULTIPLY ITEMS IN EXCEL YOU WOULD USE
/
*
%
54. 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
=TOTAL(A1:A5)
=SUM(A1,A2,A3,A4,A5)
55. THE VALUE IN CELL E10 = 75, IF THE 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,“PASSED”,“FAILED”)
=IF(E10<75,“PASSED”,“FAILED”)
=IF(E10<74,“PASSED”,“FAILED”)
56. E-Government portal of Kazakhstan is used for:
Social media
Online shopping
Government services
Music streaming
57. EDS STANDS FOR …
Electronic Data System
Enhanced Digital Security
Electronic Digital Signature
Easy Data Storage
HTML STANDS FOR …
Hyper Transfer Markup Language
HyperText Markup Language
High Text Markup Language
59. … DETERMINES THAT THE DOCUMENT BACKGROUND – YELLOW COLOR AND THE TEXT WILL BE BLUE (HTML):
<body style="background-color: yellow; color: blue;">
<body ="background-color: yellow; color: blue;">
<body style="background-: yellow; color: blue;">
<body style="background-color: yellow; color: ;">
60.… determines that the document background – image type and the text will be red (HTML)
<body style="background-image: url('image.jpg'); color: red;">
<body style="background-image: url('image.jpg'); color: blue;">
<body style="background-image: url('color.jpg'); color: red;">
61. How to identify the numbered and unnumbered lists (HTML)
Numbered list: <ol>, Unnumbered list: <ul>
Numbered list: <li>, Unnumbered list: <li>
Numbered list: <ul>, Unnumbered list: <ol>
62. How to identify the italic and bold text (HTML)
Italic: <b> or <strong>, Bold: <i> or <em>
Italic: <i> or <strong>, Bold: <b> or <em>
• Italic: <i> or <em>, Bold: <b> or <strong>
63. How to identify the Headers of paragraph (HTML)
<p>, <q>, <b> for paragraphs
<h1>, <h2>, <h3> only
<h1>, <h2>, …, <h6> for different header levels
64. How to identify the beginning of a new paragraph (HTML)
• <p>
<body>
<h1>
65. How to insert a hyperlink to a document of this type to Task1.html (HTML)
<a href="Task2html">Link to Task1</a>
<a href="Task1.html">Link to Task1</a>
<a href="Task1.html">Link to Task1<
66. In the HTML every code called as …
A tag
A function
An element
A property
67. This diagram is used as a tool to visualize the workflow
Bar chart
Pie chart
Flowchart
68. … is a computer file created using a special hypertext markup language HTML
.html or .htm file
.txt file
pdf file
.doc file
69. Web-site …
A single web page
A collection of web pages
A database
70. What is identifying a resource, provides information on the location of this resource?
URL
IP address
DNS
71. Choose tags to create a table in HTML?
<table>, <tr>, <td>
<table>, <td>, <th>
<table>, <td>, <tr>
72. Choose tags to enter the window’s title in HTML?
<head>
<title>
<window>
73. … - application layer protocol of data transmission
HTTP
HPPT
SMTP
HHP
74. … - standardized markup language for documents on the world wide web.
HTML
HTL
CSS
75. … - technology of description of the appearance of a document executed by the markup language
CSS
HTML
JavaScript
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.
E-Government
Social network
Cloud computing
Digital marketing
77. What is PowerPoint?
A video editing software
A spreadsheet software
A presentation software
A word processor
78. PowerPoint can be used to:
Create websites
Create slideshows for presentations
Edit photos
Write code
79. In what mobile generation was Wi-Fi technology appeared?
1G
2G
3G
4G
80. Android is best classified as one of the fastest growing of these
Operating systems
Web browsers
Gaming consoles
Networking protocols
81. How much space Google gives users as free?
5 GB
15 GB
50 GB
100 GB
82. Conversion of a hexadecimal number 3D to binary number is
B. 0001 1111
C. 0101 1101
A. 0011 1101
83. The decimal equivalent of the binary number 100101 is
40
37
45
57
84. Conversion of an octal number 106 to binary number is:
010 001 110
001 000 110
100 010 111
111 000 111
Conversion of an octal number 73 to binary number is:
001 111 011
0101 1101
000 111 011
1111 0011
86. The decimal equivalent of the binary number 1010100 is:
42
80
84
70
87. Conversion of a hexadecimal number D8 to binary number is
1101 1000
1110 1000
1100 1010
1001 1000
88. The octal equivalent of the number 10011.1101 is
225.75
234.64
210.52
243.45
89. The decimal equivalent of the binary number 101011 is
43
45
50
56
90. HTML file’s type?
.html or .htm
.txt
.css
.js
91. Format of the HTML document
Starts with <!DOCTYPE html>
Starts with <html>
Starts with <head>
Starts with <body>
92. … - is a program to create video.
PowerPoint
Photoshop
Video editing software
Illustrator
93. Select the function to display records that meet certain criteria in Excel.
VLOOKUP
Filter
SUM
CONCATENATE
94. Find the NAME whose 2nd letter is “m” using the text filter in Excel
“?m?”
“m”*
“m?”
95. Tag for background’s color of the document in HTML?
<bgcolor>
<body style=“background-color:color,”>
<background>
<body bg="color">
96. an example of numbered list in HTML.
<ol><li>Item 1</li><li>Item 2</li></ol>
<ul><li>Item 1</li><li>Item 2</li></ul>
<list><item>Item 1</item><item>Item 2</item></list>
<ol><item>Item 1</item><item>Item 2</item></ol>
97. Tag of unnumbered list in HTML.
<ol>
<ul>
<li>
<list>
98. Tag for the first level, size of words in HTML.
<h1>
<h3>
<h2>
98. Tag for the second level, size of words in HTML.
<h1>
<h2>
<h3>
<h4>
100. Tag for the third level, size of words in HTML.
<h1>
<h2>
<h3>
<h4>
