please answer ALL

QUESTION 1 What is data validation as discussed in the lecture? A best practice that makes sure your formulas are typed correctly. A way of determining the validity of any source data. A metric for data accuracy. A way of restricting the values that a cell can contain. What is one comman source of a lookup not working as discoussed in the lecture? Lookups are occasichaly not given enough dats. The kokup value between the fwo datasets is not identica due to an exea space of some other afterenoe that is hard to notice Lookups aways require the use of the TRIM() functicn, and sometimes people forget to use it sonsetimes a vookup is used when an xookip should be used instead QUESTION 4 What is the peimary deteronoe betwoen viookup and xicokup in torms of thei abity to generate output? Vookups cart provide output wor deta validation, whle xlockups can. Vookigs require fixed ced references over the daka you eve searching, while xbokups to not Vookups search verticelly, xbookups are crnidirectional. Vookup can only return oce colimn of cutput at a time, Xlookup can return many columns of oitput