Question

you manage the worksheet shown below that contains a list of employees and a list of building numbers. the employee list is 1500 rows of data. what is the easiest way to sort the employee list without affecting the building number list?

Answer 1

The easiest way to sort the employee list without affecting the building number list is by using the data sort function.

There are several programs for creating tables and managing data. One of them is Microsoft Excel, in this program, you can integrate, manage, organize, save and modify data.

In the situation where I manage a list of employees and a list of building numbers of about 1500 data and I need to organize them without affecting the other lists, I must follow the following steps.

1. Select the list that I want to organize, for example, column B.
2. I click on the data option and then on the order option. At that moment, a warning will appear telling you that I have more data in my table (in this case the list of building numbers) and it will ask if I want to include it in the organized action.
3. I mark the option to Continue with the current selection and I give it to order.
4. At this moment another window opens where they give me different options to organize my data, for example alphabetically from A to Z or from Z to A, or I can customize it.
5. Subsequently, I give it order and the list organizes the data as I wish.

Learn more in: https://brainly.com/question/23567635