What do Excel’s Outlining Tools do?

Answer 1

Draw borders around data.

Answer 2

Hide rows and columns from users

Answer 3

Allow you to group and compress spreadsheet sections via easy to use controls

Answer 4

Don’t know

Answer 5

B25 has a top border and B27 has a top border

Answer 6

Both the top and bottom border are applied on B26

Answer 7

B25 and B26 both have bottom borders only.

Answer 8

Don’t know

Answer 9

Click all the little + icons

Answer 10

Click the 3 in the outline

Answer 11

Go to the Data tab and choose Ungroup > Clear Outline

Answer 12

Don’t know

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?