ICT 100 (3)

#290 *!Excel displays the error message ____ in cells to indicate a cell reference error *REF# *REF! *REF *#REF# *#REF!

*+#REF!

#201 *!MS Excel. Number of cells in the following formula: =SUM(А1;С3) *6 *3 *4 *5 *2

*+2

#231 *!The mode of the sample: 1,2,8,2,5,6,2,8,1,2,3,4. *1 *8 *7 *2 *12

*+2

#230 *!The mode of the sample: 1,5,3,5,5,6,6,3,1,2. *3 *7 *6 *1 *5

*+5

#254 *!How in a query it will be correct to specify the following criterion:: «Patient's weight is between 50 and 80» *<80, >50 *<80=>50 *<80 or >50 *less than 80, greater than 50 *less than 80 or not greater than 50

*+<80 or >50

#298 *!The cell A3 contains next formula: =В1+$С1; A3 is copied in A4. The formula in A4 will become *=В1+С$1 *=В2+$С1 *=В1+С$4 *=В1+С$2 *=В2+$С2

*+=В2+$С2

#246 *!Loading viruses can infect: *еxe-files *OBJ-files *сOM-files *batch-files *Boot-Strap program

*+Boot-Strap program

#293 *!MS Excel.Which keyboard shortcut should be used to apply or remove an italic tracing *CTRL+1 *CTRL+2 *CTRL+4 *CTRL+5 *CTRL+3

*+CTRL+3

#210 *!Database management systems *Ms Excel, Supercalc, Turbopascal, Ms Access *Clipper, Paradox, Foxpro, Foxbase, Ms Access *Inereader, Prompt98, Qtrans, Foxbase, Excel, Paradox *Ms Word, Wordperfect, Total Commander, Ms Access *Ms Powerpoint, Ms Access, Outlook Express, Total Commander

*+Clipper, Paradox, Foxpro, Foxbase, Ms Access

#261 *!MSWindows. How to invent start menu *Alt+Esc *Ctrl+Tab *Shift+Esc *Ctrl +Esc *Ctrl+Enter

*+Ctrl +Esc

#213 *!MS Аccess. Short keys of "Minimize and maximize the ribbon" *Shift+F6 *Alt+ Tab *Ctrl+F1 *Shift+Tab *Shift+F10

*+Ctrl+F1

#223 *!MS Power Point. How it's possible to create a uniform appearance by adding a background image to all slides? *Create a template *Edit the slide master *Use the autocorrect wizard *Insert a picture into a slide *Save the presentation as a slide

*+Edit the slide master

#244 *!Doctor Program: *Prevents infection of files *Looks for viruses with the known signature *Finds the infected files and treats them *Finds suspicious actions *Compares an initial condition of the file to current

*+Finds the infected files and treats them

#253 *!The database which can be used in several spheres of human activities *Certain *Universal *Specialized *Generally available *Multiple objective

*+Universal

#257 *!For query design with parameter, displaying a surname of the doctor, it is necessary to type on criteria row: *[Enter surname of the doctor] *(Enter surname of the doctor) *{Enter surname of the doctor} */Enter surname of the doctor/ *<enter surname of the doctor>

*+[Enter surname of the doctor]

#274 *!What general property do the interactive presentations have? *are managed by events *are operated by the speaker *the self-carried-out presentation *are usually shown at different exhibitions *surely the multimedia projector is required

*+are operated by the speaker

#260 *!WindowsXP. Using the mouse to move or copy cells is called *mousing *mouse copy *cut and paste *move and drop *drag and drop

*+drag and drop

#281 *!MS Word 2007. The group symbols is on tab *view *home *insert *references *page layout

*+insert

#209 *!Creating of database *file - create - open the database *edit - create - open the database *toolbar - create the database *"Office" button- create - new database *create - "Office" button- create the database

*+"Office" button- create - new database

#297 *!Excel displays the error message ____ in cells to indicate a divide by zero error *DIV/ # *#DIV/ ! *#VALUE! *DIVIDE# *#REF/DIVBYZER

*+#DIV/ !

#291 *!Excel. The Excel program file has an extension *.txt *.com *.bmp *.docx *.Xlsx

*+.Xlsx

#227 *!Significance level which is used in medicine *1 * *0,95 *0,005 *0,05

*+0,05

#228 *!Level of confidence using in medicine *1 * *0,05 *0,025 *0,95

*+0,95

#225 *!The size of the sample: 1,2,3,7,5,6,6,3,1,2. *3 *7 *6 *12 *10

*+10

#226 *!The size of the sample: 1,2,8,7,5,6,6,8,1,2,3,4. *1 *2 *7 *11 *12

*+12

#229 *!The mode of the sample: 1,2,3,7,5,6,6,8. *1 *2 *7 *6 *10

