USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
data bar
|
|
|
theme
|
|
|
highlight cells rule
|
|
|
icon sets
|
Detailed explanation-1: -Data Bars in Excel are an inbuilt type of conditional formatting that inserts colored bars inside a cell to show how a given cell value compares to others. Longer bars represent higher values and shorter bars represent smaller values.
Detailed explanation-2: -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.
Detailed explanation-3: -Formulas to compare values (numbers and text) In a similar fashion, you can create a conditional formatting rule to compare values of two cells. For example: =$A2<$B2-format cells or rows if a value in column A is less than the corresponding value in column B.