Analyzing and Visualizing Data with Microsoft Excel — Question 28

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?

Answer options

• A. Create a query that uses a file source, and then use the Group By command on the Home tab.
• B. Create a query that uses a folder source, and then use the Group By command on the Home tab.
• C. Create a query that uses a file source, and then use the Count Values command on the Transform tab.
• D. Create a query that uses a folder source, and then use the Count Values command on the Transform tab.

Correct answer: B

Explanation

The correct answer is B because using a folder source allows you to access all files within the folder and group them by their extension. Options A and C incorrectly suggest using a file source, which does not provide the necessary access to all files in the folder. Option D incorrectly uses the Count Values command, which is not suitable for counting file types.