Computer Science, asked by moaarmyj, 4 months ago

………………………….. lets us format cells based on a specific condition.
(excel)
pls answer​

Answers

Answered by Anonymous
0

Answer:

\star\:\:\bf\large\underline\blue{Question:-}

Question:−

Simplify the problem.

\star\:\:\bf\large\underline\blue{Solution:-}

Solution:−

\sqrt{a + b + 2x + 2 \sqrt{ab + (a + b)x + {x}^{2} } }

Now, let

y = \sqrt{ab + (a + b)x + {x}^{2} }y=

Therefore,

\sqrt{a + b + 2x + 2 \sqrt{ab + (a + b)x + {x}^{2} } }

= \sqrt{a + b + 2x + 2 + 2 \sqrt{y} }=

Now, we will factorise y.

\sqrt{ab + (a + b)x + {x}^{2} }

= \sqrt{ab + ax + bx + {x}^{2} }=

= \sqrt{a(b + x) +x(b+ x)}=

= \sqrt{(x + a)(x + b)}=

Now,

= \sqrt{a + b + 2x + 2 + 2 \sqrt{y} }=

= \small\sqrt{(x + a) + (x + b) + 2 \sqrt{(x + a)(x + b)} }=

= \sqrt{ {( \sqrt{x + a}) }^{2} + {( \sqrt{(x + b} )}^{2} + 2 \times \sqrt{(x + a} \times \sqrt{(x + b)} }=

= \sqrt{ {( \sqrt{x + a} + \sqrt{x + b} )}^{2} }=

= \sqrt{x + a} + \sqrt{x + b}=

\star\:\:\bf\large\underline\blue{Answer:-}

\sqrt{x + a } + \sqrt{x + b}

Answered by ROCKYCEO
0

Answer:

Explanation:

Excel formulas for conditional formatting based on cell value

Select the cells you want to format. ...

On the Home tab, in the Styles group, click Conditional formatting > New Rule…

In the New Formatting Rule window, select Use a formula to determine which cells to format.

Enter the formula in the corresponding box.

Similar questions