Question

b) Which tool helps in formatting selected cells on the basis of defined rule or
condition?​

Answer 1

Explanation:

Go to the Home tab > Styles group and click Conditional Formatting. You will see a number of different formatting rules, including data bars, color scales and icon sets. Since we need to apply conditional formatting only to the numbers less than 0, we choose Highlight Cells Rules > Less Than...

Answer 2

Explanation:

told help in fermenting selected cell on the basis of refund rule or conducted