TestWizard - ict 1

��: ict 1

��

1. $ MS Word. How to make a table:
1) $Insert
2) $File
3) $ Page layout
4) $Main
2. $ MS Word. Command to be selected for ruler...
1) $Insert - Ruler
2) $Main - Ruler
3) $View - Ruler
4) $File - Ruler
3. $ How to insert WordArt in Microsoft Word?
1) $ Insert - WordArt
2) $ Type - Insert WordArt
3) $ Links - WordArt
4) $ Home - WordArt
4. $ MS Excel. The main element of the table �
1) $Values
2) $Field
3) $Cell
4) $Grid
5. $ Which menu is used in Excel with headers and footers?
1) $Data
2) $Insert
3) $Mode
4) $Formulas
6. $ The Table contains the following:
1) $key
2) $ identifier
3) $ square
4) $Cell
7. $ In Excel �5, �4 �is:
1) $ The absolute addressing of the cell
2) $ Relative addressing of a cell
3) $ Cell Range
4) $ Mixed Addressing of the Cell
8. $ What is the category of "IF" function in Excel?
1) $logical
2) $statistic
3) $finance
4) $maths
9. $ How to rename a list in Excel?
1) $Mode - Rename
2) $Right-click the mouse on the face with the rename command
3) $Data - Rename
4) $Formula- Sheet
10. $ What does Excel construe in terms of "Field"?
1) $Table columns
2) $ Table rows
3) $ The most recent
4) $ The first or last line
11. $ To add a number in cell C1 to cell number C5, in what form should the formula be written:
1) $�1*�5
2) $=�1+C5
3) $= SUM(C1:�5)
4) $�1+C5�
12. *$ In the spreadsheet in cell A1 recorded the number of 5, in B1-formula = A12. What is B1?**
1) $4
2) $10
3) $5
4) $2
13. $ What mathematical operations can be executed in Excel without inserting the function?
1) $statistic
2) $finance
3) $logical
4) $addition
14. $ How to set the cell block in a Table?
1) $ The first and last cell row numbers
2) $ The first and last cell addresses
3) $ The first and last cell's column letters
4) $ The address of the first cell
15. $ How to give an absolute address in a cell in MS Excel?
1) $ Write a dollar symbol before the letter and number
2) $ With the help of the service menu
3) $ The address is written in italics
4) $ By typing ABS at the address
16. $ What formula is right in MS Excel?
1) $(�1+�1)/(�1-D1)
2) $�1/(�1*�1)-5
3) $=�1-�1*�1
4) $A1+B1*C1
17. $ How do you set a cell in MicroSoft Excel?
1) $E12, 13
2) $1D2
3) $10�
4) $�5
18. $ Command to insert chart in MicroSoft Excel?
1) $Mode - Formula Row � Chart
2) $Formula � Chart
3) $Data � Chart
4) $Insert � Chart
19. $ How many cells are active in Excel at the same time?
1) $Only one cell
2) $All cells in the workbook
3) $from1 to 100
4) $All current cells
20. $ MS Excel. Select full rows:
1) $Alt+Space
2) $Shift+F5
3) $Ctrl+Space
4) $Shift+Space
21. $ Why do you need an Excel fx key?
1) $To invoke the Chart Master
2) $To do addition
3) $To enter data in cells
4) $To invoke the
22. $ What is the formula path in Excel?
1) $ To highlight the range
2) $ To copy cells
3) $ To enter formulas and data in cells
4) $ To avoid commands
23. $ In Excel, how is the cell at the intersection of column D and row 3?
1) $D3
2) $3S
3) $3�
4) $1�
24. $ Excel. What is Absolute addressing?
1) $ quantitative data set
2) $ the cell's address remains unchanged while copying the formula
3) $ Absolute and relative references
4) $ the relative change in the address
25. $ In Excel, you can automatically fill in the following details in a table:
1) $ Students' names
2) $ Formulas, charts
3) $ Numbers, chart names
4) $ Months, weekdays and numbers
26. $ Which menu do you put in the image in Excel?
1) $Data
2) $Insert
3) $Mode
4) $Formula
27. $ Cell address that automatically changes when copying or replacing the formula:
1) $ Logical address
2) $ Real address
3) $ Relative address
4) $ New address
28. $ A function that finds the average of numbers in Excel:
1) $Average
2) $Sum
3) $�in
4) $Max
29. $ What is the function of putting the function in Excel?
1) $ Main �Insert function
2) $Formula �Insert function
3) $ Mode �Insert function
4) $ Data �Insert function
30. $ How to put money format into cells in Excel?
1) $Service- Settings- Money
2) $Mode- Page layout
3) $Mark the box and click the left mouse button and select Format - Cell-Number-Money
4) $Service-Cell-Number-Money
31. $ Which menu in the Excel worksheet adds a new row, column, and cell?
1) $Insert
2) $Mode
3) $Formula
4) $Data
32. $ In Excel, the following entry shows ######:
1) $ The cell does not have a length of digits
2) $ The textual data type
3) $ The calculated result does not correspond to the formula
4) $ The correct link to the result is incorrect
33. $ Among the formulas find the formula for the spreadsheet:
1) $ =A3*B8+12
2) $ A1 = AZ*B8+12
3) $ B1 = AZ*B8+12
4) $ AZ*B8+12
34. $ Which function we use to find the maximum of values in cells:
1) $ fx- ��X function
2) $ fx- �IN function
3) $ fx- Logical function
4) $ fx - References and Function Arrays
35. $ Types of Addressing in an Excel Table:
1) $Simple and complex
2) $Right direction and opposite direction
3) $Absolute, relative, and mixed
4) $Absolute and non-absolute
36. $ Which sign indicates that the reference was not made correctly?
1) $#del/0
2) $#reference!
3) $#numder!
4) $#data!
37. $ A combination of keyboard shortcuts that can be used to set the column in Excel:
1) $Ctrl+Shift
2) $Ctrl+Tab
3) $CTRL+Alt
4) $Ctrl+space
38. $ In Excel, textual alignment is as follows:
1) $By the width
2) $Left edge
3) $By the middle
4) $Right edge
39. $ To confirm the entry in the cell you need:
1) $ TAB
2) $ CTRL
3) $ SHIFT
4) $ ENTER
40. $ The database in an Excel table �
1) $ Formula
2) $ A graphic object
3) $ A set of linked tables
4) $ Multiple cell groups
41. $ When you copy the formulas from one cell to another during relative addressing in Excel
1) $ Addresses will be deleted
2) $ The data will change
3) $ The addresses automatically change
4) $ Addresses remain stable
42. $ To use data in a table as a database in Excel, you must follow the main menu item:
1) $Mode
2) $Main
3) $Data
4) $Formula
43. $ Sorting and filtering is performed by what menu?
1) $View
2) $Formula
3) $Insert
4) $Data
44. $ A chart in Excel �
1) $ Graphic object entered into one sheet of workbook
2) $ Multiple cells group
3) $ Write type used in the text editor
4) $ At the bottom of the current cell enclosure during autofill is a small black square
45. $ Entry A1: D7 in Excel means
1) $ file extension
2) $cell range
3) $ financial function
4) $ element division
46. $ Using an AutoFilter in Excel:
1) $ Data-Filter-Avtofilter-Filing a filtering agreement
2) $ Formula-Filter-Autofilter - Filing a filtering agreement
3) $ Display-Filter-Autofilter - Filing a filtering agreement
4) $ Set-Filter-Autofilter - Filing a filtering condition
47. $ You can not create a chart in the Excel table
1) $ Calculated ranges
2) $ For non-interconnected ranges
3) $For lists containing textual information
4) $ In the range of numbers
48. $ Which of the following statements calculates the sum of cells in column A from column A to column F:
1) $ Sum (1: 6)
2) $ = SUMM (A30: F30)
3) $ SUMM (A1: F6)
4) $ Sum (A30: F30)
49. $ Can we split texts in Excel?
1) $yes
2) $ It will only work with #
3) $ depends on the number of text
4) $ no
50. $ How can we leave the columns and rows numbers intact in Excel to give the exact address of the cell?
1) $ By simple typing
2) $ Compound writing
3) $ Comparative writing
4) $ Absolute writing
51. *$ In the spreadsheet in cell A1 recorded number 15, in B1 the formula = A12. What is B1?**
1) $ 40
2) $ 50
3) $30
4) $ 20
52. $ Which command applies to selecting records that meet the conditions in Excel?
1) $ View-Data-Expanded filter
2) $ Table-Autofilter
3) $Data-Filter-Expanded Filter
4) $ Formula-Filter
53. $ What command is used to set the border to the selected fragment of the Excel table?
1) $View � Normal
2) $Insert � Cell � Border
3) $Main-Border
4) $Table � Border
54. $ To delete a column in Microsoft Excel is necessary to:
1) $Select the column - Context menu - Delete
2) $ Tools - Delete
3) $ Home - Delete
4) $ Type - Delete
55. $ A combination of keyboards that can be used to fully define a string in Excel:
1) $ Shift + F5
2) $ Ctrl + Enter
3) $ Alt + Space
4) $Shift + Space
56. $ Element base of the first generation computers are that are written before formula?
1) $After the
2) $After
3) $after the point
4) $After the
57. $ What is the arithmetic average of the data in cells C1, C10 calculated by the formula?
1) $= Z (A1;A10)
2) $=��(A10)/10
3) $ =��(C1:C10)
4) $=��(A1:A10)
58. $ Which formula is used to calculate the information in cell A1 to the third degree?
1) $=MIN(A1)
2) $=A1^3
3) $=ABS(A1,3)
4) $A1*3
59. $ When you create a formula in Excel, we use the ...
1) $ Function Master
2) $ Reporting Master
3) $ Form Master
4) $ Chart Master
60. $ In Excel, we have the formula = SUMM (A1:E1). What will be determined by it?
1) $ The largest value in cells A1 and E1
2) $ A product of numbers in cell A1 and E1
3) $ The total of numeric values in cell A1 and E1
4) $ The sum of numbers between A1 and E1
61. $ How to filter data in Microsoft Excel
1) $ Data - Sort
2) $ Data - Filter
3) $ Home - Filter
4) $ File - Filter
62. $ In Excel the crossing of a row and column means:
1) $cell
2) $ linear table
3) $ block
4) $ The rectangular table
63. $ Excel. Choose financial features
1) $ TIME, YEAR, DATE
2) $ FV, NPER, PMT, PV
3) $ ND, OR, TRUE, FALSE
4) $��S, SIN, TAN, EXP
64. $ Specify logical functions in Excel?
1) $ ABS, SIN, TAN, EXP
2) $AND, OR, TRUE, FALSE
3) $ TIME, YEAR, DATE
4) $ BS, PS, NPER
65. $ Formula input in Excel
1) $starts with the sign :=
2) $starts with the sign #
3) $starts with =
4) $starts with the symbol ?
66. $ Specify mathematics functions in Excel
1) $ TIME, YEAR, DATE
2) $ BS, PS, NPER
3) $ AND, OR, TRUE, FALSE
4) $��S, SIN, TAN, EXP
67. $ Which menu will search and replace text in presentation elements?
1) $ Period
2) $Main
3) $ Design
4) $ View
68. $ Power Point. the slide show is performed with the help of which keys:
1) $F2
2) $F5
3) $F3
4) $F7
69. $ Presentation is:
1) $computer language
2) $spreadsheet
3) $text document
4) $multimedia document
70. $ Power Point. To enter page size options:
1) $Design � options pages
2) $ Animation � page settings
3) $ Home � options page
4) $ Show � page settings
71. $ Power Point F5 key in the program:
1) $ uses effect
2) $ displays slide properties
3) $slide show
4) $ displays the Help menu
72. $ How to add a table to MS Power Point:
1) $ Review-Insert table
2) $ View - Table
3) $Insert - Table
4) $ Main-Insert table
73. $ Extension of Power Point program:
1) $.pps
2) $.ppt�
3) $.gif
4) $. jpg
74. $ Slide fragment is called motion and sound ...
1) $ design
2) $ demonstration
3) $animation
4) $ calculation
75. $ Slide view menu:
1) $ Design � Start Shows (F5)
2) $ Insert - Start shows (F5)
3) $ View - Start Slideshow
4) $ Slideshow � Start Shows (F5)
76. $ Create a second presentation slide (Power Point)
1) $Slide show - new slide
2) $View � New slide
3) $Insert-new slide
4) $Edit � New slide
77. $ Digital Signature is:
1) $ A mathematical technique used to validate the authenticity and integrity of a message, software or digital document
2) $ A specific technical implementation of an electronic signature, involving cryptographic techniques using signature keys associated to the signatory
3) $ A an algorithm or hash (a number derived from a string of text) that uniquely identifies a specific virus
4) $ A string of characters or numbers that makes up the signature that anti-virus programs are designed to detect
78. $ The database management system -
1) $ Complex for programming languages effectively
2) $ Special software for editing text and digital information
3) $ A set of graphic tools for creating, maintaining
4) $A set of software tools for creating a new database, filling out its content, processing its content, and managing them
79. $ The main functions of the database management system:
1) $ Include, verify and edit table information
2) $ Designing database structure,
3) $Enter information, check, search, and exit
4) $ Including information
80. $ The main element of the database is:
1) $Record
2) $ Models
3) $ Form
4) $ Table
81. $ What key does the Access table use to move from one field to another?
1) $Esc
2) $Tab
3) $Alt
4) $End
82. $ In Microsoft Access files have the default extension:
1) $.bmp
2) $.dbf
3) $ .accdb
4) $.xls
83. $ The Database window in Microsoft Access consists of six tabs:
1) $Mode Designer, Import Wizard, Macros, Modules, Field
2) $Tables, Queries, Forms, Reports, Macros, Modules
3) $Table designer, form Wizard, Import Wizard, Macros, Modules, Field
4) $ Designer Wizard, Reports, Macros, Modules, Relational
84. $ Microsoft Access The main object of the databases:
1) $Table
2) $Field
3) $Form
4) $Record
85. $ What type of database model is created in MS Access?
1) $Relational
2) $Mixed
3) $Tree
4) $Hierarchical
86. $ The main structural elements of the relational database are:
1) $ Data, row, column
2) $ Table, relation, scheme
3) $Field, record, table
4) $ Field, record, scheme
87. $ The field in the database is:
1) $ Logical Data
2) $Elementary unit of data organization
3) $ A set of data
4) $ Table structure
88. $ Scheme data in Microsoft Access - it
1) $ Primary and foreign key
2) $ Model of data
3) $Visualization tables and relationships between them
4) $ Illustrative kind of request
89. $ For programming in MS Access are used:
1) $ Models
2) $Modules
3) $ Command mode
4) $ Tables
90. $ MS Access. Text data type is used for input:
1) $ Logical Data
2) $ Data on the amounts of money
3) $ Empirical data
4) $Alphanumeric data
91. $ The objects of Access database does not apply:
1) $ Form
2) $Scheme
3) $ Report
4) $ Modules
92. $ MS Access. What type of data you must specify the field that it was possible to insert a picture?
1) $ Scheme
2) $ Indexed field
3) $OLE object field
4) $ Field signature
93. $ Access. Queries is -
1) $ Print data
2) $ Data input tool
3) $Queries information from the databases or the information search system
4) $ Unique object that can be written in HTML code
94. $ In Access, specify the field type: if the field name is "birthday"
1) $ Text
2) $ Numerical
3) $Date / Time
4) $ Logical
95. $ MS Access. What type of data can contain text or a combination of text and numbers? The maximum value of this type is 65535 characters
1) $Data is of type counter
2) $OLE object field
3) $Money type data
4) $memo field
96. $ The type of field where the numbers automatically multiply when a new record is added in Access:
1) $ Text
2) $Counters
3) $ Number
4) $ Logical
97. $ Data schema in Microsoft Access is
1) $Visual query view
2) $Visual display of tables and links between them
3) $Database wizard
4) $Characteristics
98. $ MS Access object for visualization of data -
1) $Form
2) $ Table
3) $ Request
4) $ Reporting
99. $ In what mode we can Modify the Table Structure in Access?
1) $ Tables
2) $ Master
3) $Constructor
4) $ Details scheme
100. $ What kind of data is used in Access?
1) $ Financial
2) $ Scientific
3) $Logical
4) $ Statistical
101. $ What is the arithmetic average of the data in cells A1, A10 calculated by the formula?
1) $=��(A1:A10)
2) $=��(A10)/10
3) $=��(A1:A10)
4) $= Z(A1;A10)
102. $ MS Excel. The main element of the table �
1) $Cell
2) $Grid
3) $Field
4) $Values
103. $ Can you rename a list in Excel?
1) $the number will not exceed 5 characters
2) $only file extensions are changed
3) $no, you can�t
4) $yes, you can

����: ict 1

������ ��������

��: ict 1

��