Which Excel Add-In Will Help You Find a Target?

Question

Which Excel Add-In will help you find a target?

1. Analysis Toolpak
2. Solver
3. Power Query
4. Power Pivot
5. Power BI

Answer

B. Solver

Explanation

Analysis Toolpak and Power Pivot are add-ins for data analysis while Power BI is for data visualization and Power Query is for data queries.

Among those five add-ins, Solver seems to be the most correct answer choice as it can help us to find input targets for formulas so they can achieve their most optimum outputs. It is like a more advanced version of the Goal Seek feature in Excel.

Go back to the Compute Expert's excel quiz page