In Microsoft Excel,the function that looks up a value in a table is ________.

A) AVERAGE(condition 1,condition 2 ...)
B) IF(condition,value if true,value if false)
C) VLOOKUP(value,table range,column number)
D) COUNTIF(range,criteria)

VLOOKUP

A function in spreadsheet programs that searches for a value in the first column of a table and returns a value in the same row from a specified column.

Table Range

The difference between the highest and lowest values in a table, often used in data analysis to understand the variability within the data.

AVERAGE

AVERAGE refers to the mathematical mean, which is the sum of a list of numbers divided by the count of numbers in the list.