True/False

1. We can sort our data up to 3 levels.

2. The Filter is used to for easily collecting data through patterns without using the fill tool.

3. We can Use an Outline to quickly display summary rows or columns.

4. Excel can pull data from the external resources also.

5. The Filter allows you to easily extract matching records from a larger set of source data based on criteria you provide.

6. The Consolidate allows you to gather together your data from separate worksheets into a master worksheet.

7. The Flash fill feature splits text in a cell into multiple columns.

8. We can’t splits text in a cell into the multiple columns.

9. The Flash fill automatically fills your data when it senses a pattern.