# 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 -

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).

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

[...]

## Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

## How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)