. In this scenario, each employee has to travel a lot for a company's business. So, the company decides to have a rule to compensate for the miles they travel. The company will pay 40 cents for the miles that the employees travel more than 100 miles. For example, if an employee travels 120 miles, he/she will be reimbursed for $8 (i.e., 20 *0.4). Use If Function in cell F5 to calculate Travel Reimbursement. 2. Enter the formula in cell G5 to calculate Adjusted Pay, which is equal to the "Base Pay" plus "Travel Reimbursement" 3. Using the fill-handle to copy the function/formula from cells F5 and G5 to compute travel reimbursement for all employees. 4. Please note that typing the answer (i.e., a number) directly into the cells will be graded as incorrect answers) Employee Name Allan Allison Amanda Audrey Cassandra Dwight Katie Roy Wesley Weslie Westley Base Pay WorkDate $275.00 $300.00 $400.00 $300.00 $275.00 17-Aug-04 5-Aug-04 10-Aug-04 1-Aug-04 3-Aug-04 $300.00 16-Aug-04 $500.00 26-Aug-04 $270.00 8-Aug-04 $300.00 14-Aug-04 $300.00 17-Aug-04 $275.00 4-Aug-04 Travel Miles 50 140 200 90 80 140 30 140 90 140 140 Travel Reimbursement Adjusted Pay