What do Excel’s Outlining Tools do?

Answer 1

Allow spreadsheet sections to be grouped and compressed via easy-to-use controls

Answer 2

Hide rows and columns from users

Answer 3

Draw borders around data

Answer 4

Don’t know

Answer 5

B25 and B26 both have bottom borders only

Answer 6

B25 has a top border and B27 has a top border

Answer 7

Both the top and bottom border are applied on B26

Answer 8

Don’t know

Answer 9

Click all the little + icons

Answer 10

Go to the Data tab and choose Ungroup and then Clear Outline

Answer 11

Click the 3 in the outline

Answer 12

Don’t know

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?