Identify the letter of the choice that best matches the phrase or definition.
-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

Question

Quizplus · Accepted Answer

The IF function is used in Excel to perform a logical test and then assigns a value to a cell based on whether the test was true or false.

Identify the Letter of the Choice That Best Matches the Phrase