1.brittany lambert is a volunteer for the brevard county swim clubs in melbourne, florida, and has offered to compile data on the swim club employees and teams. she needs your help completing the workbook and analyzing the data. switch to the all employees worksheet. in cell e3, enter a formula using the hlookup function as follows to determine an employee's potential pay rate, which is based on their years of experience: