Excel Certification - Lookup Functions

The last (4th) attribute for the VLookup Function is True or False. We use True when you are looking for an exact match closest match

an exact match

The last attribute of the VLookup Function is either True or False. We use False when we are looking for closest match closest lowest match an exact match closest highest match

closest lowest match

With a VLookup using approximate match always sort your range ... from lowest value up to highest value In any order it doesn't matter from highest value down to lowest value

from lowest value up to highest value

How do we skip optional parameters in an XLookup leave them blank and just put in a comma You can skip optional parameters put in an empty string "" Put in null and then a comma

leave them blank and just put in a comma

What is the difference between the ? and the * as a wildcard this is a trick question you cannot use the ? as a wildcard Nothing they are both the same * means anything or nothing - ? means just one character * means must be multiple characters , ? means must be one character

* means anything or nothing - ? means just one character

The 3rd parameter of the Match() Function is the match type. Can you match up the numbers that represents each match type below: Numbers: -1 0 1 Match Type: Exact Less Than Greater Than

-1: Greater Than 0: Exact 1: Less Than

Which one of these is NOT a match mode for the XLookup Exact Match or most similar item Wildcard Character Match Exact Match or next smallest item Exact Match or next largest item Exact Match

Exact Match or most similar item

The _________ formula is often used in conjunction with the match function as an alternative to a lookup.

Index

In a VLookup Function the value for the 3rd attribute can be the column number or column name that we want to return True False

False

The XLookup Function is available in Office 2103, 2016 and all versions of Office 365 True False

False

The main difference between a VLookup and a HLookup is that the VLookup is Virtual and the HLookup uses Hyperlinks. True False

False

VLookUp Stands for Virtual Lookup True False

False

If we create a VLookup formula that we want to fill down using the fill handle it is very important to remember to change the Range used for the 2nd attribute to an absolute range. False True

True

It is possible in Excel to use one of the Lookup functions to lookup a record in another workbook True False

True

The match function brings back a number as a result False True

True

When doing a vlookup to another workbook, when you select the range using your mouse, the ranges will automatically go in as an absolute range False True

True

Which of the following are different types of Lookup Functions? (Choose all that apply) XLOOKUP IDLOOKUP VLOOKUP HLOOKUP

XLOOKUP VLOOKUP HLOOKUP

Which of the following are optional parameters we can use with the XMatch() Formula which are not available with the Match() Formula Can use Wildcards in the search can change the search mode can bring back the nth match can bring back multiple matches

Can use Wildcards in the search can change the search mode