Which of the following functions, entered in E2 and filled down, will return (display) excellent from the Grade Table below the data. Choose all answers that are correct, but choose carefully! If you choose an incorrect answer, you will receive no marks for this question.

Question

BlackTom AI · Accepted Answer

XLOOKUP's match_mode -1 returns an exact match or the next smaller lookup value, so using the numeric Final Result against the ascending Mark thresholds will return the correct threshold comment (e.g., 90.6 → threshold 85 → "excellent").

1) Relevant knowledge points and concepts
- XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode]) — default match_mode = 0 (exact). match_mode = -1 means "exact or next smaller"; match_mode = 1 means "exact or next larger".
- To map numeric scores to thresholded comments, you lookup the numeric score in the Marks column and return the Comment column using an approximate-match mode that picks the largest threshold ≤ score.
- Alternatively you can lookup the Grade letter exactly in the Grade column and return the corresponding comment.

2) Step-by-step reasoning for each option
a. =XLOOKUP(C2,$A$10:$A$13,$C$10:$C$13,,-1)
- lookup_value = C2 (Final Result, e.g. 90.6).
- lookup_array = A10:A13 (Marks: 0, 50, 70, 85).
- return_array = C10:C13 (Comments).
- match_mode = -1 (exact or next smaller). For 90.6 no exact; next smaller threshold is 85 → returns C13 "excellent". So this yields "excellent" for scores ≥85 (correct).

b. =XLOOKUP(C2,$A$10:$A$13,$C$10:$C$13,,1)
- match_mode = 1 (exact or next larger). For 63, next larger threshold is 70 → returns "above average" which is wrong for a 63 (should map to 50 → "satisfactory"). So b is incorrect.

c. =XLOOKUP(D2,$B$10:$B$13,$C$10:$C$13)
- lookup_value = D2 (Grade letter, e.g. "A").
- lookup_array = B10:B13 (Grade: Fail, C, B, A).
- return_array = C10:C13 (Comments).
- Default match_mode = 0 (exact). For Grade "A" it finds B13 and returns C13 "excellent". This correctly returns "excellent" for rows whose Grade is A. So c is correct.

d. =XLOOKUP(D2,$A$10:$S$13,$C$10:$C$13)
- lookup_array is a multi-column block (A10:S13) rather than a single column; XLOOKUP expects a single-dimension lookup_array. Also the lookup_value is a letter (e.g. "C") which won’t match properly against the marks in column A or the mixed range. This is invalid/incorrect.

3) Intermediate/example calculations
- Example student Widjaja: Final Result = 90.60, Grade = "A".
  - a: XLOOKUP(90.6, {0,50,70,85}, {"repeat","satisfactory","above average","excellent"},, -1) → next smaller threshold 85 → "excellent".
  - c: XLOOKUP("A", {"Fail","C","B","A"}, {"repeat","satisfactory","above average","excellent"}) → exact match at "A" → "excellent".

4) Why the correct answers are correct
- Option a uses numeric approximate lookup (exact or next smaller) against the ascending threshold marks, so scores >=85 map to the 85 threshold comment "excellent".
- Option c uses exact match on the Grade letter and returns the comment mapped to Grade "A" which is "excellent".

5) Why the other options are incorrect
- b uses match_mode = 1 (exact or next larger), which maps many scores to the wrong higher threshold (e.g., 63 → 70 → "above average"), so it fails.
- d uses an improper lookup_array (multi-column range) and mismatched ranges; it will not reliably return the correct comment.

6) Conclusion
Options a and c are correct; options b and d are incorrect. This matches the provided correct answers: a and c.

Which of the following functions, entered in E2 and filled down, will return (display) excellent from the Grade Table below the data. Choose all answers that are correct, but choose carefully! If you choose an incorrect answer, you will receive no marks for this question.多项选择题

类似问题

If the lookup value is not found, what does XLOOKUP return (display)?

If the lookup value is not found, what does XLOOKUP return (display)?

In an XLookup function, result_array refers to:

In which security measure will you find anti-virus software?

What are user permissions?

Which security measure will stop someone reading your messages if they find your smart phone?

On a network a firewall

What is the name for emails that are sent to users, pretending to be from their bank and asking for username and password?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单