MS Excel VLookup

MS Excel VLookup

9th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

Formula VLOOKUP

Formula VLOOKUP

9th Grade - University

15 Qs

MS Excel: Performing Operations using Formulas and Functions

MS Excel: Performing Operations using Formulas and Functions

12th Grade

7 Qs

(ADMINISTRASI SISTEM JARINGAN) EVALUASI DNS SERVER KLS XI

(ADMINISTRASI SISTEM JARINGAN) EVALUASI DNS SERVER KLS XI

11th - 12th Grade

10 Qs

ICT Review

ICT Review

11th Grade

10 Qs

LATIHAN PERTEMUAN 1

LATIHAN PERTEMUAN 1

9th - 12th Grade

10 Qs

Excel 2016-10 2

Excel 2016-10 2

9th - 12th Grade

15 Qs

Data Analysis Quiz

Data Analysis Quiz

10th Grade

10 Qs

IF and Vlookup Function

IF and Vlookup Function

9th - 10th Grade

15 Qs

MS Excel VLookup

MS Excel VLookup

Assessment

Quiz

Computers

9th - 12th Grade

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?