The university awards scholarships based on financial need (must be yes) and GPA (must be greater than 3.00). Which formula would you use to determine whether to award a scholarship?

Group of answer choices

VLOOKUP

OR

None of the provided answers

HLOOKUP

NOT

What is one logical statement testing whether student 112-20-3647 should receive a scholarship?

Group of answer choices

None of the provided answers

AND(B2>3, D2="Yes")

AND(B2>=3, C2="Yes")

OR(B2>=3, C2=Yes)

AND(B2>3, C2="Yes")

A nested SUMIF statement could be another way of testing whether student 112-20-3647 should receive a scholarship.

Group of answer choices

True

False

When scholarships are awarded, column E shows AWARD. Otherwise, column E shows NO AWARD. Also, column F should show the value of the award if applicable, otherwise it should be blank. Award amounts are calculated as half of the current loan amount. What formula would you use to determine whether to calculate the value of award?

Group of answer choices

SUMIF

COUNTIF

AND

IF

None of the provided answers

What would be the logical statement that you would use to test whether the award is shown for student 112-20-3647?

Group of answer choices

D2=AWARD

AND(E2=AWARD, C2=YES)

None of the provided answers

E2=AWARD

E2=AWARD

What formula would you use to calculate the amount of the value of the award (not whether you should award it)?

Group of answer choices

COUNT

None of the provided answers

SUMIF

SUM

COUNTIF

Imagine you are assisting with scholarship awards at your university. You have the student ID, current GPA, whether there is a financial need, and the loans the student currently has. Please refer to the following spreadsheet to answer the next 6 questions E2 F 1 Student ID 2 112-20-3647 3 235-45-4578 4 120-47-2365 B D E GPA Financial Need Current Loan Award Scholarship? Award Amount? 3.60 Yes $ 8,000.00 2.80 Yes $ 12,000.00 3.00 No $ 5,000.00 5 6 7 00 01 10