Question

The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is: Group of answer choices A fuzzy match An approximate match An exact match None of the answer sections are correct

Answer 1

Answer:

An approximate match

Step-by-step explanation:

The vlookup (vertical lookup) function is a search function in excel used in locating values in an excel table.

The vlookup syntax is written as:

=VLOOKUP(value, table, col_index, [range_lookup])

The range_lookup is an optional parameter which is used to indicate if the search should be for an exact match or approximate match. Since a column, resort fee will be used as a possible additional cost; the search would be required to return an approximate search rather than an exact match in other for the search condition to be adequately implemented.

Answer 2

The type of match to use in a Vlookup() function to assess the resort fee as a possible additional cost for a particular room is

• B. An approximate match

An Approximate Match

This refers to the possible cost when the Vlookup() function is used as it is used as a search function to find the values which are in a database table.

With this in mind, we can see that the syntax looks like:

• VLOOKUP(value, table, col_index, [range_lookup])

Therefore, the correct answer is option B

Read more about approximate match here:

https://brainly.com/question/17125750