*+6

#224 *!The size of the sample: 1,2,8,7,5,6,6,8. *1 *2 *7 *9 *8

*+8

#202 *!MS Excel. Number of cells in highlited groupА2:С4 *2 *4 *6 *8 *9

*+9

#295 *!MS Excel. Which keyboard shortcut should be used to fill a range of cells with the same data *<Alt>+<Tab>+<Enter> *<Ctrl>+<Tab>+<Enter> *<Shift >+<Alt>+<Enter> *<Ctrl>+<Shift>+<Enter> *<Ctrl>+<Shift>+<Space Bar>

*+<Ctrl>+<Shift>+<Enter>

#299 *!The cell A3 contains next formula: =$В$1+$С1; A3 is copied in A4.The formula in A4 will become *=В1+С$4 *=В1+С$1 *=$В$1+$С1 *=$В$1+$С2 *=$В$1+$С$2

*+=$В$1+$С2

#296 *!MS Excel. To add two cells (A1 and A2) together you use the following formula *A1 + A2 *A1 plus A2 *=Add(A1+A2) *=sum(A1;A2) *=together(A1:A

*+=sum(A1;A2)

#300 *!The cell A3 contains next formula: =В1+С$1; A3 is moved in A4. The formula in A4 will become *=В2+С$1 *=В2+С$4 *=В1+С$1 *=$В$1+$С1 *=$В$1+$С$2

*+=В2+С$1

#292 *!MS Excel.Which keyboard shortcut should be used to display the format of cells dialog box *CTRL+5 *CTRL+2 *CTRL+3 *CTRL+4 *CTRL+1

*+CTRL+1

#294 *!MS Excel. Which keyboard shortcut should be used to cross out the text or to remove deletion *CTRL+1 *CTRL+2 *CTRL+3 *CTRL+4 *CTRL+5

*+CTRL+5

#250 *!The important future of multimedia technology is: *Animation *Optimization *Multitasking *Interactivity *Duration

*+Interactivity

#249 *!Macro viruses are: *Network files *Package files *Dialogue files *Loading files *Macros

*+Macros

#266 *!MSWindows.Which of the following is an operating system you would be using on the computer *Netscape *Microsoft Excel *Microsoft Word *Internet Explorer *Microsoft Windows

*+Microsoft Windows

#248 *!Auditor programs: *Treat a disk *Use vaccines *Treat all computer *Delete only the infected files of Windows *Remember data on a condition of programs

*+Remember data on a condition of programs

#221 *!MS Power Point. The effect applied to display when slides changes in slide show view is *Shadow effect *Slide Animation *Slide Transition *Custom Animation *Custom Transition

*+Slide Transition

#269 *!How to load anti-virus AVP program: *Start - Programs - Antiviral Toolkit Pro *Start - Programs -Accessories - Service - Disk scanner *Automatically joins with an operating system *Main menu - Programs - AVP *Windows Explorer - Programs - Accessories - Service

*+Start - Programs - Antiviral Toolkit Pro

#247 *!Replicators: *Delete a virus *Transfer a virus *Find a virus *Destroy a virus program *Warning infection with a virus

*+Transfer a virus

#245 *!Infection with loading viruses occurs at: *Closing of the file *Opening of the file *Data recording in the file *Reading of information from the file *Turning on the computer with busy floppy

*+Turning on the computer with busy floppy

#252 *!The hyperlink is: *very big text *any word or any picture *the text using of a big size font *any information in a binary code *a reference to data that the reader can directly follow either by clicking, tapping, or hovering

*+a reference to data that the reader can directly follow either by clicking, tapping, or hovering

#265 *!MSWindows.Which of the following type of objects can you search on your computer and on the network, using Windows XP search companion *pictures *documents *all of these *windows help *people in your contact list

*+all of these

#267 *!AVP is: *the program spreading virus *the program, the pressing the file for saving of the place on a disk *anti-virus program *program of defragmentation *graphics editor

*+anti-virus program

#264 *!MSWindows. Which of the following file name extension suggests that the file is backup copy of another file *txt *bas *exe *com *bak

*+bak

#205 *!MS Access. Group "Forms" is located on tab *home *create *external data *dataheet mode *work with database

*+create

#214 *!МS Аccess. In the working area of Access there are *desktop, task area *menu bar, toolbar *status bar, start button *working area, task panel *database window and its objects windows

*+database window and its objects windows

#212 *!МS Access. Group "Fields&Columns" is located on ___ tab *home *create *external data *datasheet view *data tools

*+datasheet view

#276 *!Medical expert systems: *diagnostic systems of fifth generation *diagnostic systems of first generation *diagnostic systems of third generation *diagnostic systems of second generation *diagnostic systems of fourth generation

