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
