Question

what are the elements of a table in MS Excel​

Answer 1

Answer:

All tables contain three primary parts - the header row, the data in the table, and the total row. The header row displays column names. The header row is actually optional, but most tables will have one. The data in a table includes all rows defined in the table range.

Answer 2

Answer:

What is a Defined Table?

An Excel Defined Table is a special object in Excel which adds a lot of new options and functionalities when working with data ranges. With Defined Tables, you can manipulate data more easily than before, adding power and flexibility to your applications.

To create a Defined Table, select the data range, or simply select any cell within the data range, and click the Table button from the Insert tab from Ribbon. The keyboard shortcut key is Ctrl+T to create a Defined Table.

Explanation:

The formatted data ranges looks identically, but only the right range is a Defined Table. The easiest way to see if there is a Defined Table object inserted into a worksheet, is to check the Name Manager to see if there are any Table Names listed (the Table icon is different from a regular Name icon, see image above), or you can click to select any cell within the data range, if that cell is part of a Defined Table, Excel will open the Table Tools tab in Ribbon.

There are 4 Excel Table Components:

Headers Row

Data Body Range

Totals Row

Sizing Handle

1. The Headers Row:

The Headers Row contains the Column Names. If your data does not have headers, Excel will automatically create a Header Row with default Column Names like: Column 1, Column 2, and so on. There can be only one Header Row, merged cells are not allowed in Defined Tables.

2.The Data Body Range:

The Data Body Range contains all your data, excluding the Headers Row and the Totals Row:

3. The Totals Row:

The Totals Row contains drop downs for each column, each dropdown will allow you to select from various formulas to display the desired result.

4. The Sizing Handle:

The Sizing Handle is a small triangle on the bottom right side of the Defined Table:

The Sizing Handle will allow you to manually resize the Defined Table, you can increase or reduce the number of rows OR columns.

Note that you cannot resize a Defined Table to add more rows and columns in the same time, you need to perform 2 different resizing operations for that.

please mark this answer as a brainliest.