Question

When working with spreadsheets, which function is commonly used to retrieve information from more than one column in a table?

A) SUM
B) AVERAGE
C) VLOOKUP
D) COUNTIF

Answer 1

The VLOOKUP function is commonly used to retrieve information from more than one column in a spreadsheet table.

Step-by-step explanation:

In spreadsheets, the function commonly used to retrieve information from more than one column in a table is the VLOOKUP function. VLOOKUP stands for 'Vertical Lookup' and is used to search for a specific value in the leftmost column of a table and retrieve information from a different column in the same row.

For example, if you have a table with two columns - 'Name' and 'Age' - and you want to retrieve the age of a specific person, you can use the VLOOKUP function to search for their name in the 'Name' column and retrieve the corresponding age from the 'Age' column.