*+diagnostic systems of second generation

#243* *!In what case the computer can be infected with virus: *when formatting a disk *when loading of the computer *when testing the computer *at start of the DoctorWeb program *during the work with the infected program

*+during the work with the infected program

#279 *!Are engaged in expert systems: *doctors *experts, students *students and specialists in the field of an artificial intelligence *experts and specialists in the field of an artificial intelligence *experts, specialists in the field of an artificial intelligence, students

*+experts and specialists in the field of an artificial intelligence

#237 *!Doctor-auditors programs: *treat the infected files *modify programs *find changes and treat *find the infected files *only find changes in files

*+find changes and treat

#238 *!Vaccine programs: *treat the infected files *modify programs *find changes and treat *find the infected files *only find changes in files

*+find changes and treat

#219 *!MS Power Point. If you want to insert some slides from other presentation into current one choose *from insert tab choose slides *from insert tab choose slides from files *from insert tab choose slides from presentation *from home tab choose slides from presentation *from view tab change the mode of presentation then add a slide from presentation

*+from insert tab choose slides from files

#232 *!Stealth viruses: *infect drivers *hide their presence *destroy all information *infect boot sectors *display the graphic drawing

*+hide their presence

#283 *!MS Word 2007. The clipboard is on tab *view *insert *home *references *page layout

*+home

#284 *!MS Word 2007. The group font is on tab *view *insert *home *references *page layout

*+home

#285 *!MS Word 2007. The group styles is on tab *view *insert *home *references *page layout

*+home

#272 *!How the computer can be infected a virus: *when loading drivers *when opening the internet *in case of the wrong loading *in case of execution of the infected program *when inserting the disc with the infected program

*+in case of execution of the infected program

#217 *!MS Power Point. Choose model of slide *design - themes and background *format - model of slide *insert - slides - model *insert - duplicate of slide *edit - special insert

*+insert - slides - model

#259 *!Windows XP. A ____ is a pointing device *mouse *CD RW *monitor *keyboard *flash drive

*+mouse

#208 *!MS Access. Logical operator *xor *eqv *null *true *not

*+not

#206 *!MS Access. Queries are divided by a formation method *currency, simple, linear *text, with a parameter, an autoquery, numeric *linear, autoreports, autoforms, simple, dependent *on a sample, with a parameter, crosstab, simple *on circle, the linear, numeric, an autorequest, monetary, the report

*+on a sample, with a parameter, crosstab, simple

#255 *!If criteria are connected with AND, then in query design they register as: *in a total row *in merged row *on different rows *on the same row *after column name

*+on the same row

#215 *!МS Аccess. "Open" command of "Оffice" button allows to *save data in a table *look at data in a table *open the created table *open the «editing» window *open the created database

*+open the created database

#207 *!MS Access. The sequence of commands for formation of queries of the Create tab *list - datasheet *others - report design *others - query design *tables - query design *representation - query design

*+others - query design

#203 *!MS Excel. Samples belong to two different populations if *p<1,00 *p<0,08 *p<0,10 *p<0,50 *p<0,05

*+p<0,05

#204 *!MS Excel. Samples belong to the same population *p<1,00 *p<0,08 *p<0,10 *p<0,50 *p>0,05

*+p>0,05

#286 *!MS Word 2007. The group page setup is on tab *view *home *insert *references *page layout

*+page layout

#211 *!MS Access. To extract necessary data from one or several tables is used *fields *forms *reports *records *queries

*+queries

#240 *!The main two groups of viruses: *network, file *dangerous, not dangerous *loading, dangerous *macro, micro *resident, non-resident

*+resident, non-resident

#287 *!MS Word 2007. The group spelling is on tab *view *home *insert *review *page layout

*+review

#233 *!The way of virus detection includes: *scanning *copying files *heuristic analysis *record of all files volume *checking of executing files

*+scanning

#277 *!Main objective of an artificial intelligence: *separation of the main concepts of problem area *assignment of the main concepts of problem area *saving the main concepts of problem area *simulation of intellectual activities of the person by transmission of a computer *simulation of intellectual activities of the person for transmission of a computer of routine processes

*+simulation of intellectual activities of the person for transmission of a computer of routine processes

#216 *!MS Power Point. Control of slideshow time *slide show - time *slide show - time settings *click on time control label *slide show - animation effects *slide show а -animation settings

*+slide show - time settings

#271 *!Distinctive features of a computer virus are: *ease of recognition *considerable volume of a program code *need of start of the program from the user *ability to increase in a noise stability of an operating system *small volume. ability to independent start and repeated copying of a code, to creation of noise to correct operation of the computer

*+small volume. ability to independent start and repeated copying of a code, to creation of noise to correct operation of the computer

