Peter is a data analyst in a financial firm. He maintains a spreadsheet that contains all employee details. Peter wants to analy
ze 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
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.
When somebody writes the answer for your question and posts it on your question it will show a “(crown)mark as brainliest” in blue. click it and it’ll turn yellow and mark the person the brainliest for your question