5.9.5 Excel Table Facts

What are sparklines?

• Mini-charts that illustrate trends over time

• Tables that organize large data sets

• Formatting options for cells in Excel

• Filters used to sort data in Excel

What is the purpose of the Table Name feature?

• To give a unique name to the table

• To remove duplicate data from the table

• To convert the table into a range

• To add a header row to the table

How can duplicate data be removed from a table?

• By clicking Remove Duplicates

• By converting the table to a range

• By enabling the Total Row

• By using the Filter Button

What does the Total Row feature do?

• Adds a row displaying the sum of numbers in each column

• Adds a row displaying the average of numbers in each column

• Adds a row displaying the maximum value in each column

• Adds a row displaying the minimum value in each column

What is the purpose of the Filter Button in a table?

• To sort and filter data based on certain criteria

• To toggle the header row on and off

• To enable or disable banded formatting

• To apply preset designs to the table

What does the Banded Rows/Columns feature do?

• Enables or disables alternating row formatting

• Adds a total row to the table

• Shows or hides the Filter buttons in the table

• Applies preset designs to the table

How can data in a table be sorted?

• Numerically or alphabetically

• By removing duplicates from the table

• By converting the table to a range

• By applying conditional formatting

What is the purpose of Conditional Formatting?

• To format cells that meet a certain criterion

• To remove conditional formatting from the table

• To manage and reorder existing rules in the worksheet

• To highlight the highest or lowest values in a range of cells

What does the Format as Table button do?

• Converts selected data into a table

• Applies conditional formatting to the table

• Adds a total row to the table

• Enables or disables alternating row formatting

How can conditional formatting rules be managed?

• Using the Manage Rules option

• By clicking the New Formatting Rule button

• By using the Clear Rules option

• By applying Table Styles to the table