MS Excel VLookup

Quiz
•
Computers
•
9th - 12th Grade
•
Medium

Pi Ja
Used 12+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
..................search for an item of data in a table and then extract the rest of information relating to that item
................. ek table mein kisi data ki khoj karke aur phir us item se sambandhit baki jaankari nikalta hai
vlookup ()
if ()
count()
sumif()
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
An example of a range address
A1;B3
A1:B3
A1-B3
A1.B3
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
What is the Keyboard shortcut to make a cell absolute reference?
Kisi cell reference ko Absolute cell reference ( $A$2 ) bnane ke liye keyboard shortcut key select krein.
F1
F2
F3
F4
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of these Vlookup functions is searching for an exact match?
In Vlookup functions mein se kaunsa ekdum sahi match khoj raha hai?
=VLOOKUP (True, A2:B6, 2, C16)
= VLOOKUP (C16, A2:B6,3, TRUE)
=VLOOKUP (C16, A2:B6, 3, FALSE)
=VLOOKUP (C16, A2:B6,1, $C$4:$D$15)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
We want to make a Payment Type Column as a drop-down list in a cell. Which feature should we use?
Ham ek "Payment Type" column ko ek cell me drop-down list ke roop mein banana chahte hain. Hamein kaunsa feature istemal karna chahiye?
Conditional formatting
Data validation
Bulleted list
Absolute cell reference
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The first argument in a VLOOKUP function tells the function.................
VLOOKUP function mein pehla argument function ko batata hai.................
What to look for
Where to look
To use an approximate or exact match
The column index number
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What value would excel return for this formula? =(82-32)*5+8*2
Is formula ke liye Excel kis maan (value) ko vapas karega? =(82-32)*5+8*2
230
21
226
26
Create a free account and access millions of resources
Similar Resources on Wayground
12 questions
Spreadsheet Advanced Functions Quiz

Quiz
•
12th Grade
10 questions
Spreadsheets and Charts

Quiz
•
9th Grade
10 questions
KUIS PENGOLAH ANGKA

Quiz
•
10th Grade
15 questions
Excel Lookup Functions Quiz

Quiz
•
6th - 10th Grade
15 questions
Database Validation

Quiz
•
9th Grade
9 questions
Conditional Functions G11

Quiz
•
11th Grade
11 questions
quiz kelas 9

Quiz
•
9th - 12th Grade
14 questions
Ms Excel

Quiz
•
10th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz

Quiz
•
10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
30 questions
Introduction to Computers

Quiz
•
8th - 9th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade