A data bar
A) highlights cells meeting specified criteria with a specified color, font, or border.
B) calculates an aggregate for values in a range or database.
C) formats the bar data in preparation for printing.
D) is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

Question

Quizplus · Accepted Answer

A data bar in Excel visually represents the value in a cell relative to other cells by filling it with a horizontal gradient or solid fill. This helps in quickly comparing the magnitude of values in a range of cells. Options A, B, and C describe Conditional Formatting, aggregate functions, and print preparation, respectively, not data bars.

A Data Bar