A

B

C

D

E

F

1

Score

0%

60%

70%

80%

90%

2

Letter

E

D

C

B

A

Given the table above, which formula will give the letter grade if the score is located in cell H6, and the score is not an exact match?

Question

A

B

C

D

E

F

1

Score

0%

60%

70%

80%

90%

2

Letter

E

D

C

B

A

Given the table above, which formula will give the letter grade if the score is located in cell H6, and the score is not an exact match?

BlackTom AI · Accepted Answer

The question presents a table organized horizontally, where the top row contains the scale markers (A through F) and the second row contains the corresponding letter grades. The score is located in H6, and we’re told the score is not an exact match, so we need an approximate, not exact, lookup across a horizontal array.

Option A: =VLOOKUP(H6, B1:F2, 2, TRUE)
- This uses VLOOKUP, which searches vertically in the first column of the specified range. Our data is arranged horizontally across columns, not vertically down a single first column. Therefore VLOOKUP is not appropriate for this layout, and using TRUE for approximate matching in this vertical context will not correctly map a score to the corresponding letter.

Option B: =HLOOKUP(H6, B1:F2, 2, FALSE)
- This uses HLOOKUP, which is the right function for a horizontal lookup across the top row. However, the FALSE parameter requests an exact match. Since the problem states the score is not an exact match, an exact-match lookup will fail to find a match for non-exact scores, yielding an error or the closest non-ideal result.

Option C: =VLOOKUP(H6, A1:F2, 2, FALSE)
- Again, VLOOKUP is the vertical lookup function, inappropriate for the horizontal table arrangement. Additionally, FALSE for exact match would require an exact value in the first column of A1:F2, which is not how the data is structured for mapping a continuous score to a letter grade.

Option D: =HLOOKUP(H6, B1:F2, 2, TRUE)
- This uses HLOOKUP, which suits a horizontal table, and TRUE for approximate (not exact) match, which aligns with scoring scenarios where a score falls between the thresholds defined in the top row. The range B1:F2 covers the header row and the grade row, and index 2 retrieves the corresponding letter from the second row. Using TRUE lets Excel find the largest value less than or equal to the lookup value, which is the standard method for mapping a continuous score to a grade band in an approximate lookup.

In summary, the correct approach for a horizontal table with non-exact scores is to perform an approximate, or closest-by-less-than, match using HLOOKUP on the appropriate range, which is exactly what option D implements. The other options misuse vertical lookups for a horizontal layout or require exact matches, which are incompatible with the non-exact scoring scenario and the given table structure.

CSE 2111 AU2025 (10550) Post-Test Quiz

A B C D E F 1 Score 0% 60% 70% 80% 90% 2 Letter E D C B A Given the table above, which formula will give the letter grade if the score is located in cell H6, and the score is not an exact match?

查看解析

登录即可查看完整答案

类似问题

A B C D E F 1 Score 0% 65% 75% 85% 95% 2 Letter F D C B A Given the table above, which formula will return the letter grade if the score is in cell G4 and may not exactly match one of the percentage breakpoints?

Study the screenshot above.What formula is needed in cell B11 to return the Student name that has the lowest English mark?

Study the screenshot above.What formula is needed in cell B11 to return the Item name that has the lowest total cost?

Look up the Employment Status from the Exit Poll Respondents worksheet. How many of the respondents on the "Conversion" worksheet are Retired?

For the HLOOKUP function, the lookup_value must be in the first row of the table array.

Complete the following statement: The lookup vector in a LOOKUP function:

Study the screenshot above.What formula will need to be entered in cell B11 to return the Student name that has the highest Computing mark?

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单