Match the example by replacing the ??? with the proper function:
i. =???(B79,"Bigger","Smaller")
II. =???(12% / 12,360,-120000)
III. =???(A4,B4:F9,2)
IV. =???(B9:E21)
v. =???()
A) NOW
B) PMT
C) VLOOKUP
D) IF
E) SUM

Question

Match the example by replacing the ??? with the proper function:
i. =???(B7>9,"Bigger","Smaller")
II. =???(12% / 12,360,-120000)
III. =???(A4,B4:F9,2)
IV. =???(B9:E21)
v. =???()
A) NOW
B) PMT
C) VLOOKUP
D) IF
E) SUM

Quizplus · Accepted Answer

The functions match as follows:  i. IF - checks a condition and returns one value if true and another if false.  II. PMT - calculates the payment for a loan based on constant payments and a constant interest rate.  III. VLOOKUP - looks for a value in the first column of a range and returns a value in the same row from a specified column.  IV. SUM - adds all the numbers in a range of cells.  v. NOW - returns the current date and time.

Match the Example by Replacing the ??? with the Proper