Question 1

Refer to Assignment 1 MS Excel file and complete the following task within the same worksheet (all answers should be displayed in the same worksheet):

A. Use appropriate lookup function to identify the salary for the following employee ID:

E10203

E10208

E10212

E10218

B. Use appropriate lookup function that will return both employee name and department for the employee ID mentioned in part A above.

C. PAYE tax is based on the annual salary income earned by employees. Complete the table using appropriate lookup function to fill in the PAYE tax rate column. Use appropriate function to complete PAYE tax amount in dollars.

D. Use appropriate formula to determine the highest salary.