Question 20: Which statement is incorrect regarding tables?

1. A worksheet list can be converted to a table.
2. Tables cannot be modified; you must re-create them if you want to make changes
3. When creating a table, you can change the range that Excel suggests
4. Formatting can be applied after the table has been created.

Question 21: Table names can include both spaces and underscores.

1. True
2. False

Question 22: You cannot customize table filters.

1. True
2. False

Question 23: Banded columns contain light and dark fills that alternate for each column to aid in readability.

1. True
2. False

Question 24: Which of these is not a depreciation function?

1. WA
2. SYD
3. SLN
4. DDB

Question 25: What is not a component of a structured reference in a table?

1. Brackets
2. The @ symbol
3. The column heading name
4. The column heading cell reference

Question 26: Which of these is not a feature of an Excel table?

1. Automatic expansion
2. Calculated columns
3. Default conditional formatting
4. Filtering