Question

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

Answer 1

B. What-if analysis

Step-by-step explanation:

Based on the information provided within the question it can be said that in order to decide how many people to layoff and who she should use a what-if analysis. This refers to the process of changing values in an excel spreadsheet and seeing how those changes affect the rest of the spreadsheet. Therefore by removing individuals from the spreadsheet she can see all the effects it will have on the rest of the company and then choose the one that returns the best outcome for the company.