FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Grouped Spreadsheets You cannot use Conditional Formatting when you are in Group Mode.

Detailed explanation-2: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.

Detailed explanation-3: -Detailed Solution. The correct answer is “ALT".

Detailed explanation-4: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.