"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

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

The____________ is the midpoint of the values after they have been ordered from the smallest to the largest.Question 2Answera.lowerb.modec.meand.median

Explain the functions used for Calculating the following for a Column in MS-Excel:  a)Averageb)Total b)Minimum c)Maximum[5]

4 sentences explaining which of mean, median, mode and range works best for calculating the middle of your set of numbers.

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