EDUCATION
COLLABORATION
select
DASHBOARD
SETTINGS
PERSONAL PROFILE
MY COURSES
MEMBERSHIPS
ASSESSMENT
BADGZ
QUIZLZ
STICKLRZ
IMAGE WALLS
SPUZLZ
POLLS
REVIZRZ
WEBSITES
qDOCS
MY BLOG
PERSONAL CLOUD
SIGN UPS
LINKS
VIDEOS
BRAINRZ
SIGN IN/UP
Please Sign In
You do not need to sign in to view quozr content, but if you wish to create content then please sign in or sign up. It's completely free.
SIGN OUT
Hi
IF YOU ARE ON A PUBLIC COMPUTER, ALWAYS SIGN OUT.
SIGN OUT NOW
Sign In
Sign Up
Remember me
What's This?
A cookie will be set that remembers who you are.
You will then be automatically signed in each time you visit. To delete the cookie click your avatar and then 'Sign Out' from the top right corner of the page.
:
Forgotten your password or username?
SIGN IN TO QUOZR.ORG
CANCEL
Or...
Quozr.org
By using quozr.org, you agree to our
Terms and Conditions
Home
Courses
⇩ badgz
About / Demo
Public Shared
⇩ Websites
About Webs / Sites
⇩ Revise
revizrz
notrz
Sticklrz
Spuzlz
Gantt chart
⇩ Toolz
Polls
Spuzlz
Walls
qr codes
eCards
links
videos
Brainrz
Sign Up Sheets
protons
⇩ Community
Forums
Blogs
Polls
Spuzlz
Knowledge-Base
Contact
⇩ About
Notifications
Policies
Road Map
Guest
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
QUIZLZ
All QUIZLZ
VLOOKUP
Instructions:
KEEP TAKING THE QUIZL UNTIL YOU SCORE 100%
NOTE : THE ORDER OF THE QUESTIONS AND CHOICES ARE RANDOMISED EACH TIME !
Description:
Quick basic quiz on the VLOOKUP function
Level : Subject:
I/GCSE - Middle School
:
Various
Created By;
devxel
Last Updated
2/16/2016 6:29:00 PM
Stats:
Attempted;
No Attempts
| Solves:
Never Solved
AVG Rating:
1
2
3
4
5
Not logged in. You can take the quizl but we cannot keep your scores. Please login to save, create, rate and share
1 :
Which column in the lookup range must hold the values?
2
0
1
10
2 :
The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 4th?
The cell reference
Whether it matches the exact value of not
Column NUmber
The Workbook Name
3 :
How can you 'replicate' the formula?
Write out for each individual row
Copy & Paste
Take a photograph
Get the little 'handler' in the right hand corner of the cell with the formula in and drag it down
4 :
What does V stand for in VLOOKUP?
Velocity
Veronica
Vertical
Variable
5 :
The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 1st?
The cell reference
TRUE / FALSE
=
The column number that returns the value
6 :
The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 3rd?
TRUE / FALSE
The cell reference
The identifier
The column number that returns the value
7 :
The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 2nd?
The Variables
A7$
The Named Range
TRUE / FALSE
8 :
Did you enjoy doing this quizl?
Yes
No
9 :
What is a cell reference?
A Letter
A number
The Letter and Number that identifies the cell
A7F
10 :
Are you able to put your lookup values in another sheet or workbook?
Perhaps
No
Yes
Sometimes
Check Your Answers
Loading .....
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Terms of Service
Terms & Conditions
Privacy
Security
Safety
Contact Us
quozr.org - DevXel © 2023 | Online Now:
14
COOKIES
We use cookies to ensure you get the best experience on our website.
GOT IT!
TELL ME MORE