Which Excel Add-In Will Help You Find a Target?
Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> Which Excel Add-In Will Help You Find a Target?
Question
Which Excel Add-In will help you find a target?- Analysis Toolpak
- Solver
- Power Query
- Power Pivot
- Power BI
Answer
B. SolverExplanation
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