Instructions:

Select only one dataset from the attached files to complete the tasks below using Excel. Each task is associated with a specific score.

Tasks:

Using VLOOKUP and HLOOKUP $(0\mathrm{.}25$ points each$)$: Complete these tasks individually.

Using the IF function $(0\mathrm{.}25$ points$)$: Complete this task individually.

Using INDEX and MATCH $(0\mathrm{.}25$ points each$)$: Complete these tasks individually.

Applying INDEX with MATCH $(0\mathrm{.}25$ points$)$: Complete this task by combining the two functions.

Combining VLOOKUP with IF $(0\mathrm{.}5$ points$)$: Complete this task by integrating both functions.

Incorporating VLOOKUP with MATCH $(0\mathrm{.}5$ points$)$: Complete this task by combining these two functions.