ИКТ СЕССИЯ
<1>A monitor displays information...true/false true
<2>A microphone is used an input device...true/false true
<3>The binary equivalent of the Octal number 13 is 1011
<4>Which of the following are file extensions for audio files? .mp3
<5>What software is needed to create slideshows? MS PowerPoint
<6>Which of the following would you use to find information on the internet? Search Engine
<7>Presentation Graphics may contain All of this
<8>Most popular Spreadsheet Editor MS Excel
<9>Create text-based documents, reports, letters, and memos Google Docs, MS Word
<10>The computer translates the condition of each switch to a number. What number is represented by
the OFF state? 0
<11>What is Computer software? It is the application of computers to store, study, retrieve, transmit, and
manipulate data
<12>What is Computer hardware? It is the transmission of signs, signals, messages, writings, images and
sounds
<13>Terabyte (TB) = 1024 Gigabytes
<14>Kilobyte (KB) = 1024 Kilobytes
<15>Short cut key for Bold is Ctrl+B
<16>The smallest measurement of memory is Bytes
<17>Short cut key for Copy is Ctrl+C
<18>Short cut key for Undo is Ctrl+Z
<19>Short cut key for Cut is Ctrl+X
<20>How many bits is a byte? 8 bits
<21>Which of these is a valid e-mail address? professor@learnthenet.com
<22>Convert decimal value 16 to hexadecimal 10
<23>You can take a selection that you have cut or copied from the clipboard and___it into a document
paste
<24>Short cut key for Paste is Ctrl+V
<25>Times New Roman, Comic Sans and Calibri are called__ Fonts
<26>What happens in a document when the "cut" command is used? The selected text or graphics will be
cut out.
<27>Which of the following is not currently a topic in computer science? Thermodynamics
<28>The 0 and 1 in the binary numbering system are called binary digits or bits
<29>The binary equivalent of the Hexadecimal number 74A is 11101001010
<30>Why we need a program Excel? Processing an electronic table
<31>The binary equivalent of the Hexadecimal number 7BD is 11110111101
<32>The computer translates the condition of each switch to a number. What number is represented by
the ON state? 1
<33>What is the meaning of "$" in the program Excel In the process of copying, not to change the cell
address
<34>To make a cell ABSOLUTE address, we should.. Put the symbol "$" at the end of cell address
<35>What is the meaning of "C$5" in the program Excel When copying a formula, changing only
column's address
<36>What "Master function" button used for in the Excel? Insert functions, which quickly and easily
predefined formulas
<37>Choose the right cell address BB1
<38>Choose the right cell address A2
<39>What is MIN() function Returns the smallest number in a set of values
<40>What is MAX() function Returns the biggest number in a set of values
<41>What is AVERAGE() function Returns the average (arithmetic mean) of the arguments
<42>Before we start writing any formula to a cell, we select it and press the symbol.... =
<43>Choose wrong expression in the Excel 50x10
<44>Choose right expression in the Excel A3*10
<44>What will we get in cell A3, if the cells are A1=500; A2=450, then select these two cells and use
autofill? 400
<45>What will we get in cell A3, if the cells are A1=300; A2=350, then select these two cells and use
autofill? 400
<46>Can a cell be transferred from horizontal position to vertical in the Excel? Yes, go to the field
orientation and change position to 90° in Alignment tab
<47>What kind of address $C$1 is absolute
<48>What kind of address C$1 is mixed
<49>What kind of address $C1 is mixed
<50>What kind of address C1 is relative
<51>###### means: You have entered a wrong number
<52>In order to multiply items in Excel you would use: *
<53>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)
<54>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")
<55>E-Government portal of Kazakhstan egov.kz
<56>EDS stands for … Electronic Digital Signature
<58>HTML stands for … Hyper Text Markup Language
<59>…determines that the document background – yellow color and the text will be blue (HTML) <body
bgcolor = yellow text = blue>
<60>…determines that the document background –image type and the text will be red (HTML) <body
bgcolor = "image.jpg" text = red>
<61>How to identify the numbered and unnumbered lists (HTML) OL AND UL
<62>How to identify the italic and bold text (HTML) <I>….</ I> and <B> …. </B>
<63>How to identify the Headers of paragraph (HTML) <H1>…</ H1> and <H2>…</ H2>
<64>How to identify the beginning of a new paragraph (HTML) <BR>…. <BR>
<65>How to insert a hyperlink to a document of this type to Task1.html (HTML)
<A HREF="Task1.html">TEXT</A>
<66>In the HTML every code called as … tags
<67>This diagram is used as a tool to visualize the workflow Gantt chart
<68>… is a computer file created using a special hypertext markup language HTML. Web-page
<69>Web-site …collection of web pages, which are united by some principle
<70>What is identifying a resource, provides information on the location of this resource? URL
<71> Choose tags to create a table in HTML?
TABLE, TR, TD
<72> Choose tags to enter the window’s title in HTML? HEAD, TITLE
<73>… - application layer protocol of data transmission. Hypertext transfer protocol (http)
<74>… - standardized markup language for documents on the world wide web. Hypertext markup
language (html)
<75>… - technology of description of the appearance of a document executed by the markup language.
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. Electronic government
<77>What is PowerPoint?
It is a computer program that allows you to create and show slides to support a presentation.
<78>PowerPoint can be used to: organise and structure your presentation.
<79>In what mobile generation was appeared Wi-Fi technology? 4G
<80> Android is best classified as one of the fastest growing of these mobile operating systems
<81>How much space Google gives users as free? 15GB
<82>Conversion of a hexadecimal number 3D to binary number is 111101
<83>The decimal equivalent of the binary number 100101 is 37
<84>Conversion of an octal number 106 to binary number is 1000110
<85>Conversion of an octal number 73 to binary number is 111011
<86>The decimal equivalent of the binary number 1010100 is 84
<87>Conversion of a hexadecimal number D8 to binary number is 11011000
<88>The octal equivalent of the number 10011.1101 is 23.64
<89>The decimal equivalent of the binary number 101011 is 43
<90> HTML file’s type? text editor or <input type="file">
<91> Format of the HTML document. .html
<92> … - is a program to create video. WS Movie Maker
<93>Select the function to display records that meet certain criteria in Excel. filter
<94> Find the NAME whose 2nd letter is “m” using the text filter in Excel. equals ?m*
<95> Tag for background’s color of the document in HTML? BODY BGCOLOR
<96> an example of numbered list in HTML. <UL>
<97> Tag of unnumbered list in HTML. <OL>
<98> Tag for the first level, size of words in HTML. H1
<99> Tag for the second level, size of words in HTML. H2
<100> Tag for the third level, size of words in HTML. H3
<101> Tag for the fourth level, size of words in HTML. H4
<102> Tag for the fifth level, size of words in HTML. H5
<103> Tag for the sixth level, size of words in HTML. H6
<104> Tag for italic words in HTML. <I>
<105> Tag for bold words in HTML. <B>
<106> Tag for underline words in HTML. <U>
<107> Tag for superscript words in HTML. <sup>
<108> Tag for subscript words in HTML. <sub>
<109> Tag for beginning of a new paragraph in HTML. <BR>
<110> Tag for scrolling text in HTML. The <marquee> tag
<111> Tag to insert picture in HTML. <img src>
<112> Tags to skip three lines in HTML. <BR><BR><BR>
<113> Tags to skip two lines in HTML. <BR><BR>
<114> Tags to skip four lines in HTML. <BR><BR><BR><BR>
<115> Tag to insert a hyperlink in HTML. Type out <a href=" "> and followed by </a>
<116> Tag to insert background’s picture in HTML. body background
<117> Function in excel filter, which shows text finishes with letter “z”? end with z
<118> Function in excel filter, which shows text starts with letter “a”? begins with a
<119>The valid format of MS Word is ___ .doc
<120>The valid format of MS Excel is ___ .xls
<121>Line spacing is in the ____ of MS Word Home Tab
<122>Arial, Cambria, Verdana, Times New Roman are the name of ____ Font face
<122>Which file format cannot be added to a Word document using Special Paste? .ppz
<123>Which of the following is not an option in clipboard? page setup
<124>We can insert a page number at both
<125>We can remove / hide border of a shape by selecting … no border
<126>Google Docs is most similar to which application? MS Word
<127> Google Sheets is most similar to which application? MS Excel
<128> Google Slides is most similar to which application? MS PowerPoint
<129>Google Docs allows you to insert or upload images from which source(s)? All of them
<130>To add text boxes or shapes to your document, you will need to ________. insert a special character
<131> Year of invention of the telegraph? 1837
<132>Year of invention of the telephone? 1876
<133>When did World Wide Web introduce? 1990
<134>When does IBM announce its Systems Network Architecture (SNA)? 1974
<135>The electronic transmission of signals for communications Telephone, Radio, television
<136>What does share hardware, programs, and databases across the organization? computer network
<137>What Internet networking technologies are being used as technology platform web browser suites,
html
<138>First ARPANET appeared in … 1969
<139>First e-mail program created in ... 1971
<140>ARPANET stopped to exist in … 1990
<141>How many generations of computers you now? 5
<142>The third generation of computers covers the period: 1965-1970
<143>First generation computers are characterized by Vacuum tubes and magnetic drum
<144>The transistorized computer circuits were introduced in the 1950 or Second generation computer
<145>Integrated circuit (ICs) as basic electronic component (SSIC and MSIC) THIRD Generation of
Computers
<146>The monitor of a computer is connected to it by a cable
<147>Which of the following is still useful for adding numbers? abacus
<148>When was built the first computer and how is called? In the 1940's, ENIAC
<149>Computer understands _________________ language binary or machine
<150>Which of the following are file extensions for text editor files? .txt