25
QuizMultiple Choice

Unit Test — Unit test

Question 25 • CHS- TX-Professional Communications (CR)

Lookup functions allow spreadsheet users to

Answer
A
show quantities of distinct, discrete categories of data.
B
present data that changes as a function of time.
C
keep track of IF statements and nested IF statements.
D
reduce the amount of manual searching and data entry.

Explanation

Lookup functions search for a value in a table or range and return related information. This reduces the need to search through data manually and enter matching values by hand. Therefore, the correct choice is reduce the amount of manual searching and data entry.

AI-written and checked against the verified answer.