Vlookup Revision Starter

Vlookup Revision Starter

9th - 11th Grade

8 Qs

quiz-placeholder

Similar activities

Xcode and Playgrounds

Xcode and Playgrounds

9th - 11th Grade

9 Qs

สอบเก็บคะแนน ไพทอน ม.4

สอบเก็บคะแนน ไพทอน ม.4

9th - 12th Grade

10 Qs

Quiz 3-  Life Cycle of Program

Quiz 3- Life Cycle of Program

10th Grade

10 Qs

MS eXCEL 11TH

MS eXCEL 11TH

11th Grade

10 Qs

conditional constructs in Java

conditional constructs in Java

10th Grade

10 Qs

Microsoft Publisher

Microsoft Publisher

7th - 10th Grade

10 Qs

conditional and iterative statements

conditional and iterative statements

11th Grade

10 Qs

BTEC Level 3 Nat Ext Dip in Computing - Unit 2.1 Hardware and Software

BTEC Level 3 Nat Ext Dip in Computing - Unit 2.1 Hardware and Software

11th - 12th Grade

10 Qs

Vlookup Revision Starter

Vlookup Revision Starter

Assessment

Quiz

Computers

9th - 11th Grade

Practice Problem

Medium

Created by

Stuart Brown

Used 50+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

$B$15 is an Absolute Reference

True

False

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

VLOOKUP() searches in the first row of the table.

True

False

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

A named range is a relative reference

True

False

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

IS this the correct syntax for VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])?

True

False

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

It is best to use a named range for the table reference in VLOOKUP, especially if you want to copy the formula.

True

False

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

VLOOKUP() stands for Virtual Lookup

True

False

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

The cell reference in a relative reference do not change when you drag a formula

True

False

8.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

HLookup is Vlooup but turned 90 degrees clockwise

True

False