Assigns a value to a cell based on a logical test.

A) NOW function
B) Fill Formatting Only
C) goal seeking
D) what-if analysis
E) NUM!
F) #NAME?
G) Keep Source Formatting
H) Fill Series
I) IF function
J) absolute cell referencing

IF Function

A logical function in programming and spreadsheet software that returns one value if a condition is true and another value if the condition is false.

Logical Test

A logical test is an operation in computer programming and spreadsheet applications that evaluates a condition and returns a true or false outcome based on the logic defined.