USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not a valid conditional format?
|
|
Display cell text in a different font if the cell value is greater than 10, 000.
|
|
|
Display a color that could range from dark green to dark red, with lighter shades between these two extremes, depending on the numeric value in the cell.
|
|
|
Display a dark gray background color if the cell contains a text string with the text string “con” in it.
|
|
|
Display an icon set that resembles a pie, with a solid black circle representing the largest values in the range to a solid white circle for the smallest value, with varying portions of black and white for values in between.
|
Explanation:
Detailed explanation-1: -Solution(By Examveda Team) In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.
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: -Not all format items are available in Conditional Formatting. For example, you cannot change the Font or Font Size with Conditional Formatting.
There is 1 question to complete.