You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year. What is the best way to create the list?
Answers
Answer:
Best way to create the list
Explanation:
The best way for you to create the list of those who make more than 15000 and are full time is by using the filter option.
The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 15000
The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.
The sorting method helps to arrange data based on ascending order or descending order.
You manage the worksheet shown below and it contains information for the company's 1500 employees.
https://brainly.in/question/49650166
You manage the worksheet shown below and it contains information for the company's 1500 employees,
brainly.com/question/15358155?referrer=searchResults
#SPJ2
Answer:
The best way to create the list - Add a blank column between Columns B & C, click in cell A2 and select Sort.
Explanation:
The best way for you to create the list of those who make more than 15000 and are full time is by adding a blank column between Columns B & C, click in cell A2 and select Sort or by using the filter option.
To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Right-click the selection, and then select Insert Columns.
The filter in a spreadsheet helps to put data in a particular category then arrange them based on the criteria that you selected.
The sorting method helps to arrange data based on ascending order or descending order.
The filter option would be used to highlight the people that are in full employment. After this you have to use the sort to check the compensation column in order to establish those that make more than 15000
For more :
https://brainly.in/question/15936874
#SPJ3