Listen. What feature could you use to automatically shade cells containing a negative value in red?
A) Fill Color
B) Conditional Formatting
C) Orientation
D) Sort & Filter
Answer (2)
The correct feature to shade cells with negative values in red is Conditional Formatting. This tool allows users to apply formatting rules to easily identify specific data points. Following the steps for applying Conditional Formatting ensures that negative values are visually distinct within the dataset.
;
The feature used to automatically shade cells containing a negative value in red is Conditional Formatting. This allows for a quick visual identification of negative values in data sets. By applying this feature, users can enhance their data analysis capabilities. ;
