Which of the following best describes the HLOOKUP function?

Group of answer choices

Looks up a value in a lookup table where the first column contains the values to compare with the lookup value

Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value

The periodic interest rate, such as a monthly interest rate

Calculates the periodic payment for a loan with a fixed interest rate and fixed term