Quiz

  1. 1
    Intermediate

    What do Excel’s Outlining Tools do?

  2. 2
    Intermediate

    Assume that B24:B25 are grouped so that when you can compress them to show the value in B26. When expanded, B26 has a top and bottom border on the cell. When compressed the top border disappears, but the bottom one doesn’t. Where are the borders applied?

  3. 3
    Intermediate

    Assuming that rows 10:12 are grouped, that rows 20:40 are grouped, and rows 25:30 are also grouped, what is the best way to show all the data rows?