In the example, say grades F, D, C, B and A corresponded to ranges 0 to 59, 60 to 69, 70 to 79, 80 to 89 and 90 to 100, respectively. In this case, you would enter 60, 70, 80, 90 and 100 in cells ...

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.