4
AssignmentMultiple Choice

Use Spreadsheet Functions and Formulas

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

Which of the following best defines a nested IF statement?

Answer
A
formatting that applies to a cell if specific conditions are met
B
a function used to test if a specific condition is true or false
C
an IF function within an IF function
D
specifications to prevent modifications to data

Explanation

A nested IF statement is an IF function placed inside another IF function. This lets a formula test additional conditions when an earlier condition is met or not met. Choice C, “an IF function within an IF function,” gives the definition; choice B describes a basic IF function.

AI-written and checked against the verified answer.