Creating and Managing Tables

All this time, we have been working with a range of cells, not tables. To create a table from a range, you need to select the required range of cells and click on "Insert" -> "Table" in the tab.

A range of cells and a table have different properties in the Excel editor. For example, we see nice color formatting, and additional options appear near the column headers (such as sorting and filtering). When scrolling down, instead of letters that denote table names, we have column names, automatic addition of new columns and rows to the table, absolute references to data ranges are automatically used, and more.

Managing tables is a breeze. You can easily add or delete rows and columns, modify table styles, and even perform calculations with the Total Row option. Furthermore, tables are conducive to creating dynamic charts and pivot tables.

Try and reproduce the table below:

As you may have noticed, since Excel now knows that this is a data table, arrows next to headers have appeared. By clicking there, you will be able to specify sorting algorithms and filters.

Now, let's practice together and do the following:

• Select all cells, including headers;
• On the Insert tab click "Charts";
• Select the first charting option.