Question

5. Which of the following feature is used to format data in one or morecells according to a specified
condition?
O (a) Sorting
O (b) Work area
O (c) Conditional Formatting
0 (d) Formula bar​

Answer 1

Answer:

conditional formatting

Answer 2

The conditional formatting does formatting based on the given conditions.

Explanation:

• The conditional feature is used to format data in cells according to the conditions "If” statement as the base like “If the condition is true” “then apply the format to the cell” or else skip.
• The conditional formatting does formatting based on the given conditions.
• If the condition is satisfied then the formating is executed, if the condition is not satisfied then the formatting is not done.
• Hence, the correct option is an option (c).