You can check the conditions against __________ when applying conditional formatting*Cell valueFormulaBoth of aboveNone of above

Which feature allows you to format cells based on their values? aCharting bCell Formatting cConditional Formatting dData Validation

Conditional formatting can format the values above the average only, turning the cell and the font to a different view  when checked. This can be turned on and off with a grouping button True False

A cell can be formatted to only accept integers True False

"In conditional formatting, TOP and BOTTOM rules determine how the cells will appear according to _______."the value in the cellthe highest and lowest figuresthe reference cell in the top and bottomthe median and the mean

In the hospital charges dataset, take a column with a numeric variable (say, Average Medicare Payments). Using conditional formatting, attempt the following tasks:Fill the column in any one colour (red or green) so that the highest value has a darker shade of the colour and the lowest value has the lightest shade of the same colour. Fill the column in red and green so that the values above a certain number (say 5000) are highlighted in a gradient of red, and the ones below the number are highlighted in a gradient of green.Is it possible to do the second task? Mention the reason.