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

1. True
2. False

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

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

1. True
2. False

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.

Answer rating: 100% (QA)

1 True 2 Filter for the lowest ... View the full answer