VLOOKUP
   Guest   
Q

 

1) When we create our range of values to Lookup, the numerical range of values must be in the first column - Is this true or false? [1]

 

2) How do we 'name' our range of values? [2]

 

3) How is a VLOOKUP Function Formed starting from = in the function bar ?, explain each part. [4]

 

4) The last part of the function is either TRUE or FALSE. What is the difference between these? [2]

Out of / 9 marks

Your Work
You are not logged in! You can answer but you cannot save your work.    SIGN UP   SIGN IN
Times Taken 0  
 

RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
   
Toolbar's wrapper 
 
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
  
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
   
 
Spin UpSpin Down
  

   Created by : devxel  2/16/2016 6:43:19 AM - Quozr revizrz  (©) 2023