Quiz 6 - VLOOKUP() Function - AIS

Refer to the Excel worksheet, above. What will the formula, =VLOOKUP(4001,Chart_Accts,3,FALSE) return?

A- #N/A

What does the formula, =VLOOKUP(4001,Chart_Accts,3,FALSE) do?

B- Search for the exact value 4001 in the first column of the table labeled Chart_Accts and return the value in the 3rd column of the corresponding row if the search value is found, or #N/A if the search value is not found NO- C- Search for the value 4001 in the 3rd column of the table named Chart_Accts and return the contents of the first column if the search value is found, or #N/A if the search value is not found NO- D- Returns the cell reference of the cell 3 columns to the right of the value 4001 if that cell is blank (FALSE).

Refer to the Excel worksheet, above. Which of the following formulas will return the value, inc_stmt?

C- VLOOKUP(4002,Chart_Accts,4,TRUE)

Refer to the Excel worksheet, above. If the name, Chart_Accts is defined as: =Sheet1!$A$1:$D$12, which of the following is correct?

C- the names typed into the first row are treated as data within the range, not as column labels

Refer to the Excel worksheet, above. What will the formula, =VLOOKUP(4001,Chart_Accts,3) return?

NO- B- #NAME? NO- C- Event Merchandise Sales D- credit