What is an advantage to using vlookup or xlookup compared to copy/paste? O The lookup functions allow for more transparency of how you retrieved a cell value. The lookup formulas are less prone to errors. For example, errors or NA will be returned if a value is not found instead of accidently pasting an incorrect value. O Vlookup and Xlookup have additional functionality beyond copy/paste, such as finding a closely matching value (for vlookup), or a value that is lower or higher than the reference value (xlookup). O All of the above.is the third argument in the Vlookup formula whereas is the third argument in the xlookup formula. A. The column number containing the values you want Excel to return; what you want Excel to enter if an error has occured B. What you want Excel to enter if an error has occured; the cell range containing the values you want Excel to return C. The column number containing the values you want Excel to return; the cell range containing the values you want Excel to return 0 D. The column number containing the values you want Excel to match to your reference value in argument 1; the cell range containing the values you want Excel to return In XLookup, the second argument includes O The cell range containing the value you want Excel to return. The cell containing the value you want Excel to return. The cell range that you want Excel to search in to find the value from the cell entered in the first arguement. O None of these are correct.What is the purpose of putting $ around the lookup ranges in both vlookup (e.g., $A$2z$E$50) and xlookup (e.g., $A$2z$A$50) formulas? A. The $s ensures that the lookup ranges will be "relative" and adjust as you drag the formula around the Excel sheet. B. The $ is used to indicate you are selecting a range rather than just a single cell. C. There is no functional reason. However, the $ reminds you that this is a range of cells. D. The $3 ensures that the lookup ranges will not change as you drag the lookup formula into another cell. When using Vlookup, the first argument refers to what? A. The cell range that you want Excel to search in. B. The cell containing the value that you want Excel to search for in the rst column of the data range you enter. C. The column containing the corresponding value that you want Excel to return. D. None of these are correct