EDUCATION COLLABORATION
    
  Alias   Guest 
      Sketchr    Class Tracker    My Calendar    My Notes    My ToDo Lists
 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:All / Generic : Technology
Created By; DevXel  Last Updated 2/16/2016 6:29:00 PM 
Stats:Attempted; 1023 | Solves: 789
AVG Rating:
       Not logged in. You can take the quizl but we cannot keep your scores. Please login to save, create, rate and share
1 : The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 3rd?



 
 
2 : Are you able to put your lookup values in another sheet or workbook?



 
 
3 : Which column in the lookup range must hold the values?



 
 
4 : The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 1st?



 
 
5 : The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 2nd?



 
 
6 : What is a cell reference?



 
 
7 : Did you enjoy doing this quizl?

 
 
8 : What does V stand for in VLOOKUP?



 
 
9 : How can you 'replicate' the formula?



 
 
10 : The VLOOKUP needs 4 bits of information inside the formula =(1,2,3,4) - Which the 4th?



 







Terms of Service   Terms & Conditions   Privacy   Security   Safety   Contact Us  
quozr.org - DevXel © 2022  |  Online Now:  144