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.Multiple choice

Similar Questions

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:

Question 30 Choose a, b, c or d as the best answer. The author’s main argument is that the 100:80:100 model __________.

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler