Question 11: When creating a table, ensure that no blank rows or columns exist in the data.

1. True
2. False

Question 12: Tables cannot be filtered by _____.

1. Text Color
2. Cell fill color
3. Cell contents
4. Cell location

Question 13: The Print Selected Table option can be used only after a table cell has been selected.

1. True
2. False

Question 14: The Print Selected Table option can be used only after a table cell has been selected.

1. True
2. False

Question15: Column headings can be entered only in the first row of a table.

1. True
2. False

Question 16: Excel's calculated column feature in tables cannot be deactivated.

1. True
2. False

Question 17: What does an up arrow in a table AutoFilter button indicate?

1. A filter for the lowest values
2. A filter for the lowest values
3. A filter for the highest values
4. A sort from highest to lowest

Question 18: With structured references, formula results adjust automatically as rows and columns are added to or deleted from a table.

1. True
2. False

Question 19: Which of these is not a rule for table column headings?

1. Each one must be unique.
2. Each one must be unique.
3. Certain special characters cannot be used in headings.
4. Certain special characters cannot be used in headings.

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