The image below shows the Time Codes worksheet.The following VLOOKUP function was entered into the Base Data worksheet which is in the same workbook as the Time Codes worksheet:

=VLOOKUP(A3,'Time Codes'!A1:C8,4,"TRUE")

Assume the value entered into cell A3 on the Base Data worksheet is the number 4 and that this function will be copied and pasted to other cells on the worksheet.Select any flaws in this VLOOKUP function from the list below.Select all that apply.

A. There should be an absolute reference added to cell A3 in the lookup_value argument.

B. There should not be any quotation marks around the word TRUE in the [range_lookup] argument.

C. The [range_lookup] argument can only be defined with either the number 1 or zero.

D. The value used to define the col_index_num argument is not valid and cannot be greater than 3.

E. The data in the Time Codes worksheet must be sorted in descending order based on the column used to define the col_index_num argument.

F. There should be an absolute reference around the range A1:C8 in the table_array argument.

\f