Function Wizard in Excel enables you to:

Correct option is A

The Function Wizard in Excel assists users in applying functions related to various operations, including data visualization. While Excel is primarily used for calculations and data management, it also provides functionalities for creating maps.

With Power Map (3D Maps) and Filled Map Charts, users can generate geographical maps based on data such as country, region, or coordinates. These mapping features are integrated into Excel and allow users to visualize spatial data effectively.

Excel provides the following mapping tools:

• 3D Maps (Power Map): Helps create interactive geographic visualizations using location-based data.
• Filled Map Charts: Introduced in newer versions of Excel, allowing users to create color-coded maps based on country, state, or city data.

Additional Information

1. (b) Construct graphs – Incorrect

   • Graphs and charts are created using the Insert tab, but they are not part of the Function Wizard.

2. (c) Carry out statistical operations – Incorrect

   • While Excel can perform statistical operations, the primary function related to mapping tools allows users to create visual representations of data.