5 Heatmaps are visual representation of data and shows the magnitude of a phenomenon Which of the following technique in conditional formatting is known as heat maps A Data Bars B Colors scales C

Correct Answer:

B. Colors scales

Analyzing the Answer：

Color scales in conditional formatting use a gradient of colors to represent the magnitude of data. This directly corresponds to the definition of a heatmap, which visually represents data magnitude using color intensity.

Analysis of other options：

A. Data Bars: Data bars display bars within each cell, representing the relative magnitude of the data. While helpful for visualization, they don’t use a continuous color gradient like heatmaps.

C. Icon Sets: Icon sets use icons to represent data ranges, not a continuous color scale.

D. Bottom/top values: This highlights only the top or bottom values in a dataset, not the magnitude across the entire dataset as a heatmap does.