Excel: Lesson 9 Review

What is the easiest way to add alternating colors to the rows of your spreadsheet?

• Create a table

• Change the color scheme

• Resize the table

• Convert to Range

When creating a table, what should you do if you have a total row?

• Delete the total row before creating the table

• Keep the total row as part of the data

• Move the total row to its alphabetical location

• Select the Total Row check box on the Design tab

What should you do if your data doesn't have headers before creating a table?

• Clear the My table has headers check box

• Keep the data without headers

• Create a new row for your column headers

• Select the Header Row check box on the Design tab

How can you easily change the color scheme of your table?

• Select any of the options in the Table Styles group

• Resize the table

• Convert the table to a range

• Adjust the table style and format manually

What should you do if you want table formatting but don't want any other table functionality?

• Resize the table

• Convert the table to a range

• Adjust the table style and format manually

• Select the Convert to Range button on the Design tab

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