Câu 30: 70-779: Analyzing and Visualizing Data with Microsoft Excel

Your network contains a folder that has data files in various formats. You need to identify how many files of each extension type are in the folder by using Query Editor. What should you do?

1. A. Create a query that uses a file source, and then use the Group By command on the Home tab.
2. B. Create a query that uses a folder source, and then use the Group By command on the Home tab. — đáp án hiện tại
3. C. Create a query that uses a file source, and then use the Count Values command on the Transform tab.
4. D. Create a query that uses a folder source, and then use the Count Values command on the Transform tab.