#239 *!The computer virus is: *the program providing compression of files *the program for coercion of the archived file to an initial look *specially written program of small volume which spoils them *the program used for increase in speed of operation of a disc *the program intended for creation of the presentation

*+specially written program of small volume which spoils them

#258 *!Windows XP. The ____ allows you to perform often-used tasks quickly *rulers *status bar *welcome screen *right-click task bar *standard buttons toolbar

*+standard buttons toolbar

#278 *!Systems of an artificial intelligence are: *directions of expert systems *direction of an artificial intelligence *activities, connected to the direction of an artificial intelligence *the machine programs created in the direction of expert systems *the machine programs created in the direction of artificial intellectual systems

*+the machine programs created in the direction of artificial intellectual systems

#222 *!MS Power Point. Characteristic of slide show permission *increases processing rate of a graphics in the presentation *specifies a transition method from one slide to another *the more pixels are, the higher image clarity is *adding of number of a slide or date and time to any place of a slide *sets a method of show of the presentation: controlled by the speaker or user

*+the more pixels are, the higher image clarity is

#220 *!MS Power Point. What happens if you edited an image inserted in PowerPoint? *the original file that was inserted is changed *the original file that was inserted is not changed *the copy of original file that was inserted is changed *the original file is changed when you save presentation *the copy of original file that was inserted is not changed

*+the original file that was inserted is not changed

#270 *!The computer virus is: *the program damaging computer programs and data *programming language *text editor *graphic editor *the program which is carrying out start of the computer

*+the program damaging computer programs and data

#273 *!The computer virus is: *the program which breeds itself and does harm to the computer of the user and other objects located in network *not readable data which are kept on rigid or on a floppy disk *the hidden programs which erase, but they aren't removed *programs which don't give the chance to open data with the password *the program which protects the computer from harmful files

*+the program which breeds itself and does harm to the computer of the user and other objects located in network

#251 *!The computer presentation is... *audio and video data handling *the program for operation only with photos *the sequence of the slides containing multimedia objects *the program intended for request processing from client programs *the diagram of the data recording which is contained in files on a physical disk

*+the sequence of the slides containing multimedia objects

#268 *!Virus is: *the special program which interferes with a programs runtime *information in the machine *special memory for information storage *system which is more convenient than MS DOS *special programs to create images

*+the special program which interferes with a programs runtime

#275 *!Expert systems are: *set of knowledge *hypertext systems *systems of the contextual help *the artificial intelligence which isn't relating to knowledge *the systems of an artificial intelligence based on knowledge

*+the systems of an artificial intelligence based on knowledge

#236 *!Doctor programs: *treat the infected files *modify programs *find changes and treat *find the infected files *only find changes in files

*+treat the infected files

#288 *!MS Word 2007. The group zoom is on tab *home *insert *view *references *page layout

*+view

#289 *!MS Word 2007. The ruler pictogram is located on tab *insert *home *view *references *page layout

*+view

#241 *!The viruses using errors and inaccuracies in a complex of software: *viruses interceptors *logical bombs *worms *trojan horses *propagandists

*+viruses interceptors

#234 *!Computer can be infected with the virus: *on incorrect loading *when loading drivers *when text program is working *when executing the infected program *when inserting a floopy disk into the disk drive

*+when executing the infected program

#262 *!MS Windows.Auxillary level program *microsoft excel *windows antivirus *windows media player *basic input-output system *internet connection firewall

*+windows antivirus

#218 *!MS Power Point. Which of the following statement is true? *it is not possible to change slides' background of presentation *you can insert text boxes from drawing toolbar in Power Point *you cannot insert text boxes from drawing toolbar in Power Point *text boxes cannot be changed after inserting and writing the text *text boxes are provides when you choose a layout and can't be inserted afterwards

*+you can insert text boxes from drawing toolbar in Power Point

#242 *!Anti-virus programs: *AidsTest, Doctor Web, Kaspersky KAV *MS Word, MS Excel, MS Access *MS DOS, NC *ARJ, RAR, ZIP *AutoCAD, CorelDraw

*AidsTest, Doctor Web, Kaspersky KAV

#263 *!Which of the following operating system can work only with one program at current time *Linux *MS DOS *Windows 98 *Windows NT *Windows XP

*MS DOS

#235 *!Detector programs: *treat the infected files *modify programs *find changes and treat *find the infected files *only find changes in files

*find the infected files

#256 *!To change the size of text field from 255 into 50 characters in MS Access it is necessary: *in a design view to change field type *in a design view to change field size *in a datasheet view to change field size *in a datasheet view to change a field format *in a design view to change a selection criterion

*in a design view to change field size

#282 *!MS Word 2007. The group table is on tab *view *home *insert *references *page layout

*insert