Exercise 3: More Excel functions.

You have used absolute references throughout this exercise. However, there is another type of well used reference, Relative Reference. In your own words please describe the difference between relative and absolute references. (Cell B22)

In your own words please describe the difference between vlookup and hlookup function. (Cell J22)

Fill out the table A1 to J13 following the instructions below:

Step 1:

Using a conditional statement in column E, find out if the student is eligible for a CPA. They must be either an Accounting or Finance major and a senior in college.

Step 2:

Using a conditional statement in column F, find out if the student is eligible to be the president. They must be a senior with a GPA above 2.5

Step 3:

Using a conditional statement in column G, find out if the student is eligible to be a mentor. They must be a junior or senior with a GPA above 3.5.

Step 4:

Using a conditional statement in column I, find out if the student is eligible for honors. They must be a senior with a GPA above 3.5.

B C D E F G I J K L M N 0 P Eligible for President Eligible to Mentor GPA Eligible for Honors 1 Student ID 2 ABC123 3 BRE234 3.5 2.3 3.7 SER456 RER4444 3.9 Hnm + L O N 0009 Student Name Major Year at College Eligible for CPA Abby Cook Finance Freshmen Brian Edward Accounting Junior Sam Johnson MIS Sophomore Ramesh Reddy MKT Freshmen Peter Parker Management Senior Fred Dicker Supply Chain Senior Harry Potter Accounting Sophomore John Edward MKT Junior Kaitlyn Xu Management Junior Samantha Burrow Finance Senior Grace Willams MIS Freshmen Lisa Miller Supply Chain Senior 3.1 3.9 2.9 3.8 3.75 2.3 3.9 6 PER234 7 FED55555 HGF6678 9 JOG68745 10 KDFEGH4 11 SDEF345 12 GHJ67 13 LSVG345 14 15 16 17 18 19 20 21 3.85 22 Difference between Absolute and Relative References: Difference between VLOOKUP and HLOOKUP Function : 23 24 25 26 27 28 29 30 31 32 33