Working with lists - Computer Science and Information Technology

Working with lists

In Excel, you can create very large multiline tables that contain homogeneous data-each row-record contains a set of identical data types (zeros) with different values. A set of such records is called a list, with the first row in the list containing the column headers - data type fields. To work with the list in Excel, the commands Data, Filter.

Table 6.2

Data Fragment 2003

Countries

Population, thousand people

Area, million km2

Population density

Average life expectancy

Population growth, %

GDP

Rating

United States

144,526

17,075

8,464

67

-0.38

8377

60

Germany

82,400

357

230,812

78

0.04

25 103

17

United Kingdom

60,094

245

245,281

78

0.3

23,509

13

France

60 180

547

110,018

79

0.42

24,223

12

Spain

40 217

504

79,796

79

0.16

19,472

21

Poland

38 622

312

123,788

74

0

9051

37

Ukraine

48 055

603

79,693

66

-0.69

3815

80

Belarus

10 322

207

49,865

68

-0.12

7544

56

Latvia

2348

65

36,1230

69

-0.73

7045

53

Norway

4546

324

14,030

79

0.46

29 218

1

Using these commands, the data in the list can be sorted and filtered.

If the data is sorted by a continuous area (cell by cell) and only one column of a separate table, it is enough to place the cursor in the cell of the column whose values ​​are being sorted, and use the buttons or the Data, Sort from maximum to minimum (Descending). The Data, Sort command should be used to sort large tables by several conditions (up to three columns) or when part of rows (for example, column header lines) are excluded from the sorting of the table.

Filtering is a quick way to find a subset of data (select a piece of data) and work with them in the list. The filtered list displays only rows that meet the selection criteria specified for the column. The filter does not delete records from the table, but shows only those that satisfy the condition, the rest temporarily hides. Filtered list entries can be copied to another sheet or to another file, printed as a shortened table, and built according to a given diagram.

Automatic filter (auto filter) is applied for simple selection conditions. To apply it, you should place the cursor in the cell of the table with the data and give the command Data, Filter, AutoFilter. After that, the selection criteria selection buttons for each column appear in the title bar of the table (Table 6.2).

The button in the column breaks the list of data selection conditions from the column entries (Figure 6.9). The list of values ​​in the filter window (unlike the original table) will be sorted, so it's easy to find the maximum, minimum, other specific value, click the mouse and leave only the record with this data.

After setting the record selection condition, the filtered table displays only row entries that meet the selection criteria specified for the column. You can get records about the country in which the maximum (minimum) population growth is marked -

Selecting Filter Conditions

Fig. 6.9. Selecting filter conditions

tion; maximum (minimum) life expectancy; about countries where population growth is more (less) than average or negative.

The Condition option selects from the table the rows that satisfy the particular condition for the value in the filter column: & quot ;, is equal to & quot ;, is not equal to & quot ;, starts with & quot ;, greater than or equal to and others. You can set the conditions for selecting records by numerical value and text.

Advanced filter gives the selection conditions for several columns (with advanced features). To create it, headings (signatures) of columns are copied into any free space on the page.

In the table so created, some selection criteria are entered under some headings, and several conditions can be created for several columns (Table 6.3).

Table 6.3

Advanced filter for selecting countries with a population of more than 10 million people and in a state of demographic crisis

Country

Population

Increment,%

*

& gt; 10000

& lt; 0

After creating the conditions, put the table cursor in any data cell in the table and give the command Data , Filter , Advanced filter. the need to specify the range of cells with data (along with the header line) and the range of cells of the individual filter conditions (also with the header).

thematic pictures

Also We Can Offer!

Ошибка в функции вывода объектов.