Quiz

  1. 1
    Intermediate

    What do Excel’s Outlining Tools do?

  2. 2
    Intermediate

    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
    Intermediate

    Suppose rows 10:12 are grouped, as are rows 20:40 and 25:30. Which is the best method to show all the data rows?