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