A colleague gives you a spreadsheet containing the personnel records of all
department employees. Employees are added to a row at the bottom of the
spreadsheet as they're hired. As a result, you have to scan the entire spreadsheet to
find the information for employees. What is the best way to resolve this problem?
Search for each employee's data you want to work with.
Apply a data sort to your copy of the spreadsheet, so that employees are in
alphabetical order by name.
Apply a filter to display just the employee data you want to work with.
Request that the colleague restructure the spreadsheet so that employees are
added in alphabetical order instead of by hire date.