Match Each of the Following Terms to Its Definition

Multiple Choice

Match each of the following terms to its definition:
i.logical test
II.IF function
III.comparison operator
IV.conditional format
v.data bar

A) checks whether a condition is met and returns a true or false value
B) compares values in an Excel function or formula
C) formatting applied to a cell based on a criteria
D) a shaded bar that provides a visual cue about the value of a cell relative to other cells
E) any value or expression with a true or false result