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

Question

Quizplus · Accepted Answer

The Answer of 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

Match Each of the Following Terms to Its Definition