1. 1

    What do Excel’s Outlining Tools do?

  2. 2

    Suppose cells B24:B25 are grouped so they can be compressed 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 these borders applied?

  3. 3

    Suppose rows 4:9 are grouped, as are rows 10:32, 12:17, 18:24 and 25:31. Which is the best method to show all the data rows?