Question

For a VLOOKUP and HLOOKUP, data must be arranged in rows and columns, also known as ______________. A) Grid B) Matrix C) Array D) Spreadsheet

Answer 1

For a VLOOKUP and HLOOKUP, data must be arranged in rows and columns, also known as array. Therefore, the correct option is C).

Step-by-step explanation:

For a VLOOKUP and HLOOKUP, data must be arranged in rows and columns, which is also known as a C) Array. This term can be used interchangeably in the context of Excel with grid, matrix, or spreadsheet, but in this specific context, the correct answer as provided is an array. These functions are designed to search vertically (VLOOKUP) or horizontally (HLOOKUP) through a specific range or an 'array' of cells to find a match and return a corresponding value from another column or row.

The specific term 'array' is used to refer to the organized set of rows and columns that these functions search through to find and retrieve information.

Therefore, the correct option is C).