ИКТ6 (251-300)

MS Excel. Each worksheet in a workbook has rows

• 100

• 65536

• 327625

• *1046756

• 1048576

MS Excel. The , located near the top of the excel window, is the control center in Excel

• ribbon

• home tab

• mode bar

• status bar

• control bar

Statistical set is

• casual events

• set of the studied diverse objects

• group of the recorded casual events

• group of the recorded diverse objects

• *set of units of the studied phenomenon

Statistical supervision

• work on collecting mass primary data

• *organization of information registration

• extensive program of statistical researches

• scientific organization of information registration

• an assessment and registration of the studied set signs

*!Statistics indicator

• quantity of units of the studied object

• quantity of units of the studied

• measurements' results of the studied object properties

• result of the studied phenomenon in physical units of measurement

• the size of the studied phenomenon in physical units of measurement

The values of the sign repeating with the greatest frequencyi’

• mode

• median

• regression

• dispersion

• correlation

Variance indicator

• deviation from an average

• average square of deviations

• deviation of an average square

• square of an average deviation

• deviation from a general average

Correlation in statistic means

• ratio

• relation

• function

• equation

• relationship

*!MS Excel. Error in formula «SUM(С7:С10)»

• the wrong cell range is set

• insufficient quantity of arguments

• the function name isn't correctly written

• absence of a sign "=" at the beginning of the formula

• here should be one more bracket near the SUM function

MS Excel. Appearance of symbols  means

• the cell is protected

• there is an error in a formula

• the text isn't hold in a cell

• the number is large and also is not completely displayed