Jamal is using Excel to create his Gantt chart. As he enters his critical path, the bars change to a red color. Which function did he use to make this happen?Select an answer:He used the Conditional Formatting feature.He colored the bars as he went along.He used the Format as Table feature.He used a formula of "Less Than Zero," and then chose red.

Garry is struggling to read his bar graph. He has labelled the numbers at the side, but what else should he have done?a.Label each bar along the bottomb.Turned the graph upside downc.Made all the bars bigger to see them clearlyd.Color them neatly

A blue bar in the Gantt chart indicates:

Elijah works in a local coffee shop that sells baked goods. He is given a table that has the baked goods listed along the X-axis and the months of the year along the Y-axis. The table shows the profit that the baked goods made that month. Elijah wants to quickly spot which month the baked goods did the best, when all baked goods and months are considered. He thinks that adding some color to the table might help. What type of chart should he create? Pie chartStacked bar chartBar chartHeat map

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.

Question 7In the image below, what does hovering over the “green bar” show us? 1 pointThe proportion of rows with valid, empty and error values in the column “revenue”A histogram of the column, “revenue”A comprehensive set of plots about the distribution of the column, and its relationship with other columnsNone of these