The VLOOKUP function can be used to handle missing values in sales data. Which of the following statements is true?AVLOOKUP can identify and highlight missing values in the data.BVLOOKUP can automatically fill in missing values in the data.CVLOOKUP cannot handle missing values in sales data.DVLOOKUP can remove missing values from the data.

Identify the correct Lookup formula =LOOKUP(b2,Sales,2,0) HLOOKUP(b2,Sales,2,0) =VLOOKUP(b2,Sales,2,0) None of the above

Which of the following is NOT true for VLOOKUP()? 1 pointThe main difference between HLOOKUP() and VLOOKUP() is that HLookUp looks for the specified value across the top row while VLookUp looks for it in the left-most column.VLOOKUP() is only able to return one value at a time.If a user places an invalid value in the LookUp_value the function is able to tell the user that the value inputted isn’t in the table.The results column needs to be part of the defined lookup table.

Which of the following is NOT possible with VLOOKUP?*You can lookup values located in a different worksheet.You can lookup values located in a column to the right of the column that contains the lookup value.You can lookup values located in a column to the left of the column that contains the lookup value.You can lookup values such as text, numbers or characters.

(b) Discuss why it is necessary to handle missing values. Use Python program to identify the variables with missing values in the given dataset. [No more than 200 words (including in-text citation, excluding Python code)] (15 marks)

In which of the following step the missing values are addressed ?  A. Data Cleaning  B. Data Collection  C. Data Arrangement  D. Data Gathering