Question

Peter is a data analyst in a financial firm. He maintains a spreadsheet that contains all employee details. Peter wants to analyze the data of all employees that have experience of more than five years. Which technique can Peter use to perform this analysis?
A. sort the data of employees with up to five years of experience

B. filter the data of employees with more than five years of experience

C delete the data of employees with less than five years of experience

D. sort the data of employees with more than five years of experience

Answer 1

Answer:

The option B is correct. Filter the data of employees with more than five years of experience.

Explanation:

Filter is a feature in spreadsheets which let you see the data required to see based on some condition. Only the filtered data is shown and other is skipped for current view. So if there is any column in spreadsheet for employees experience than filter it with the selecting the filter to more than five years. Less than five and 5 option will be unchecked and other remain checked.

I hope it will help you!