E10 answerkey mc - Multiple Choice answers PDF

Preview

Summary

Multiple Choice answers...

Description

Multiple Choice Answer Key Exploring Microsoft Excel, Chapter 10 1. A special character that is used to separate a text file is called a: b. delimiter 2.

Which of the following file formats cannot be imported using Get & Transform? d. MP3

3.

Which of the following Power BI tools is best suited for editing data before import? c. Power Query Editor

4. In which of the following scenarios would you choose to embed versus import data? d. You do not want to save the original data sources. 5.

When creating a 3D Map, what is the best way to view your data from different perspectives over time? b. Add scenes

6.

What tool should be used to remove fields and format data when importing? a. Power Query Editor

7.

What Power Add-In is best for visualizing geospatial data? d. 3D Maps (Power Map)

8.

Which of the following is not a dimension of a 3D Map layer? a. Columns

9.

Which of the following tools can be used to aggregate relational data from multiple sources? a. Power Pivot

10. Which of the following is not a benefit of shaping data with the Power Query Editor? d. Shaped data does not retain links to external file sources

Copyright © 2020 Pearson Education, Inc....