Question: what are the characteristics of the format as table feature?
Answer: By using the Format as Table icon you instruct Excel to treat a table like a basic database. Formatted tables have many advantages, such as: The table range automatically expands (including the format) when you add new rows or columns to the table. Filter icons are automatically added to the header row.