Excel Beginner Course

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.

Excel also provides additional options that can be accessed from the below icon (after selecting all cells, including headers).

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

• Select all cells, including headers;
• Click the icon highlighted in the screenshot above;
• Click "Charts";
• Select the first charting option.

What happens?

Select the correct answer

Nothing happens since the data is not enough.

Excel automatically creates a new sheet with the selected graph, selecting the most "reasonable" columns.

Excel automatically creates a new sheet with the selected graph, but it asks you which measures to use.

Submit Answer