Multiple Choice
Given a student's numerical average and a table that lists the grades and percent needed to obtain the grades in column format,which Excel function would be used to determine the student's letter grade?
A) MATCH
B) INDEX
C) HLOOKUP
D) VLOOKUP
Correct Answer:

Verified
Correct Answer:
Verified
Q86: When cell D3 containing the formula =C4*B4
Q87: The result of =LEFT("Dallas,Texas",9)is _.<br>A) as, Texas<br>B)
Q88: To find the greatest numerical value in
Q89: The result of =MID("Tallahassee",6,3)is _.<br>A) Tall<br>B) lahass<br>C)
Q90: =$B$2 - C5 is an example of
Q92: When cell B3 containing the formula =$B4-C$5
Q93: To modify a named range,you select its
Q94: $C$8 is an example of a(n)_ cell
Q95: Excel's _ function returns only the current
Q96: Functions can be created by using the