Debra tracks her business finances in a spreadsheet.She wants to figure out how much she could increase profits if she raises prices on some products.What feature should she use to find the answer?
A) VLOOKUP
B) What-if analysis
C) Pivot table
D) Relative referencing

Question

Quizplus · Accepted Answer

What-If Analysis is a feature in Excel that helps to answer hypothetical questions about the data by changing one or more inputs, and observing the impact on the results. In this case, Debra can use the Goal Seek function in What-If Analysis to determine the ideal price increase that would maximize profits.

Debra Tracks Her Business Finances in a Spreadsheet