Name Box Department Information Systems Marketing Finance Marketing Finance Mark
ID: 364628 • Letter: N
Question
Name Box Department Information Systems Marketing Finance Marketing Finance Marketing Finance Marketin Finance GPA 75 85 GMAT score 567 553 645 741 experience Experience Level average Applicant id School based Finacial aidDepartment based Finacial aid Domestic Internationa Domestic International International Internationa International International International International International Domestic Domestic Domestic Domestic Domestic International Domestic Domestic Domestic IVALUE! 10 10 95 92 87 607 619 97 85 90 10 a nformation Systems 611 691 628 average Finance Marketing Information Systems Marketin Finance Information Systems Finance Marketing Information Systems Marketing 12 13 723 627 655 631 670 590 87 96 average average 15 16 17 18 10 83 89 91 20Explanation / Answer
1.
Lookup value: the value to be found in this excel is in the GPA column
Table array: The table of information to be looked up is in the School based financial aid look up table.
Hence the formulae will be hlookup(D2:D20,GPA school based financial score row selection,4,false)
2.
This can be done with the If function as below:
=IF(E3<600,"Not qualified","qualified")
E3 represents G Mat score
Applicant id
Origin
Department
GPA
GMAt Score
Experience
Experience level
School based financial aid
Department based financial aid
1
Domestic
Information System
75
567
4
average
Not qualified
International
Marketing
85
553
10
high
Not qualified
Domestic
Finance
80
645
10
high
qualified
Applicant id
Origin
Department
GPA
GMAt Score
Experience
Experience level
School based financial aid
Department based financial aid
1
Domestic
Information System
75
567
4
average
Not qualified
International
Marketing
85
553
10
high
Not qualified
Domestic
Finance
80
645
10
high
qualified
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.