ICT · Information and Communication Technology
A teacher has created a spreadsheet of test marks with a reference table in rows 1 and 2. Row 1 contains the minimum threshold marks: 0 (Col D), 9 (Col E), 14 (Col F), 19 (Col G), 27 (Col H), 33 (Col I), 40 (Col J), and 47 (Col K). Row 2 contains the corresponding grades: U, G, F, E, D, C, B, A. Column B contains the marks of five students starting from cell B4 to B8 as follows: Anil (43), Amit (85), Varun (35), Anita (20), Harish (10). She enters the formula =HLOOKUP(B4, D1:K2, 2, TRUE) in cell C4 and copies it down to the range C5:C8. What values will be returned in the range C4:C8 respectively?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1B, A, C, E, G✓
- 2A, C, E, F, U
- 3B, C, E, G, U
- 4A, C, E, G, F
Correct answer
B, A, C, E, G
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for ICT?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Information and Communication Technology MCQs →Want more practice questions on Information and Communication Technology?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in ICT · Information and Communication Technology