stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Ict 235-335 Flashcards | StudBud
Explore
/
Ict 235-335
Ict 235-335
100 terms
·
StudBud Administration
·
2 plays
Flashcards
100 cards
F
Practice quiz
P
Host live
L
Questions
100
Answers
1
Transition to the slide under "X" number
number+SPACE
number+ESC
number+ALT
number+ENTER
2
MS Access. Which of the following cannot be done to data using a form
Sort
Store
Print
Edit
3
What general property do the interactive presentations have?
are managed by events
are operated by the speaker
are usually shown at different exhibitions
the self-carried-out presentation
4
MS Word 2007. The group font is on tab
view
home
insert
references
5
The database which can be used in several spheres of human activities
Certain
Universal
Specialized
Generally available
6
The cell A3 contains next formula: =B1+С$1 is moved in A4. The formula in A4 will become
=$B$1+$C2
$B$1+$C$1
=В1+С$4
$B$1+$C1
7
Windows XP. A ____ is a pointing device
monitor
CD RW
mouse
keyboard
8
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}
9
Excel. The Excel program file has an extension
.com
.txt
.docx
.Xlsx
10
How to load anti-virus AVP program
Start - Programs - Antiviral Toolkit Pro
Main menu - Programs - AVP
Automatically joins with an operating system
Start - Programs -Accessories - Service - Disk scanner
11
To change the size of text field from 255 into 50 characters in MS Access it is necessary
in a datasheet view to change a field format
in a design view to change field type
in a design view to change field size
in a datasheet view to change field size
12
MS Access. A _____ is a major database object used to display information in an attractive, easy-to-read screen format
report
form
query
table
13
MS Word 2007. The group spelling is on tab
page layout
view
home
review
14
The cell A3 contains next formula: =В1+С$1; A3 is moved in A4. The formula in A4 will become
=В2+С$4
=В2+С$1
=$B$1+$C$2
=В1+С$1
15
MS Word 2007. The group styles is on tab
references
home
view
insertinsert
16
MSWindows.Which of the following is an operating system you would be using on the computer
Microsoft Excel
Netscape
Microsoft Word
Microsoft Windows
17
Term «Statistic» was introduced by
Galton
Byushing
Akhenval
Quetelet
18
MSАccess. Maximum number of symbols in text field of the table
155
225
455
255
19
Expert systems are
the artificial intelligence which isn't relating to knowledge
set of knowledge
the systems of an artificial intelligence based on knowledge
hypertext systems
20
MS Excel. For creation of diagrams and drawing up formulas is used
reports
forms
function wizard
drawing
21
MS Windows.Auxillary level program
windows antivirus
microsoft excel
basic input-output system
windows media player
22
The computer presentation is...
the program for operation only with photos
the program intended for request processing from client programs
the sequence of the slides containing multimedia objects
audio and video data handling
23
Anti-virus programs
Aids Test, Doctor Web, Kaspersky KAV
MS DOS, NC
ARJ, RAR, ZIP
MS Word, MS Excel, MS Access
24
Infection with loading viruses occurs at
Closing of the file
Data recording in the file
Opening of the file
Turning on the computer with busy floppy
25
MSExcel. It is specified in a formula row
formula
symbol
cell contents
figure
26
Vaccine programs
modify programs
find the infected files
treat the infected files
find changes and treat
27
MS Word 2007. The clipboard is on tab
home
insert
view
page layout
28
MS Access. There are 3 type of relationship that valid in MS Access 2007, except
many to one
one to many
one to one
intermediate
29
How the computer can be infected a virus
in case of the wrong loading
when loading drivers
when opening the internet
in case of execution of the infected program
30
MSАccess. Maximum numbers of symbols in «Mемо» field
650 563
65 536
65 000
65 500
31
MS Access. The undo command is found where in Access
Office button
Quick Access toolbar
Home command tab
Status bar
32
MS Excel. Selecting of cells range on the work sheet
drag the mouse pointer from one corner of range to another
right-click and choose the command "to allocate"
choose the command "editing-to clear-all"
move the mouse pointer there and back
33
Origin of the term "statistics"
statistics
network
status
statics
34
MS Word 2007. The ruler pictogram is located on tab
home
view
references
insertinsert
35
Systems of an artificial intelligence are
the machine programs created in the direction of artificial intellectual sy
directions of expert systems
direction of an artificial intelligence
activities, connected to the direction of an artificial intelligence
36
MS Access. What queries are used to summarize data in tables
Parameter
CrossTab
Action
Select
37
Constructing process of expert systems consists of stages
5
4
2
8
38
МS Аccess.Which data type can store more than 255 characters
memo
yes/no
long integer
text
39
Comand to break slideshow of Power Point
ESC
TAB
DEL
ENTER
40
The document created in Excel is called
worksheet
workbook
workdocument
workfile
41
The statistics studies
mass phenomena
periodic events
properties of the studied phenomenon
single phenomena
42
MSАccess. Rename the table
F2
F1
F6
F5
43
How in a query it will be correct to specify the following criterion:: «Patient's weight is between 50 and 80»
Nless than 80, greater than 50
<80 or >50
<80, >50
<80=>50
44
in what case the comnuter can he infected with virus
at start of the DoctorWeb program
when formatting a disk
during the work with the infected program
when loading of the computer when testing the computer
45
MSWindows.Which of the following type of objects can you search on your computer and on the network, using Windows XP
all of these
documents
pictures
windows help
46
Excel displays the error message ____ in cells to indicate a cell reference error
REF
REF!
#REF!
REF#
47
The format of presentation created in MS Power Point 2003
.рpt
.jpg
.doc
.pptx
48
MSАccess. Before printing a datasheet, you can use______ to determine whether to change the page orientation from port
Office View
Design View
Print Preview
Datasheet View
49
Doctor-auditors programs
modify programs
find changes and treat
find the infected files
only find changes in files
50
Loading viruses can infect
сOM-files
OBJ-files
Boot-Strap program
еxe-files
51
The important future of multimedia technology is
Animation
Interactivity
Multitasking
Optimization
52
Doctor programs
treat the infected files
find changes and treat
find the infected files
modify programs
53
MS Excel.Which keyboard shortcut should be used to apply or remove an italic tracing
CTRL+1
CTRL+3
CTRL+4
CTRL+2
54
MS Access. What is one of the advantages for using a form over other Access objects
Forms cannot be edited
Forms store information more efficiently
Utilizes field placement to improve the efficiency of data entry
Forms output a financial summary for a period, or a set of mailing labels
55
Transition to the first or following hyperlink on a slide
SHIFT+TAB
CTRL+TAB
ALT+TAB
ESC+TAB
56
If criteria are connected with AND, then in query design they register as
in merged row
on the same row
on different rows
in a total row
57
MSАccess.What type of queries is a queries that select records from tables based on criteria
Action Queries
Cascade Queries
Select Queries
CrossTab Queries
58
MS Word 2007. The group symbols is on tab
insert
home
view
references
59
Main objective of an artificial intelligence
saving the main concepts of problem area
assignment of the main concepts of problem area
separation of the main concepts of problem area
simulation of intellectual activities of the person for transmission of a c
60
Which of the following operating system can work only with one program at current time
Linux
Windows 98
MS DOS
Windows NT
61
Auditor programs:
Treat a disk
Delete only the infected files of Windows
Remember data on a condition of programs
Use vaccines
62
MS Excel. To add two cells (A1 and A2) together you use the following formula
=together(A1:A2)
=Add(A1+A2)
=sum(A1;A2)
A1 + A2
63
The main two groups of viruses
resident,nonresident
network, file
macro, micro
dangerous, not dangerous
64
The cell A3 contains next formula: =В1+$С1; A3 is copied in A4. The formula in A4 will become
=В1+С$2
=В2+$С1
=В2+$С2
=В1+С$1
65
MS Excel. Which keyboard shortcut should be used to fill a range of cells with the same data
<Ctrl>+<Shift>+<Space Bar>
<Ctrl>+<Tab>+<Enter>
<Ctrl>+<Shift>+<Enter>
<Alt>+<Tab>+<Enter>
66
Computer viruses are divided by extent of influence on
network, file, loading, file and loading
harmless, dangerous, very dangerous
resident, non-resident
detectors, doctors, auditors, filters, vaccines
67
MS Word 2007. The group zoom is on tab
insert
view
references
home
68
MSWindows. How to invent start menu
Ctrl+Tab
Ctrl +Esc
Shift+Esc
Alt+Esc
69
Distinctive features of a computer virus are
considerable volume of a program code
small volume. ability to independent start and repeated copying of a code,
ease of recognition
need of start of the program from the user
70
MS Аccess. Format of database
.txt, .doc
.bat, .accdb
.mdb, .ассdb
.exe, .mdb
71
The viruses using errors and inaccuracies in a complex of software
virses interceptors
trojan horses
worms
logical bombs
72
Specify two main groups of viruses:
Macro, micro
Network, file viruses
Harmless, dangerous, very dangerous
Resident, non-resident
73
WindowsXP. Using the mouse to move or copy cells is called
drag and drop
mousing
mouse copy
cut and paste
74
Macro viruses are
Macros
Dialogue files
Network files
Package files
75
Stop or renewal of automatic display
S or «-» symbol
B or «-» symbol
W or «+» symbol
S or «+» symbol
76
Set of the slides collected in one file
picture
slideshow
presentation
sheet
77
MS Access. What happens when a user selects a record in a form and presses [Delete]
The record is neither deleted in the form, nor from its source table
The record is deleted in the form, but not from its source table
The record is not deleted only in the form
The record is deleted in the form and from its source table
78
Excel displays the error message ____ in cells to indicate a divide by zero error
DIV/ #
#VALUE!
DIVIDE#
#DIV/ !
79
MSАccess.Table in Microsoft Access can be create by using all below except
Table Wizard
Design View
Form Wizard
Input Mask
80
The computer virus is
graphic editor
the program damaging computer programs and data
text editor
programming language
81
The computer virus is
specially written program of small volume which spoils them
the program for coercion of the archived file to an initial look
the program providing compression of files
the program used for increase in speed of operation of a disc
82
Medical expert systems
diagnostic systems of fifth generation
diagnostic systems of first generation
diagnostic systems of second generation
diagnostic systems of third generation
83
Virus is
the special program which interferes with a programs runtime
special memory for information storage
system which is more convenient than MS DOS
information in the machine
84
MS Excel. Function of the Office button
opens a toolbar
opens the only menu of the program
creates and changes marking of the document pages
provides the choice of various browse modes of the document
85
MS Excel. Which keyboard shortcut should be used to cross out the text or to remove deletion
CTRL+3
CTRL+2
CTRL+5
CTRL+1
86
MS Word 2007. The group table is on tab
insert
references
view
page layout
87
AVP is
anti-virus program
the program, the pressing the file for saving of the place on a disk
the program spreading virus
program of defragmentation
88
Possibilities of the Power Point program
creation of text documents with hyperlinks and communications
creation of the presentation with the description of program language
creation of animation animated films and rollers
creation of the presentation with multimedia animation
89
Windows XP. The ____ allows you to perform often-used tasks quickly
standard buttons toolbar
status bar
welcome screen
rulers
90
Doctor Program
Prevents infection of files
Finds the infected files and treats them
Looks for viruses with the known signature
Finds suspicious actions
91
The presentation component containing various objects
slide
shot
sheet
picture
92
The computer virus is
the hidden programs which erase, but they aren't removed
programs which don't give the chance to open data with the password
not readable data which are kept on rigid or on a floppy disk
the program which breeds itself and does harm to the computer of the user a
93
Are engaged in expert systems
students and specialists in the field of an artificial intelligence
doctors
experts and specialists in the field of an artificial intelligence
experts, students
94
Replicators
Destroy a virus program
Find a virus
Transfer a virus
Delete a virus
95
MSWindows. Which of the following file name extension suggests that the file is backup copy of another file
txt
bak
bas
com
96
The hyperlink is
any word or any picture
the text using of a big size font
a reference to data that the reader can directly follow either by clicking,
very big text
97
MS Word 2007. The group page setup is on tab
page layout
home
view
references
98
MS Excel.Which keyboard shortcut should be used to display the format of cells dialog box
+CTRL+1
+CTRL+3
+CTRL+2
+CTRL+4
99
MSAccess. You can __________ macros setting so that the macros run automatically for any database you open
Cancelling
Disable
Ignoring
Enable
100
The viruses using mistakes and inaccuracies in a complex software
Worms
Logical bombs
Propafandist
Viruses interceptors
