Debra launched her start-up in 2016.After 2 continuous years of losses,she needs to now downsize.She has salary details of all employees in a spreadsheet report.Which of the following features should she use to decide how many people to layoff,and who?
A) VLOOKUP
B) What-if analysis
C) Pivot table
D) Relative referencing

Question

Quizplus · Accepted Answer

What-if analysis allows Debra to create different scenario models to see how layoffs will affect the financials of the company. She can adjust variables such as number of employees, salaries and benefits to come up with the best possible solution. VLOOKUP and Pivot table will not provide information on how downsizing affects the financials of the company. Relative referencing is a basic feature used to copy formulas and will not help in this scenario.

Debra Launched Her Start-Up in 2016