+ is able to create copies of itself (not necessarily completely consistent with the original) and incorporate them into different objects/resources of computer systems, networks, etc. without the knowledge or consent of the user
- contains data compression algorithms
- creates graphical objects
- carries the text information
- creating spreadsheets
\/
/\
Viruses can be divided into the following classes
- Habitat
- by way of living environment
- on the destructive capabilities of the
- the characteristics of the algorithm of virus
+ all of the above listed
\/
/\
Microsoft Excel – it is:
+Program designed electronic table running Windows.
-Information management system under the control of Windows.
-Windows-application designed to create, view, modify and print text documents.
-System for creating and editing images on the screen.
-Application editing a graphic editors.
\/
/\
Operation with the data that is used to filter out unnecessary data, which are not necessary for making decision:
+Filtering data.
-Data Collection.
-Formalization of data.
-Archiving data.
-Transportation data.
\/
/\
Operation with the data that is used to organize the data:
+Sort data.
-Formalization of data.
-Filtering data.
-Archiving data.
-Transportation data.
\/
/\
Enter the correct writing the range of cells in MS Excel.
+C20: D35.
-C20 ... D35.
-C 20 / D 35.
-C20 \ D35.
-C20 - D35.
\/
/\
To call Wizard function you must use the line:
+Formulas.
-States.
-Headlines.
-Function.
-Data.
\/
/\
What is the name of the smallest structural unit for placing in a work paper?
+Cell.
-Book.
-Macro.
-Byte.
-Module.
\/
/\
MS Excel. When you draw a graph what we must use...
+Chart Wizard
-Drawings Wizard
-Report Wizard
-Function Wizard
-Form Wizard
\/
/\
Absolute addressing allows you to:
+Not to change the cell references in formulas when you’re copying.
-To change the cell references in formulas by columns according to the new position of cells.
-To change cell references in formulas according to the new position of the cells.
-Not to change the cell references in formulas by columns according to the new position of the cells.
-To change the cell references in formulas only the rows according to the new position of cells
\/
/\
Enter a formula in Excel cell should begin with the character:
+(=)
-(!)
-(no sign is not required)
-(-)
-(#)
\/
/\
To record a range of cells, use the symbol:
+:
--
-&
-$
-*
\/
/\
List the types of cell references used in formulas in Excel
+Absolute, relative, and mixed
-Cell references cannot be mixed
-Absolute and mixed
-Absolute, relative
-Absolute, relative and adjacent
\/
/\
The cell address, written as "$ C $ 5" is called:
+Absolute
-Relative
-Numeric
-Monetary
-Mixed
\/
/\
The cell address, written as "$ C 5" is called:
+Mixed
-Relative
-Monetary
-Absolute
-Numeric
\/
/\
Cell address is defined by:
+column letter and row number
-row number
-row number and simultaneously pressing Alt
-column letter and sheet number
-sheet number - column letter
\/
/\
In Excel what format of cell is designed to represent numeric data?
+Numeric
-Digital
-General
-Text
-Percentage
\/
/\
Which key is used for automatically inserting the chart?
+F11
-F4
-F2
-F3
-F10
\/
/\
In order to make a cell absolute, you need to put a sign to the cell address in front of a letter and number
+“$”
-“@”
-“&”
-“*”
-“#”
\/
/\
A legend is…
+An element of a diagram showing the name of the series of data displayed in the chart.
-The name of the file where pictures and graphs are posted.
-Chart template
-Scale selected by the user for plotting.
-Workbook that contains a chart.
\/
/\
Insert a formula in Excel by clicking
+Function Wizard
-Template functions
-Formula Workshop
-Chart Wizard
-Formula bar
\/
/\
What type of functions are the functions MAX, MIN?
+Statistical
-Financial
-Text
-Mathematical
-Logical
\/
/\
Non-existent type of functions in Excel:
+Absolute.
-Logic.
-Statistics.
-Financial.
-Mathematical
\/
/\
Дата: 2018-09-13, просмотров: 1731.